Proper Way to Cluster Server

[iboam]

Hi everyone, im installing a cluster server 1 DB/WEB and 2 Telephony/Archive. in this case i have 3 Lan Interfaces em1, em2 and eth0

82576 Gigabit Network Connection│NONE │em1
82576 Gigabit Network Connection│XXX.XXX.XXX.21│em2
Ethernet Network Card│DHCP │eth0 │

Routing:
Default IPv4 Gateway: XXX.XXX.XXX.1
Device: em2

eth0 is LAN interface it's in internal zone and em2 is WAN interface and it's in external zone

when try to install the dialer server

Please input the master database IP address (XXX.XXX.XXX.20) : XXX.XXX.XXX.20
Do you want to connect using the default ViciDial DB settings? [Y/n] : y
DBI connect('asterisk:XXX.XXX.XXX.20:3306','cron',...) failed: Can't connect to MySQL server on 'XXX.XXX.XXX.20' (111 "Connection refused") at /usr/local/bin/vicibox-install line 1253.
Couldn't connect to ViciDial database: Can't connect to MySQL server on 'XXX.XXX.XXX.20' (111 "Connection refused") at /usr/local/bin/vicibox-install line 1253, <STDIN> line 7.

both servers are in the same Lan
Any Solution ??

[Vince-0]

Why would you install the dialer on the WAN network?

You can get mysql to connect from command line with:

mysql -p --host=XXX.XXX.XXX.20

Once that works, the script will work.

[iboam]

Why would you install the dialer on the WAN network?

The servers are in a remote location, the eth0 has no connection to the internet this is the one for the IPKVM only so can't ping google. all Gigabit LAN interfaces are connected to the internet. if anything of this does not matter please letme know.

:~ # mysql -p --host=XXX.XXX.XXX.20
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'XXX.XXX.XXX.20' (using password: YES)

what is the password for mysql ?? i tried leave in blank and the root password of the server ....

[iboam]

em2 it's connected to the internet

82576 Gigabit Network Connection│XXX.XXX.XXX.21│em2

this Lan interface should be internal or external in the Server 1 (DB/WEB) ??