Page 1 of 1

Proper Way to Cluster Server

PostPosted: Sat Sep 24, 2016 10:07 pm
by 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 ??

Re: Proper Way to Cluster Server

PostPosted: Sun Sep 25, 2016 5:13 am
by 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.

Re: Proper Way to Cluster Server

PostPosted: Sun Sep 25, 2016 10:02 am
by 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 ....

Re: Proper Way to Cluster Server

PostPosted: Tue Sep 27, 2016 8:43 am
by 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) ??