"Add a New Server" for MySQL Server

[elyc1990]

I'm running Vicidial VERSION: 2.14-589a BUILD: 170217-1350. Installation method: scratch install, all in one server

Recently I set up a separate mysql server by exporting mysqldump and import it into new server. Then I configure /etc/astguiclient.conf to point VARDB_server to the ip of the new mysql server. Webserver was also separated out to another machine. Hence, now I'm running 3 separate servers - dialer, mysql and apache.

I just notice that we are supposed to "Add a new server" at Vicidial admin (Admin > Servers > Add a New Server) for mysql database. But the system seems to be running quite well without that. My question is, what's the reason to "add a new server"? And what would be the possible problem if I did not do it?

On a separate question, do I need to enable VARactive_keepalives at webserver for the the cron jobs below to work from webserver? Currently the VARactive_keepalives is X for my webserver.

### VICIDIAL agent time log weekly summary report generation
2 0 * * 0 /usr/share/astguiclient/AST_agent_week.pl
### fix the vicidial_agent_log once every hour and the full day run at night
33 * * * * /usr/share/astguiclient/AST_cleanup_agent_log.pl
50 0 * * * /usr/share/astguiclient/AST_cleanup_agent_log.pl --last-24hours
### updater for VICIDIAL hopper
* * * * * /usr/share/astguiclient/AST_VDhopper.pl -q
### adjust the GMT offset for the leads in the vicidial_list table
1 1,7 * * * /usr/share/astguiclient/ADMIN_adjust_GMTnow_on_leads.pl --debug --postal-code-gmt

[mflorell]

Your DB server will be fine without the server entry as long as you don't want to run VICIdial scripts on it. Typically we will run the hopper script on the DB server, so if you want to do that it will need a server entry.

[elyc1990]

Thanks Matt for the reply!

What about for webserver? Do I need to add my webserver to the list if I would like to run the 5 scripts below from webserver?

### VICIDIAL agent time log weekly summary report generation
2 0 * * 0 /usr/share/astguiclient/AST_agent_week.pl
### fix the vicidial_agent_log once every hour and the full day run at night
33 * * * * /usr/share/astguiclient/AST_cleanup_agent_log.pl
50 0 * * * /usr/share/astguiclient/AST_cleanup_agent_log.pl --last-24hours
### updater for VICIDIAL hopper
* * * * * /usr/share/astguiclient/AST_VDhopper.pl -q
### adjust the GMT offset for the leads in the vicidial_list table
1 1,7 * * * /usr/share/astguiclient/ADMIN_adjust_GMTnow_on_leads.pl --debug --postal-code-gmt

[mflorell]

Are you running the hopper script in the crontab on more than one server?

[elyc1990]

No we only run the 5 scripts including hopper at one dialer server. Now we plan to move them over to webserver because the load there is very low. Currently the webserver has /etc/astguiclient.conf with keepalive set to X and the normal vicidial php directories. Do I need to "add new server" for the webserver at vicidial admin for the scripts to work?

I always have the impression that as long as we have the relevant perl packages and the astguiclient.conf then the script will work from any server. Correct me if wrong. Then what is the purpose of "add new server" at vicidial admin?

[mflorell]

Several of those scripts will look for settings like the time zone of the server that are set in the server entry, which is why they need a servers table record for them to work.

[elyc1990]

So in short I need to add my webserver in the server record in order for the scripts to work right?

[mflorell]

Yes, but the server entry for it should have Asterisk=N and Agent Server=N.

[elyc1990]

Oops I forgot the Agent Server.

Thanks Matt!