Use this http://svn.asteriskdocs.org/res_data/
It will get you sipfriends, IAX, etc. all live from MySQL/ODBC/etc. ---------------------------------------- Michael Shuler, C.E.O. BitWise Communications, Inc. (CLEC) And BitWise Systems, Inc. (ISP) 682 High Point Lane East Peoria, IL 61611 Office: (217) 585-0357 Cell: (309) 657-6365 Fax: (309) 213-3500 E-Mail: [EMAIL PROTECTED] Customer Service: (877) 976-0711 > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Bastian Schern > Sent: Thursday, November 18, 2004 8:15 AM > To: Asterisk Users Mailing List - Non-Commercial Discussion > Subject: Re: [Asterisk-Users] IAX2 peers via MySQL DB with > Asterisk 1.0.2 > > > Does nobody else has got this Problem? > Or does nobody know how it should be fixed? ;-) > > Bastian Schern schrieb: > > Hi all, > > > > I try to get the IAX2 peers from a MySQL DB. But this will > not work. I'm > > working with Asterisk 1.0.2. > > First I had enabled MYSQL_FRIENDS in the channels Makefile, > then I had > > created the user "asterisk", the database "asterisk" and the table > > "iaxfriends" inside my MySQL server (modelled on > > http://www.voip-info.org/wiki-Asterisk+sip+mysql+peers). > > > > I add this to my iax.conf: > > --- snip --- > > dbname=asterisk ; Name of database in your MySQL server > > dbhost=localhost ; Hostname of server > > dbuser=asterisk ; Username in MySQL > > dbpass=123456 ; Password for user in MySQL > > --- snap --- > > > > > > A added the User as following: > > > > mysql> INSERT INTO `iaxfriends` ( `name` , `secret` , `context` , > > `ipaddr` , `port` , `regseconds` ) VALUES ( > > 'bastian', '123456', 'default', '', '0', '0' > > ); > > > > > > After that I start my Asterisk without problems, but the > peers defined > > in the "iaxfriends" table are not working': > > > > SP2106*CLI> iax2 show peers > > Name/Username Host Mask Port > Status > > > > > > If a IAX-Client tries to connect it will produce this message: > > --- snip --- > > -- Unregistered 'bastian' (AUTHENTICATED) > > --- snap --- > > > > > > If I try to dial from the client I will get this on the > Asterisk console: > > --- snip --- > > Nov 16 20:30:00 NOTICE[1092774832]: chan_iax2.c:5402 socket_read: > > Rejected connect attempt from 212.202.169.118 > > --- snap --- > > > > > > But inside the DB-Table it looks like the client is registered: > > mysql> SELECT * FROM iaxfriends; > > +---------+--------+---------+-----------------+------+------------+ > > | name | secret | context | ipaddr | port | regseconds | > > +---------+--------+---------+-----------------+------+------------+ > > | bastian | r2dzwo | default | 212.202.169.118 | 4569 | 1100655488 | > > +---------+--------+---------+-----------------+------+------------+ > > 1 row in set (0.00 sec) > > > > > > What is wrong? > > > > Regards > > Bastian > > _______________________________________________ > > Asterisk-Users mailing list > > [EMAIL PROTECTED] > > http://lists.digium.com/mailman/listinfo/asterisk-users > > To UNSUBSCRIBE or update options visit: > > http://lists.digium.com/mailman/listinfo/asterisk-users > > _______________________________________________ > Asterisk-Users mailing list > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
