Asterisk is an open source framework for building communications applications. Asterisk turns an ordinary computer into a communications server. Asterisk powers IP PBX systems, VoIP gateways, conference servers and more. It is used by small businesses, large businesses, call centers, carriers and governments worldwide. Asterisk is free and open source. Asterisk is sponsored by Digium 

OpenSIPS (Open SIP Server) is a mature Open Source implementation of a SIP server. OpenSIPS is more than a SIP proxy/router as it includes application-level functionalities. OpenSIPS, as a SIP server, is the core component of any SIP-based VoIP solution. With a very flexible and customizable routing engine, OpenSIPS 'unifies voice, video, IM and presence services in a highly efficient way, thanks to its scalable (modular) design.
What OpenSIPS has to offer, comes in a reliable and high-performance flavour - OpenSIPS is one of the fastest SIP servers, with a throughput that confirms it as a solution up to enterprise or carrier-grade class.  

Visto che ogni tanto capita qualcuno che mi chiede aiuto per l'integrazione di OpenSIPS con Mysql, posto qua alcune regole guida da seguire per far si che tutto vada a buon fine:

Ricordiamoci ovviamente di installare i pacchetti necessari per mysql:

apt-get install mysql-server
apt-get install mysql-client

Passiamo quindi alla compilazione:

make include_modules="db_mysql" modules
make install

E quindi lanciamo la creazione delle strutture necessarie a OpenSIPS:

root@debian-opensips: / # opensipsdbctl create

Se per caso ci compaiono i seguenti errori, è necessario copiare un file ( opensipsdbctl.mysql ).

L'errore:

root@debian-opensips: / # opensipsdbctl create
ERROR: could not load the script in /usr/local/lib/opensips/opensipsctl/opensipsdbctl.mysql for database engine MYSQL
ERROR: database engine not loaded - tried 'MYSQL'

La soluzione:

root@debian-opensips: / # cp /usr/lib/opensips/opensipsctl/opensipsdbctl.mysql /usr/local/lib/opensips/opensipsctl/

Ricordiamoci di modificare opensipsctlrc per fargli caricare il modulo di MySql


root@debian-opensips: / # vi /usr/local/etc/opensips/opensipsctlrc

e cambiamo la riga (decommentiamo):

## database type: MYSQL, PGSQL, ORACLE, DB_BERKELEY, or DBTEXT,
## by default none is loaded
# If you want to setup a database with opensipsdbctl, you must at least specify
# this parameter.
DBENGINE=MYSQL

## database host
DBHOST=localhost

Copiamo Quindi i file .sql necessari:


root@debian-opensips: / # cd /usr/local/lib/opensips/opensipsctl/
root@debian-opensips: opensipsctl # mkdir mysql
root@debian-opensips: opensipsctl #cd mysql
root@debian-opensips: mysql # cp /root/opensips-1.6.3-notls/scripts/mysql/*.sql .

E rilanciamo il comando:


root@debian-opensips: opensipsctl # opensipsdbctl create
MySQL password for root:
INFO: test server charset
INFO: creating database opensips ...
INFO: Core OpenSIPS tables succesfully created.
Install presence related tables? (y/n): y
INFO: creating presence tables into opensips ...
INFO: Presence tables succesfully created.
Install tables for imc cpl siptrace domainpolicy carrierroute userblacklist? (y/n): y
INFO: creating extra tables into opensips ...
INFO: Extra tables succesfully created. 

Đúng như thread, em muốn hỏi các bác về sự kết hợp giữa Asterick & OpenSIPS:

- Sự kết hợp giữa OpenSIPS & Asterick phần lớn dành cho các nhà mạng việ thônng lớn?
- Ưu, nhược điểm & đặc điểm cần chú ý khi cấu hình, sử dụng?
- Với một hệ thống đầu số giá trị giá tăng: dùng 1 OpenSIPS Server (của nhà mạng), bên mình 1 Asterick. Có cần thêm 4 con OpenSIPS làm trung gian (năm trong hệ thống mạng của minhd). Hay đây là do sếp bôi ra