Hi

I have 2 centos5/32 VPS boxes at my provider. If it matters, they're both on OpenVZ.

BOX-A is a bare mysql server (no special other services installed)
BOX-B is a full lamp

I want to access the BOX-A mysql from BOX-B

Easy you might say, but I've tried so many things, it still won't connect. I assume my mysql on BOX-A is configured right.

I get stuck much earlier. Even a telnet from BOX-B to port 3306 on BOX-A gets a time out.

I've tried a lot of stuff in iptables, at the end I opened everything for everybody and I even removed the whole iptables service all way. It still doesn't work.

BOX-A is a test server so I cannot do anything too bad.
I reinstall it regularly.

Any suggestions?

Make sure you have not made a typo in the ip address. Make sure Box B can be reached from a manual telnet on that port. Maybe your provider has the port blocked for some reason.

Hi AuroraZero,

Thanks for your tips.
A wrong IP is however out of the question - I was very careful with that.


Both boxes come completely unmanaged and without any port restrictions or whatsoever.
For example I can ssh from BOX-B to BOX-A without problems
A normal telnet to that machine on 3306 gives a time out however.
I cannot get it out of my head that it has something to do with the openvz. ifconfig says i have a 'venet0' instead of a 'eth0' which I would expect.

Your provider controls that aspect and you are probably correct. The hardware firewall they have may also be the problem. Venet0 is basically a virtualized connection not a hardware one. The config of openvs most likely is the culprit and would have to be changed by the provider. Unless you try a different telnet port.

Use nmap to see if the server ports is open from the client perspective. I believe MySQL runs on port 3306. If the port is open and you are still having failure to connect issues, make sure that the server is configured to accept remote connections and the user name string will need to account for the remote host name too, either as user@host or by using a wild card.

Is mysqld running, listening, and configured to listen on the right address? ie: my.cnf: bind-address= & skip-networking ?
Can you connect to MySQL on the MySQL server locally? ie: You say that "I assume my mysql on BOX-A is configured right.", why? in my experience, whenever i assume i have something configured right, and it doesnt work, it usually aint.

Moved: This thread is more suitable in the Networking and has been moved accordingly to help your thread/question get the exposure it deserves.