*SOLVED* Can't connect to mysql in VE [message #8603] |
Wed, 29 November 2006 04:09 ![Go to next message Go to next message](/theme/ovz3/images/down.png) |
Pradeep Padala
Messages: 18 Registered: June 2006
|
Junior Member |
|
|
Hi,
I have two VEs setup correctly and I am running mysql daemon in one VE. I can connect to the mysql daemon from HN but cannot connect to it from the other VE or from outside. On the other hand, I can ping the machine and even ssh into it. The setup is as follow.
I assign 15.25.117.{48,49} to the VEs and 15.25.117.31 is the HN's ip address.
Run mysql in 15.25.117.49. Now, in 15.25.117.48
-bash-3.1# mysql -h15.25.117.49 -utest_rubis
ERROR 2003 (HY000): Can't connect to MySQL server on '15.25.117.49' (113)
On 15.25.117.31
[root@acts-01-eth1 ~]# mysql -h15.25.117.49 -utest_rubis
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 5.0.27-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
Let me know how to fix this problem. Thanks !
Pradeep
[Updated on: Thu, 30 November 2006 06:50] by Moderator Report message to a moderator
|
|
|
|
|
Re: Can't connect to mysql in VE [message #8628 is a reply to message #8603] |
Wed, 29 November 2006 17:08 ![Go to previous message Go to previous message](/theme/ovz3/images/up.png) ![Go to next message Go to next message](/theme/ovz3/images/down.png) |
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
|
|
|
|
|