1 ASTERISK/VICIDIAL AND 1 DATABASE/WEB SERVER

[eijal]

HI.
I WAS READING IN SOME POST HOW TO INSTALL ASTERISK/VICIDIAL IN ONE SERVER AND DATABASE/WEB SERVER IN ANOTHER. MAY BE TOGUETHER CAN MAKE A GUIDE FOR THIS KIND OF CONFIGURATION. THIS IS WHAT I UNDERSTOOND FROM THE SCRATCH_INSTALL AND LOAD BALANCING DOCUMENTS.

A. ASTERISK/VICIDIAL
1. SUBPHASE 3.0: make-3.81.tar.gz
2. SUBPHASE 3.1: MYSQL CLIENT
3. SUBPHASE 3.2: PERL MODULES - CPAN
4. SUBPHASE 3.2: ASTERISK-PERL MODULES
5. SUBPHASE 3.3: SOX, LAME, MPG123, SCREEN, TTYLOAD, NTPD, IFTOP, OPENSSH, SVN
6. PHASE 4: ASTERISK, ZAPTEL, LIBPRI, ZTTOL
7. SUBPHASE 6.0: ASTGUICLIENT AND VICIDIAL (How do I install it? perl install.pl OR perl install.pl --without-web?)
8. SUBPHASE 6.1: CREATING DATABASE - /usr/share/astguiclient/ADMIN_area_code_populate.pl (This command here OR in the DATABASE/WEB SERVER)
9. SUBPHASE 6.4: /etc/rc.d/rc.local FILE (THE LINE: touch /var/lock/subsys/local HERE OR IN THE DATABASE/WEB SERVER OR IN BOTH)
10. SUBPHASE 6.5: setting up astguiclient scripts for continuous running. I AM NOT REALLY SURE WHAT I NEED HERE, OR EVERYTHING IS OK.

Code: Select all

- cd /usr/share/astguiclient
   - crontab -e
      - add the following entries(here's what we used):
         (Note if you have not edited the AST_CRON_mix_recordings.pl script
to FTP to a different server, then you should use the
AST_CRON_mix_recordings_BASIC.pl file in it's place)

### 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 /usr/share/astguiclient/AST_CRON_mix_recordings_BASIC.pl

### keepalive script for astguiclient processes
* * * * * /usr/share/astguiclient/ADMIN_keepalive_ALL.pl

### kill Hangup script for Asterisk updaters
* * * * * /usr/share/astguiclient/AST_manager_kill_hung_congested.pl

### updater for voicemail
* * * * * /usr/share/astguiclient/AST_vm_update.pl

### updater for conference validator
* * * * * /usr/share/astguiclient/AST_conf_update.pl

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

### fix the vicidial_agent_log once every hour
33 * * * * /usr/share/astguiclient/AST_cleanup_agent_log.pl

### 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 * * * /usr/share/astguiclient/ADMIN_adjust_GMTnow_on_leads.pl --debug --postal-code-gmt

### reset several temporary-info tables in the database
2 1 * * * /usr/share/astguiclient/AST_reset_mysql_vars.pl

### optimize the database tables within the asterisk database
3 1 * * * /usr/share/astguiclient/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 /usr/share/astguiclient/AST_agent_week.pl


B. DATABASE/WEB SERVER
1. SUBPHASE 3.1: MYSQL CLIENT AND SERVER
2. SUBPHASE 3.2: PERL MODULES - CPAN (is it necesary????)
3. SUBPHASE 3.2: ASTERISK-PERL MODULES (is it necesary????)
4. SUBPHASE 3.3: SCREEN (is it necesary????), TTYLOAD, NTPD, IFTOP, PLOTICUS, OPENSSH, OPENSSL, APACHE, PHP, LOAD EACCELARTOR, SVN, MTOP
5. SUBPHASE 6.0: ASTGUICLIENT AND VICIDIAL (Is it necessary? if it is how do I install it? per install.pl OR perl install.pl --web-only)
6. SUBPHASE 6.1: CREATING DATABASE - /usr/share/astguiclient/ADMIN_area_code_populate.pl (This command here OR in the ASTERISK/VICIDIAL SERVER)
7. SUBPHASE 6.4: /etc/rc.d/rc.local FILE (THE LINE: touch /var/lock/subsys/local HERE OR IN THE ASTERISK/VICIDIAL SERVER OR IN BOTH)
8. SUBPHASE 6.5: setting up astguiclient scripts for continuous running. I THINK I DON'T NEED EVERYTHING ON THIS SERVER, BUT WHAT?

Code: Select all

- cd /usr/share/astguiclient
   - crontab -e
      - add the following entries(here's what we used):
         (Note if you have not edited the AST_CRON_mix_recordings.pl script
to FTP to a different server, then you should use the
AST_CRON_mix_recordings_BASIC.pl file in it's place)

### 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 /usr/share/astguiclient/AST_CRON_mix_recordings_BASIC.pl

### keepalive script for astguiclient processes
* * * * * /usr/share/astguiclient/ADMIN_keepalive_ALL.pl

### kill Hangup script for Asterisk updaters
* * * * * /usr/share/astguiclient/AST_manager_kill_hung_congested.pl

### updater for voicemail
* * * * * /usr/share/astguiclient/AST_vm_update.pl

### updater for conference validator
* * * * * /usr/share/astguiclient/AST_conf_update.pl

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

### fix the vicidial_agent_log once every hour
33 * * * * /usr/share/astguiclient/AST_cleanup_agent_log.pl

### 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 * * * /usr/share/astguiclient/ADMIN_adjust_GMTnow_on_leads.pl --debug --postal-code-gmt

### reset several temporary-info tables in the database
2 1 * * * /usr/share/astguiclient/AST_reset_mysql_vars.pl

### optimize the database tables within the asterisk database
3 1 * * * /usr/share/astguiclient/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 /usr/share/astguiclient/AST_agent_week.pl


THANKS

[ramindia]

Hi

just messaged to know

is this document any one tested ?

ram

[mflorell]

Install everything on the Asterisk/VICIDIAL server including the crontab entries.

Install only all perl modules MySQL, Apache an PHP, then copy web pages to the web server and configure the dbconnect.php script. screen is not needed on this server.

[eijal]

THEN, THIS IS THE INSTALLATION:

A. ASTERISK/VICIDIAL
1. SUBPHASE 3.0: make-3.81.tar.gz
2. SUBPHASE 3.1: ONLY MYSQL CLIENT
3. SUBPHASE 3.2: PERL MODULES - CPAN
4. SUBPHASE 3.2: ASTERISK-PERL MODULES
5. SUBPHASE 3.3: SOX, LAME, MPG123, SCREEN, TTYLOAD, NTPD, IFTOP, OPENSSH, SVN
6. PHASE 4: ASTERISK, ZAPTEL, LIBPRI, ZTTOL
7. SUBPHASE 6.0: ASTGUICLIENT AND VICIDIAL (TYPE: perl install.pl)
8. SUBPHASE 6.1: creating database - (DON’T CREATE THE DATABASE JUST TYPE: /usr/share/astguiclient/ADMIN_area_code_populate.pl)
9. SUBPHASE 6.5: ALL CONTRAB ENTRIES.

B. DATABASE/WEB SERVER
1. SUBPHASE 3.1: MYSQL CLIENT AND SERVER
2. SUBPHASE 3.2: PERL MODULES - CPAN (ALL PERL MODULES)
3. SUBPHASE 3.2: ASTERISK-PERL MODULES (is it necesary? I DON’T THINK SO)
4. SUBPHASE 3.3: TTYLOAD, NTPD, IFTOP, PLOTICUS, OPENSSH, OPENSSL, APACHE, PHP, LOAD EACCELARTOR, SVN, MTOP
5. SUBPHASE 6.1: CREATING DATABASE (JUST CREATE THE DATABASE, BUT DON’T TYPE: /usr/share/astguiclient/ADMIN_area_code_populate.pl)
7. SUBPHASE 6.5: WE DON’T NEED ANY CONTRAB ENTRIES ON THIS SERVER

AM I RIGHT? PLEASE, CORRECT ME IF I AM WRONG. I AM NOT SURE WITH THE RED WORDS

THANKS

[mflorell]

Everything there is correct, you do not need to install the asterisk-perl module on the DB/Web server.

Also, I would install the DB/Web server first.

[hotdog0627]

quick question:

Do I need to install ASTGUICLIENT AND VICIDIAL (TYPE: perl install.pl) on the DB/WEB server also?

[Op3r]

Yep.

You need to run the install script, crontab and the perl modules.

[eijal]

quick question:

Do I need to install ASTGUICLIENT AND VICIDIAL (TYPE: perl install.pl) on the DB/WEB server also?

Nop, you don't need to install that, in the DB/WEB server, just in the ASTERISK/VICIDIAL server.

[Op3r]

I tried not doing the install.pl on db and apache server it never worked.

[mflorell]

If you don't do the install.pl you do need to customize the dbconnect.php file in each of the www folders before you put them on your web server.