Asterisk SIP MySQL Configuration

Recently studied asterisk configuration, before the SIP account is configured in the sip.conf file, manual writing dead, the current demand, is the dynamic new SIP account, saved in the database.

After adding data to the database, use the command SIP show users to not load the SIP account to the database.

1. Download X-lite soft phone client, login SIP account, can login successfully.

2. Modify the res_config_mysql.conf file, configure the database link (host,dbname,username,password)

3. Modify the extconfig.conf file, configure
Sippeers = Mysql,general,bit_sip_buddies
Sipusers = Mysql,general,bit_sip_buddies

"General" This is the head tag in res_config_mysql.conf,

"Bit_sip_buddies" This is the table name of the SIP user

4. Modify the sip.conf file

Rtupdate=yes
Rtcachefriends=yes
Rtsavesysname=yes
These three configurations are the focus, be sure to match at the same time, you can solve the SIP show users command does not display the database SIP account problem.

5. Check before operation

(1) Realtime MySQL status enter this command to monitor Realtime plugin service there is no

(2) before the SIP Show Users command is executed, the SIP account must be logged in with the X-lite client before it can be loaded into memory to display the SIP user information.

Asterisk SIP MySQL Configuration