MySQL Connection Problems

Portal Home > Knowledgebase > Articles Database > MySQL Connection Problems

Posted by zymic, 03-18-2008, 12:03 PM
Hello, We have a front end server for the website Zymic.com (a free web hosting community), a mysql server and a main server for hosted websites. The problem lies between establishing a connection from the Zymic.com server to the database server - to sum it up, the connection just "hangs". We have never had this problem before, never edited anything which would cause a problem, its completely spontaneous. My administrator has spent endless hours trying to debug the problem, here are some notes he gave me: 1. Ping to the mysql machine works fine. 2. Telnet to port 3306 of the mysql machine works great too meaning NOT a network issue. 3. Strace on the connection shows it hangs when it calls the server and waits endlessly for response. 4. The mysql machine listens to the IP and port 3306 and connects great to the hosting server via SSH. 5. It's NOT a max connection issue but something to do with the mysql socket itself. Here is a test from another site on the server to the mysql server: http://hidemyass.com/mysql.php I will award someone some nice $$$ if you help me find a possible fix. Thanks
Posted by Patrick, 03-18-2008, 12:11 PM
Not to ask the obvious, but have you double checked that the IP addresses are added to the access hosts for the MySQL user trying to authenticate?
Posted by zeeshannaqvi, 03-18-2008, 12:21 PM
I agree with Pat. There might be some authentication issue. Take a look if wkscript user has access to connect to 75.126.138.74 host.
Posted by zymic, 03-18-2008, 12:24 PM
This is not the issue, sorry - the IP's are fine.
Posted by zeeshannaqvi, 03-18-2008, 12:29 PM
What is the error message you get from it ?
Posted by zymic, 03-18-2008, 12:31 PM
There is no error message; the connection just "hangs". I have contacted a couple of administration companies to see if they have any answers. Thanks for the help so far, I know its limited as you don't have access to my servers.
Posted by zeeshannaqvi, 03-18-2008, 12:34 PM
can you give me a limited ftp access so that i can try looking into the problem ?
Posted by Patrick, 03-18-2008, 12:35 PM
Post the contents of /etc/my.cnf and have you checked the MySQL error logs to see if anything is being logged in regards to this error message?
Posted by Panopta, 03-18-2008, 12:42 PM
Also make sure you've got reverse DNS setup for the IP you're coming from - oftentimes, authentication processes can hang on the reverse lookup if it hasn't been setup correctly.
Posted by tix3, 03-18-2008, 02:56 PM
Mayde the user (wkscript) is allowed to connect only from localhost?
Posted by JulesR, 03-18-2008, 03:02 PM
Output of netstat -pant ?

Add to Favourites Print this Article