Versions Compared

Old Version 5

changes.mady.by.user Valerio Ciotta

Saved on

compared with

New Version 6

changes.mady.by.user Valerio Ciotta

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Excerpt

Use external realtime DB on different server




Table of Contents

 


Scaling Architecture

 


Configure the Asterisk Realtime Architecture

 
Note
titleImportant
After the configuration changes, please reboot the machine.

Info
titleScalable architecture

For large scalable deployments on one hand, and to be able to interact with the XCALLY SHUTTLE DB from external application on the other hand, without affecting the operation, we suggest at least 3 Linux CentOS6.X servers, like in the following example.

Please contact our XCALLY Team for help and more details about this scalable deployment solution.



GUI

 
You have to edit:

 


- the file called database.php, under the directory /var/www/html/application/config, as follows:

 
Code Block
$db['default']['hostname'] = 'DESTINATION_HOSTNAME_MYSQL';
$db['default']['username'] = 'DESTINATION_USERNAME_MYSQL';
$db['default']['password'] = 'DESTINATION_PASSWORD_MYSQL';
$db['default']['database'] = 'DESTINATION_DATABASE_MYSQL';

 


- the file called mysql.json, under the directory /var/www/html, as follows:

 


Code Block
{
"host": "DESTINATION_HOSTNAME_MYSQL",
"port": "3306",
"user": "DESTINATION_USERNAME_MYSQL",
"password": "DESTINATION_PASSWORD_MYSQL",
"database": "DESTINATION_DATABASE_MYSQL"
}
 


- In Settings / General set the parameter "Direct database extract" to NO (in order to extract the CSV files in the correct location):

Image Added

ASTERISK CDR

 
You have to edit the file called cdr_mysql.conf, under the directory /etc/asterisk/, as follows:
 
Code Block
hostname=DESTINATION_HOSTNAME_MYSQL
 
dbname=DESTINATION_DATABASE_MYSQL
 
password=DESTINATION_PASSWORD_MYSQL 
 
user=DESTINATION_USERNAME_MYSQL
 

 
ASTERISK REALTIME
 
You have to edit:
 

- the file called res_config_mysql.conf under the directory /etc/asterisk/
 
 Code Block
dbhost = DESTINATION_HOSTNAME_MYSQL

dbname = DESTINATION_DATABASE_MYSQL
 
dbuser = DESTINATION_USERNAME_MYSQL
 
dbpass = DESTINATION_PASSWORD_MYSQL
 

- the file called odbc.ini under the directory /etc/odbc.ini
 Code Block
Server = DESTINATION_HOSTNAME_MYSQL 
User = DESTINATION_USERNAME_MYSQL    
Pass = DESTINATION_PASSWORD_MYSQL   
Database = DESTINATION_DATABASE_MYSQL

 
 
PHONEBAR

You have to edit:

- the file called res_top.conf under the directory /etc/asterisk
 

 
 Code Block
hostname = DESTINATION_HOSTNAME_MYSQL
 
schema = DESTINATION_DATABASE_MYSQL
 
user = DESTINATION_USERNAME_MYSQL 
 
secret =DESTINATION_PASSWORD_MYSQL


- the file called res_xcalld.conf under the directory /etc/asterisk 
 

 
 Code Block
[mysql]

hostname = DESTINATION_HOSTNAME_MYSQL
 
schema = DESTINATION_DATABASE_MYSQL
 
user = DESTINATION_USERNAME_MYSQL 
 
secret =DESTINATION_PASSWORD_MYSQL
 

  
 
AGISQUARE

You have to edit the file called agisquare.conf under the directory /var/www/html/agisquare/etc
 

 
 Code Block
[database]

host = DESTINATION_HOSTNAME_MYSQL
 
database = DESTINATION_DATABASE_MYSQL
 
user = DESTINATION_USERNAME_MYSQL 
 
password =DESTINATION_PASSWORD_MYSQL
 
 


Move the database


 
 
 Note
titleImportant
The firewall, in the destination server, must permit the connection on the MySQL port (default 3306)
 

  • Create, on the destination server (DESTINATION_HOSTNAME_MYSQL), the xcally database and the user DESTINATION_USERNAME_MYSQL/DESTINATION_PASSWORD_MYSQL
  • Connect to MySQL and launch the following queries:
 Code Block
languagesql
CREATE DATABASE IF NOT EXISTS DESTINATION_DATABASE_MYSQL;
GRANT ALL PRIVILEGES ON DESTINATION_DATABASE_MYSQL.* TO
'DESTINATION_USERNAME_MYSQL'@'localhost' IDENTIFIED BY 'DESTINATION_PASSWORD_MYSQL';
GRANT ALL PRIVILEGES ON DESTINATION_DATABASE_MYSQL.* TO 'DESTINATION_USERNAME_MYSQL'@'%' IDENTIFIED BY 'DESTINATION_PASSWORD_MYSQL';
GRANT SUPER ON *.* TO 'DESTINATION_USERNAME_MYSQL'@'localhost';
GRANT FILE ON *.* TO 'DESTINATION_USERNAME_MYSQL'@'localhost' identified by 'DESTINATION_PASSWORD_MYSQL'; GRANT FILE ON *.* TO 'DESTINATION_USERNAME_MYSQL'@'%' identified by 'DESTINATION_PASSWORD_MYSQL';
FLUSH PRIVILEGES;
  • Go, on the original server, under /usr/src
cd /usr/src
  • Launch the following commands:
 

 Code Block
mysqldump -u root -ppwd --routines xcally > xcally-dump.sql
mysql -u DESTINATION_USERNAME_MYSQL -pDESTINATION_PASSWORD_MYSQL -h DESTINATION_HOSTNAME_MYSQL DESTINATION_DATABASE_MYSQL < xcally-dump.sql

 
 
In case your database username is different from the default one 'xcall', insert these commands instead of the last ones: 
 

 Code Block
mysqldump -u root -ppwd --routines xcally | sed -e 's/DEFINER=`xcall`@`%`/DEFINER=`DESTINATION_USERNAME_MYSQL`@`%`/' > xcally-dump.sql> xcally-dump.sql
mysql -u DESTINATION_USERNAME_MYSQL -pDESTINATION_PASSWORD_MYSQL -h DESTINATION_HOSTNAME_MYSQL DESTINATION_DATABASE_MYSQL < xcally-dump.sql
 
 
 

 
 
 



 Page Properties
hiddentrue
Related issues