To save the users and location information in a database, OpenSIPS will need to be configured with a database such as MySQL. Before you proceed, it is important to verify that you have MySQL installed and the opensips-mysql
module compiled and installed.
In Chapter 3, Installing OpenSIPS, we compiled OpenSIPS with MySQL support. Check the lib
directory for the db_mysql.so
module.
Some additional tasks have to be done before you can use OpenSIPS with MySQL.
The following are the step-by-step instructions to create a database using the opensipsdbctl
command and change the opensips.cfg
file to allow the authentication of the REGISTER and INVITE requests:
Verify the existence of the
db_mysql.so
module in the directory:For 32 bit:
ls /lib/opensips/modules/db_mysql.so
For 64 bit:
ls /lib64/opensips/modules/db_mysql.so
If the module does not exist, compile OpenSIPS with MySQL support. The path depends on the installation prefix. For 64-bit systems, check lib64 instead of lib...