topic Re: Relocable IP address problem in Operating System - Linux

Relocable IP address problem

niki67 — Thu, 30 Oct 2008 08:57:58 GMT

Hi,
I have installed a ServiceGuard for Linux on 2 node server (with RedHat AS 4.5 x86_64), and I have created e configuration file for cluster. The configuration seems to be ok, because the cluster forming correctly. Then I have installed a toolkit package for MySQL and I have runned it. The package seems to be ok, because into the log file I do not have any error. On the node, were the package started, I see the MySQL process on and the port 3306 are in listen mode. Now I try to connect with database MySQL via MySQL GUI Administrator Software. The connection start, but after few second I loss the connection. The relocable IP used for the package are pingable, but if I try to telnet to the IP on port 3306, I have a connection refused.
Someone have an idea to resolve this problem ?
Thanks in advance, Nicola.

Re: Relocable IP address problem

Hemmetter — Thu, 30 Oct 2008 11:36:50 GMT

Hi Nicoloa,

mysql is probably linked against libwrap thus you need a /etc/hosts.allow entry like:

mysqld: "IP" : ALLOW

rgds
HGH

Re: Relocable IP address problem

niki67 — Thu, 30 Oct 2008 12:45:06 GMT

I find the solution. The problem was that I use the same Ip relocable address for two package that starting separately one on each node, but with the same IP.
Seems that is not possible in the cluster configuration with ServiceGuard.

Hi, Nicola.

Re: Relocable IP address problem

Serviceguard for Linux — Fri, 31 Oct 2008 13:41:45 GMT

To clarify: It is not possible for the following reason. If the package on one system failed it would try to fail over to the other system running the second package. These two cannot have the same IP address.