MySQL_AST_CREATE_tables.sql on different server

[gerski]

Guys,

i have created 2 server

1 = mysql/apache
2 = asterisk/vicidial

in subphase 6.1
how can i access my :

\. /usr/share/astguiclient/MySQL_AST_CREATE_tables.sql
in another server with ip 192.168.0.21

how can i type to mysql?

[gerski]

and also in mysql/apache

do i need to install vicidial?

which is which do i need to install...?

1- mysql/apache= mysql, apache,... ( the problem is how can i link my 1st server mysql to 2nd server astguiclient)

2- aterisk/vicidial = asterisk, vicidial... (i configured perl install.pl to use my 1st server and it has no error)

[gerski]

do you suggest this?

Code: Select all

- For medium call center (upto 75 seats):
asterisk server: single-core opteron (since all transcoding and calls still go through one core in asterisk, it doesn't make sense to buy a multi-core or hyperthreaded system that will only slow you down)

mysql/astguiclient/apache server: hyperthreaded xeon (since astguiclient relies on a number of scripts being executed in parallel, it's good to have hyperthreaded or dual core systems with astguiclient). Remember to nfs-mount the sound recordings directories!

is this better than my current setup?[/code]

[mflorell]

all you have to do is install with the (perl install.pl --web-only) on your apache/db server and install (perl install.pl --without-web) on your Asterisk server and make sure you set the database server to the IP address of your DB server in both machines.

Thos recommended setups were not mine. I usually use Intel processors in servers for Asterisk/VICIDIAL and have separate web and DB servers in larger installations.

[gerski]

i also use intel server, I'm getting this error on asterisk/vicidial server:

Code: Select all

DBI connect('asterisk:192.168.0.20:3306','cron',..) failed: Can't connect to MySQL server on '192.168.0.20' (113) at /usr/share/astguiclient/start_asterisk_boot.pl line 39
Can't connect to databbase: Can't connect to MySQL server on '192.168.0.20' (113) at /usr/share/astguiclient/start_asterisk_boot.pl at line 39

here is what i do:

root@Asterisk:/usr/src/astguiclient# perl install.pl --without-web
Previous astGUIclient configuration file found at: /etc/astguiclient.conf

Would you like to use manual configuration and installation(y/n): [y] y

STARTING ASTGUICLIENT MANUAL CONFIGURATION PHASE...

astguiclient home path or press enter for default: [/usr/share/astguiclient]

astguiclient logs path or press enter for default: [/var/log/astguiclient]

asterisk agi-bin path or press enter for default: [/var/lib/asterisk/agi-bin]

asterisk sounds path or press enter for default: [/var/lib/asterisk/sounds]

asterisk monitor path or press enter for default: [/var/spool/asterisk/monitor]

server IP address or press enter for default: [192.168.0.21]

DB server address or press enter for default: [192.168.0.20]

192.168.0.20 - MySQL/Apache
192.168.0.21 - Asterisk/Vicidial

question again, so if i put web only on mysql/apache the web address of the vicidial is 192.168.0.20 right? just to make sure.. [/img]

[gerski]

it works now.. i redo everything and restarted the two server and it works..

question, how can i know if the vicidial is running on my 1st server and not on the second server?

[gerski]

also the problem is what command do i put in crontab for sending the recording to the 2nd server after i installed pure ftp

[mflorell]

What do you have now for your mix recordings crontab script?

[gerski]

based on scratch install:

### 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

[mflorell]

If you want to leave the files as WAV you could change that entry to
AST_CRON_mix_recordings.pl

If you want to change the files to GSM or MP3 for smaller recordings you could use
AST_CRON_mix_recordings_GSM.pl
or
AST_CRON_mix_recordings_MP3.pl

in all 3 of these scripts all you need to do is change the ftp variables toward the top to your FTP server and user/pass and you should be all set.

[gerski]

matt,

question on this SUBPHASE 6.1: creating the MySQL "asterisk" database

regarding this = \. /usr/share/astguiclient/MySQL_AST_CREATE_tables.sql

i type the perl - web only on my apache/mysql how can i access MySQL_AST_CREATE_tables.sql on my other server asterisk / vicidial?

[enjay]

gerski,
just dump that file into your database..

mysql -u username -p password asterisk < MySQL_CREATE_yaddayadda.sql

-enjay

(That will populate the database however if you already have data in there think twice about this).

[gerski]

on mysql username password what will i define? is it mysql username and password?

actually i install my astguiclient install perl - web only but i dont have /usr/share/astguiclient..... i wanted to get my /usr/share/astguiclient on my asterisk/vicidial server...

so you mean if i do this it will just populate my database so once MYSQL_CREATE_yadadada.sql connects to my mysql/apache server it will work..

[enjay]

just scp that file to your database server and login and dump the contents into it using

follow the scratch install again the mysql section you need to install sql then create the database and then import the data (tables etc).

-Art

[gerski]

it works now.. i just copy the asterisk/vicidial MySQL_AST_CREATE_tables.sql to my apache/mysql server. and it works

and also i type /usr/share/astguiclient/ADMIN_area_code_populate.pl to my asterisk/vicidial and it works too.. thanks matt & enjay for helping...