[Asterisk-Users] Re: asterisk database support (SIP_FRIENDS)

[Stefan Tichy]

On Sat, Apr 17, 2004 at 05:36:06PM +0200, Brancaleoni Matteo wrote:
> simply, you can define sip friends from a database.
> just create the table, enable SIP_FRIENDS into channels

USE_SIP_MYSQL_FRIENDS=1


> Makefile and read chan_sip.c how to set
> db access (db access data must be into sip.conf)

dbname=xxxxxxxx         ; Name of database
dbhost=localhost        ; Hostname of server 
dbuser=xxxxxxxx         ; MySQL user name
dbpass=xxxxxxxx         ; Password for dbuser

./contrib/scripts/sip-friends.sql can be used to create a sipfriends
table in the database. Select and update priviledges for the dbuser
on the sipfriends table are required.

Insert (name,secret,context) records into sipfriends. Default values
will be used for the other fields until your sip clients register.
The secret is plaintext.


But using MYSQL_FRIENDS is not just a replacement for a list of
configuration data in sip.conf or some file included from there.

CLI command "sip show peers" will not show anything and it is not
possible to specify additional options. "dtmfmode=rfc2833" default
should work, account information may not be used, but there is no
"mailbox" notification to the phone. In the latter case it is not an
option which could be easily added by some minor modification in
chan_sip.c. 

If you need additonal options, look at retrieve_sip_conf_from_mysql.pl
It can be used to generate sip configuration from MySQL data.


-- 
Stefan Tichy   <asterisk at pi4tel.de>