Add Slave Database server to Standalone server.

[zenithbsolutions]

Hi,

I'm having a vicidial standalone server installed through vicibox-9.0.1 express installed with below SVN

VERSION: 2.14-733a
BUILD: 200115-1702
© 2020 ViciDial Group

We have a sound board configured and was running fine but if we increase the number of agents or dial level the CPU load spikes to 120% and there are audio prompt delays and break in audio prompts. So we thought of adding up a slave database server to reduce the CPU load.

We have tried to install a slave server to the standalone but it couldn't connect to the standalone database for some reason. Here is the output of the error

vicibox-install


ViciBox v.9.0 Installer


Do you want to continue with the ViciBox install? [y/N] : y

Do you want to enable expert installation? [y/N] : y

The Internal IP address found was 192.168.159.142.
Do you want to use this IP address for ViciDial? [Y/n] : y

Will this server be used as the Database? [y/N] : y
---> Will this be a Slave Databse? [y/N] : y

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

I have the default username as cron and password as 1234

Kindly correct me If I'm wrong and suggest me the best option to reduce my CPU load and let me know if its possible to add a slave database server or application server or asterisk server to standalone server.

Thank you

[williamconley]

on the new server after the OS is installed but before installing Vicidial ...

Code: Select all

mysql -u cron -p1234 -h 192.168.159.142 asterisk


Until this succeeds, that install will always fail. Is the firewall open? Is the cron mysql user allowed to connect from "any" or {the other server's} IP address?

Note that you may want to stop using "express". Just use the standard vicibox installer. Express has been known to lag in bug fixes by a bit since the standard installer is more widely used. And it's not more difficult really, just a few more questions to which you likely know the answer (or can just use the default answer, if you're not sure).