Error with mcast interface

I follow this article(http://www.howtoforge.com/loadbalanced_mysql_cluster_debian_p6) to configure mysql cluster with load balancing, but after I restart the load balancing server, I receive this error message

error setting outbound mcast interface


my current enviroment is

mysql1, ip 192.168.1.170
mysql2, ip 192.168.1.171

load1, ip 192.168.1.178 (virtual ip is 192.168.1.177)
load2, ip 192.168.1.179

I don't know what mcast should I use

logfacility local0
bcast eth0
mcast eth0 225.0.0.1 694 1 0
auto_failback off
node loadb1
node loadb2
respawn hacluster /usr/lib/heartbeat/ipfail
apiauth ipfail gid=haclient uid=hacluster

 

Might be a firewall issue. Are you using a firewall on your nodes?

 

Thanks for your reply

I am not sure how can I check firewall setting ? I am a newbine to Linux, can you tell me who can I check it? and how can I turn that off?

 

I also have another question when I use
/etc/ha.d/resource.d/LVSSyncDaemonSwap master status to check both load balancing server status, I found both of them are "master stopped", can you tell me which step I might do wrong that will cause this problem....? thanks again

 

falko can u give me some help? thanks

 

Please post the output of

Code:

iptables -L

on your nodes.

 

Here is the result

Code:

Chain INPUT (policy ACCEPT)
target     prot opt source               destination

Chain FORWARD (policy ACCEPT)
target     prot opt source               destination

Chain OUTPUT (policy ACCEPT)
target     prot opt source               destination

 

I think I'd better to attach some other settings

Load balancer 1 settings

/etc/ha.d/ldirectord.cf

Code:

# Global Directives
checktimeout=10
checkinterval=2
autoreload=no
logfile="local0"
quiescent=yes

virtual = 192.168.1.177:3306
        service = mysql
        real = 192.168.1.170:3306 gate
        real = 192.168.1.171:3306 gate
        checktype = negotiate
        login = "ldirector"
        passwd = "ldirectorpassword"
        database = "ldirectordb"
        request = "SELECT * FROM connectioncheck"
        scheduler = wrr

lb1:~# cat /etc/ha.d/ha.cf

Code:

logfacility        local0
bcast        eth1
mcast eth1 225.0.0.1 694 1 0
auto_failback off
node        lb1
node        lb2
respawn hacluster /usr/lib/heartbeat/ipfail
apiauth ipfail gid=haclient uid=hacluster

lb1:~# cat /etc/ha.d/haresources

Code:

lb1        \
        ldirectord::ldirectord.cf \
        LVSSyncDaemonSwap::master \
        IPaddr2::192.168.1.177/24/eth1/192.168.1.255

lb1:~# nano /etc/network/Interfaces

Code:

# This file describes the network interfaces available on your system
# and how to activate them. For more information, see interfaces(5).

# The loopback network interface
auto lo
iface lo inet loopback

# The primary network interface
allow-hotplug eth1
iface eth1 inet static
        address 192.168.1.178
        netmask 255.255.255.0
        gateway 192.168.1.1

auto eth1:1
iface eth1:1 inet static
        address 192.168.1.177
        netmask 255.255.255.255
        gateway 192.168.1.1

lb1:~# sysctl -p

Code:

net.ipv4.ip_forward = 1

Load balancer 2

lb2:~# cat /etc/ha.d/ldirectord.cf

Code:

# Global Directives
checktimeout=10
checkinterval=2
autoreload=no
logfile="local0"
quiescent=yes

virtual = 192.168.1.177:3306
        service = mysql
        real = 192.168.1.170:3306 gate
        real = 192.168.1.171:3306 gate
        checktype = negotiate
        login = "ldirector"
        passwd = "ldirectorpassword"
        database = "ldirectordb"
        request = "SELECT * FROM connectioncheck"
        scheduler = wrr

lb2:~# cat /etc/ha.d/ha.cf

Code:

logfacility        local0
bcast        eth1
mcast eth1 225.0.0.1 694 1 0
auto_failback off
node        lb1
node        lb2
respawn hacluster /usr/lib/heartbeat/ipfail
apiauth ipfail gid=haclient uid=hacluster

lb2:~# cat /etc/ha.d/haresources

Code:

lb1        \
        ldirectord::ldirectord.cf \
        LVSSyncDaemonSwap::master \
        IPaddr2::192.168.1.177/24/eth1/192.168.1.255

nano /etc/network/interfaces

Code:

# This file describes the network interfaces available on your system
# and how to activate them. For more information, see interfaces(5).

# The loopback network interface
auto lo
iface lo inet loopback

# The primary network interface
allow-hotplug eth1
iface eth1 inet static
        address 192.168.1.179
        netmask 255.255.255.0
        gateway 192.168.1.1

lb2:~# sysctl -p

Code:

net.ipv4.ip_forward = 1