Hello, Is it possible to use a database for provisionning sip clients? CVS provides sip-friends.sql in order to create tables (not database) what may i do with that tables? Regards Harry
Hello, Is it possible to use a database for provisionning sip clients? CVS provides sip-friends.sql in order to create tables (not database) what may i do with that tables? Regards Harry
I hear some echo there .... :) simply, you can define sip friends from a database. just create the table, enable SIP_FRIENDS into channels Makefile and read chan_sip.c how to set db access (db access data must be into sip.conf) but, firstofall, you must be familiar with sip.conf and friends/user/peer definition in order to understand how it works... matteo Il sab, 2004-04-17 alle 17:21, gaillac harry ha scritto:> Hello, > > Is it possible to use a database for provisionning sip clients? > > CVS provides sip-friends.sql in order to create tables (not database) > what may i do with that tables? > > Regards > > Harry > > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users-- Brancaleoni Matteo <mbrancaleoni@espia.it> Espia - Emmegi Srl
Sorry for echo I just wait for a reply :) I looked at Voip-info but does a GUI is provided to insert datas in tables ??? Le sam 17/04/2004 =C3=A0 17:36, Brancaleoni Matteo a =C3=A9crit :> I hear some echo there .... :) >=20 > simply, you can define sip friends from a database. > just create the table, enable SIP_FRIENDS into channels > Makefile and read chan_sip.c how to set > db access (db access data must be into sip.conf) >=20 > but, firstofall, you must be familiar with sip.conf > and friends/user/peer definition in order to understand > how it works... >=20 > matteo >=20 > Il sab, 2004-04-17 alle 17:21, gaillac harry ha scritto: > > Hello, > >=20 > > Is it possible to use a database for provisionning sip clients? > >=20 > > CVS provides sip-friends.sql in order to create tables (not database) > > what may i do with that tables? > >=20 > > Regards > >=20 > > Harry > >=20 > > _______________________________________________ > > Asterisk-Users mailing list > > Asterisk-Users@lists.digium.com > > http://lists.digium.com/mailman/listinfo/asterisk-users > > To UNSUBSCRIBE or update options visit: > > http://lists.digium.com/mailman/listinfo/asterisk-users
Stefan Tichy
2004-Apr-19 08:27 UTC
[Asterisk-Users] Re: asterisk database support (SIP_FRIENDS)
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 channelsUSE_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@pi4tel.de>