Error with mcast interface

[javafun]

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

[falko]

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

[javafun]

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?

[javafun]

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

[javafun]

falko can u give me some help? thanks

[falko]

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?

Please post the output of iptables -L on your nodes.

[javafun]

Here is the result

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

[javafun]

I think I'd better to attach some other settings

Load balancer 1 settings

/etc/ha.d/ldirectord.cf


# 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


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


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


lb1:~# nano /etc/network/Interfaces


# 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

net.ipv4.ip_forward = 1


Load balancer 2

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


# 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

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

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


nano /etc/network/interfaces

# 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

net.ipv4.ip_forward = 1