Separate Asterisk and Mysql+Web Server

[dev_4901]

Hi,
The current scenario that I have here is that one x206 is serving all the needs i.e Asterisk+MySQL+Web. VICIDIAL version 1.1.12-3. I am pretty comfortable with this version and its serving me great, so I've no plans to upgrade to version 2.0.2.

Now I'm planning to separate the two i.e the x206 will have only the Asterisk on it and a PIV machine with MySQL and Web services.

I would really appreciate if you could please guide me on :-

a) what all scripts and other installs to be done on the new MySQL+Web server.
b) what all scripts would be running on the Asterisk server .
c) what scripts need to be removed from the Asterisk server.
d) do I need to setup MySQL on the asterisk server as well ?


This is the list of CRON entries(ORIGINAL - for one server)

### recording mixing for Asterisk run every 5 minutes
1,6,11,16,21,26,31,36,41,46,51,56 * * * 1,2,3,4,5,6 /home/cron/AST_CRON_mix_recordings_BASIC.pl

### keepalive script for Asterisk updaters
* * * * * /home/cron/ADMIN_keepalive_AST_update.pl

### keepalive script for Asterisk manager queue system
* * * * * /home/cron/ADMIN_keepalive_AST_send_listen.pl

### keepalive script for Asterisk VICIDIAL autodial system
* * * * * /home/cron/ADMIN_keepalive_AST_VDautodial.pl

### keepalive script for VICIDIAL remote agents
* * * * * /home/cron/ADMIN_keepalive_AST_VDremote_agents.pl

### kill Hangup script for Asterisk updaters
* * * * * /home/cron/AST_manager_kill_hung_congested.pl

### updater for voicemail
* * * * * /home/cron/AST_vm_update.pl

### updater for conference validator
* * * * * /home/cron/AST_conf_update.pl

### flush queue DB table every hour for entries older than 1 hour
11 * * * * /home/cron/AST_flush_DBqueue.pl -q

### fix the vicidial_agent_log once every hour
33 * * * * /home/cron/AST_cleanup_agent_log.pl

### updater for VICIDIAL hopper
* * * * * /home/cron/AST_VDhopper.pl -q

### adjust the GMT offset for the leads in the vicidial_list table
1 1 * * * /home/cron/ADMIN_adjust_GMTnow_on_leads.pl --debug

### reset several temporary-info tables in the database
2 1 * * * /home/cron/AST_reset_mysql_vars.pl

### optimize the database tables within the asterisk database
3 1 * * * /home/cron/AST_DB_optimize.pl

## adjust time on the server with ntp
30 * * * * /usr/local/bin/ntpdate -u 18.145.0.30 2>/dev/null 1>&2

### VICIDIAL agent time log weekly summary report generation
2 0 * * 0 /home/cron/AST_agent_week.pl


Please advice,
Dev Singhal.

[arunvoip]

hi ,

before you post please read the fourm.
------------------------------------------
Hi all, here you go:

*** Please note that this is just telling what need to be done on specific server. Refer scratch_install for installation flow/step.
*** Shall there anything wrong with this, please let me know

Machine 1: Asterisk Server
- install all CPAN modules
- install asterisk-perl-module
- install sox, screen, ntpd, zaptel, libpri & asterisk
- adduser cron
- configure asterisk (SUBPHASE 5 to SUBPHASE 5.3)
- install astguiclient_1.1.11 EXACTLY as scratch_install SUBPHASE 6.0
- configure AST_SERVER_conf.pl [/home/cron](change $server_ip and $DB_server to your Asterisk and MySQL server ip respectively)
- configure asterisk (SUBPHASE 6.2)
- Follow SUBPHASE 6.4 instruction of scratch_install (you only need entries required by this server)

Machine 2: Apache + astguiclient & vicidial
- install all CPAN modules
- install asterisk-perl-module
- install screen, ntpd, apache, php
- adduser cron
- install astguiclient_1.1.11 EXACTLY as scratch_install SUBPHASE 6.0
- configure dbconnect.php [located at /usr/local/apache2/htdocs/(agc, astguiclient, vicidial)] and AST_SERVER_conf.pl [/home/cron] (change $server_ip and $DB_server to your Asterisk and MySQL server ip respectively)
- Follow instructions on SUBPHASE 6.1 number 3.
- Follow SUBPHASE 6.4 instruction of scratch_install (you only need entries required by this server)
- Follow SUBPHASE 6.5 instructions of scratch_install

Machine 3: MySQL Server
- install all CPAN modules
- install ntpd, MySQL
- Follow SUBPHASE 6.1 instructions of scratch_install
~~~ Set your servers.telnet_host to your asterisk server ip
- Follow SUBPHASE 6.3 instructions of scratch_install
- Follow SUBPHASE 6.4 instruction of scratch_install (you only need entries required by this server)
- You'll need to follow SUBPHASE 6.6 instructions if you would like to add test leads.
_________________

this is long back posted by Eric.
-------------------------------------------------------

thanks
arun

[arunvoip]

hi ,

before you post please read the fourm.
------------------------------------------
Hi all, here you go:

*** Please note that this is just telling what need to be done on specific server. Refer scratch_install for installation flow/step.
*** Shall there anything wrong with this, please let me know

Machine 1: Asterisk Server
- install all CPAN modules
- install asterisk-perl-module
- install sox, screen, ntpd, zaptel, libpri & asterisk
- adduser cron
- configure asterisk (SUBPHASE 5 to SUBPHASE 5.3)
- install astguiclient_1.1.11 EXACTLY as scratch_install SUBPHASE 6.0
- configure AST_SERVER_conf.pl [/home/cron](change $server_ip and $DB_server to your Asterisk and MySQL server ip respectively)
- configure asterisk (SUBPHASE 6.2)
- Follow SUBPHASE 6.4 instruction of scratch_install (you only need entries required by this server)

Machine 2: Apache + astguiclient & vicidial
- install all CPAN modules
- install asterisk-perl-module
- install screen, ntpd, apache, php
- adduser cron
- install astguiclient_1.1.11 EXACTLY as scratch_install SUBPHASE 6.0
- configure dbconnect.php [located at /usr/local/apache2/htdocs/(agc, astguiclient, vicidial)] and AST_SERVER_conf.pl [/home/cron] (change $server_ip and $DB_server to your Asterisk and MySQL server ip respectively)
- Follow instructions on SUBPHASE 6.1 number 3.
- Follow SUBPHASE 6.4 instruction of scratch_install (you only need entries required by this server)
- Follow SUBPHASE 6.5 instructions of scratch_install

Machine 3: MySQL Server
- install all CPAN modules
- install ntpd, MySQL
- Follow SUBPHASE 6.1 instructions of scratch_install
~~~ Set your servers.telnet_host to your asterisk server ip
- Follow SUBPHASE 6.3 instructions of scratch_install
- Follow SUBPHASE 6.4 instruction of scratch_install (you only need entries required by this server)
- You'll need to follow SUBPHASE 6.6 instructions if you would like to add test leads.
_________________

this is long back posted by Eric.
-------------------------------------------------------

why don't you try new version this has lots of new features.

thanks
arun

[dev_4901]

Thanks Arun for the reply.

I had chked for earlier posts, but it must have been very old. Still many thanx for it.

But I'm confused about the CRON tab entries in SubPhase 6.5. Do both my servers have ALL the entries of SubPhase 6.5??

Please advice.
Dev Singhal

[arunvoip]

no only one server ( asterisk).

[dev_4901]

Thanx Arun for the reply.

When I type screen -r, I dont see any screens except Asterisk. The rest get started and killed automatically, on the Asterisk server. So I guess the connection with MySql is not working.

The servers table would be having only one entry of the Asterisk server OR do I need to specify the MySQL server there too?

The asterisk server's ip would be in the telnet_host of the asterisk server's entry in the servers table?(in case of only one entry)

Plz advice.
Dev

[mflorell]

you do not need to specify the mysql server in the servers table, only the Asterisk server.