Issue 20: compute nodes of nema can't connect to mysql on nema
Status:  Verified
Owner:
Closed:  Jan 2010
Project Member Reported by kumarami...@gmail.com, Jan 24, 2010
The database (meandrestore) on nema has proper permission and I am able to
connect from other hosts. When I try and connect from the compute nodes
mysql client just hangs with no message. Can you help Dan -I am running out
of ideas, unless there is a specific iptables rule to deny access from
compute nodes?
Jan 25, 2010
Project Member #1 dtwri...@gmail.com
Fixed - the problem was in the mysql client config. For some reason ROCKS has the
client/server on cluster nodes set to use port 3307 by default, instead of the mysql
default (3306). I changed the default, but you should probably configure your
applications to connect to port 3306 explicitly in case this comes up again on other
cluster nodes.
Jan 25, 2010
Project Member #2 kumarami...@gmail.com
So when I try and use

mysql -u nema_user -pxxxxx  -h nema.lis.uiuc.edu -P 3306

on c-1-3


It still wouldn't connect.
Jan 25, 2010
Project Member #3 dtwri...@gmail.com
nema.lis.uiuc.edu is the 'outside world' interface, which you don't want to use from
inside the cluster. Just use 'nema' and it'll connect via the cluster LAN and work fine.
Jan 25, 2010
Project Member #4 kumarami...@gmail.com
Yes -that works great. Thanks.
Status: Verified