Mysql Cluster over VPN

[bacterie]

Hello,

First, let me thank you for the great work that you are doing.

I'm trying to set up a Mysql Cluster over AWS instances, but due to the limitations of Amazon(single ip /instance) i cannot use a virtual IP.
So, i decided to setup a VPN network first so i can have all the IP that i need.

I set up the VPN, all works fine regarding it.

I followed the instructions in http://www.howtoforge.com/loadbalanc...cluster_debian in order to set up the cluster.

I used debian lenny for the setup.

The following IP addresses are used:
192.168.201.1 -load balancer
192.168.201.6 -sql1
192.168.201.10-sql2
192.168.201.100- Virtual IP

On the load balacer node (only one, which is also the OpenVPN server ) i have the following:

ha.cf

logfacility local0
bcast tun0
mcast tun0 225.0.0.1 694 1 0
auto_failback off
node <name provided by uname -n for this amazon instance>
node loadb2
respawn hacluster /usr/lib/heartbeat/ipfail
apiauth ipfail gid=haclient uid=hacluster

haresources

<name provided by uname -n for this amazon instance> \
ldirectord::ldirectord.cf \
LVSSyncDaemonSwap::master \
IPaddr2::192.168.201.100/24/tun0/192.168.201.255

ldirectord.cf

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

virtual = 192.168.201.100:3306
service = mysql
real = 192.168.201.6:3306 gate
real = 192.168.201.10:3306 gate
checktype = negotiate
login = "ldirector"
passwd = "ldirectorpassword121"
database = "ldirectordb"
request = "SELECT * FROM connectioncheck"
scheduler = wrr

A few checks reveal:

ip addr sh tun0

3: tun0: <POINTOPOINT,MULTICAST,NOARP,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UNKNOWN qlen 100
link/[65534]
inet 192.168.201.1 peer 192.168.201.2/32 scope global tun0
inet 192.168.201.100/24 brd 192.168.201.255 scope global tun0

ipvsadm -L -n

IP Virtual Server version 1.2.1 (size=4096)
Prot LocalAddress:Port Scheduler Flags
-> RemoteAddress:Port Forward Weight ActiveConn InActConn
TCP 192.168.201.100:3306 wrr
-> 192.168.201.6:3306 Route 1 0 0
-> 192.168.201.10:3306 Route 1 0 0

/etc/ha.d/resource.d/LVSSyncDaemonSwap master status
master running
(ipvs_syncmaster pid: 1474)

ldirectord ldirectord.cf status
ldirectord for /etc/ha.d/ldirectord.cf is running with pid: 1391

However, when i try to connect to the virtual ip i get the following

mysql -h 192.168.201.100 -u ldirector -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.201.100' (111)

What am i doing wrong? Is The fact that i'm running it over VPN?
Thanks,
Catalin