Add Slave Database server to Standalone server.

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Add Slave Database server to Standalone server.

Postby zenithbsolutions » Thu Jan 23, 2020 3:26 am

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
zenithbsolutions
 
Posts: 122
Joined: Tue Aug 25, 2015 2:17 am

Re: Add Slave Database server to Standalone server.

Postby williamconley » Wed Jan 29, 2020 8:55 pm

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).
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to Support

Who is online

Users browsing this forum: No registered users and 84 guests