Re: Can't connect to mysql in VE [message #8628 is a reply to message #8603] |
Wed, 29 November 2006 17:08   |
rickb
Messages: 368 Registered: October 2006
|
Senior Member |
|
|
To troubleshoot this, you should first use a low level debugging technique like tcpdump. This will establish whether the problem is on the network level or the application level. For example, in your VE:
# tcpdump -i venet0 dst port 3306
from the HN or wherever you want to connect to the mysqld server from, run in a seperate console:
# telnet VE_IP 3306
replace VE_IP with the IP address of your VE. If after running telnet, you see lines below your tcpdump then this succeeded, otherwise it failed.
-----------------
if this succeeds:
I doubt it will, but it must be a configuration in your mysqld. try backing up your data, uninstalling mysqld, and throwing a fresh mysqld rpm in there.
-----------------
if this fails:
check iptables on the HN and the VE. This is definately the problem especially considering you can ssh to the VE which means networking is working.
-------------
Common Terms I post with: http://wiki.openvz.org/Category:Definitions
UBC. Learn it, love it, live it: http://wiki.openvz.org/Proc/user_beancounters
|
|
|