[Rocks-Discuss] mysql connection question

[János Löbb]

HI,

I had to change IP address of the front end of my test cluster from 10.84.2.46 to 10.84.2.80. Of course I had to change hostnames too.

I did the hostname change wuth 'hostname' and to make it permanent I also modified

/etc/sysconfig/network
/etc/hosts

and used

rocks set hosts ip and name to change the names and IP for the frontend on both eth0 and eth1. I was unable to change the host attribute, so it still shows up as bml0046 instead of bml0080. for both eth0 and eth1.

How can I change that one.

after reboot, when centos boots it still wants to use the bml0046.yalepath.org FQDN and the 10.84.2.46 IP on the public network, that is on eth1.

Looking into /etc/sysconfig/networking/profiles/default i see an ifcfg-eth1 file thet contains the old IP address.

Should this one already been updated by rocks sync config ?

My next step is to modify this file manually. Is that the right thing to do ? Yes, I know I have to make modification to network also in this directory. Any other file in the filesystem I should make a change ?

I am also unable to connect to mysql. I tried the following as root:

mysql -hlocalhost -uroot -p
ERROR 2002 (HY00): Can't connect to local MySql server through socket '/var/lib/mysql/mysql.sock' (2)

mysql -h127.0.0.1 -uroot -p
ERROR 2003 (HY000): Can't connect to Mysql server on '127.0.0.1' (111)

mysql -uroot -p
ERROR 2002 (HY00): Can't connect to local MySql server through socket '/var/lib/mysql/mysql.sock' (2)

mysql -hbml0080.yalepath.org -uroot -p
ERROR 2003 (HY000): Can't connect to Mysql server on 'bml0080.yalepath.org' (101)

It is possible that because there is no networking on eth1, all above connection types are by default futal.

Help :-))

Thanks ahead,

János

[Philip Papadopoulos]

1. The names of hosts are kept in the networks table. You want to look at
the set of
"rocks set host interface" command. You can set names, interfaces, etc.

1b. for the frontend, we also keep some information in the attributes.
Do a "rocks list attr" to see attrs and values and look for the ip address.
You can change with "rocks set attr"

2. mysql (the system version) is not setup by Rocks. We compile our own
version (foundation-mysql) and have it operate on a separate port. try
/opt/rocks/bin/mysql to check connectivity to the rocks DB

-P

--
Philip Papadopoulos, PhD
University of California, San Diego
858-822-3628 (Ofc)
619-331-2990 (Fax)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://lists.sdsc.edu/pipermail/npaci-rocks-discussion/attachments/20120203/430daa04/attachment.html