I need to develop an web interface to include clients automatically in Asterisk. So, to make this possible I need that all my peers and exten being at a database (Mysql). Where do I find doc?s regarded for it? Thank you very much, J Moura
Joao Carlos Moura wrote:>I need to develop an web interface to include clients automatically in >Asterisk. So, to make this possible I need >that all my peers and exten being at a database (Mysql). >Where do I find doc?s regarded for it? > >Thank you very much, >J Moura > > > >I think MySQL friends is probably what you are after.. take a look at www.voip-info.org Later..
http://bugs.digium.com/bug_view_page.php?bug_id=0001086 is what I use to dynamically put in SIP entries. It works really well. The extensions don't seem to be available in MySQL "officially" but I did find http://www.voip-info.org/tiki-index.php?page=Asterisk%20cmd%20DynExtenDB which I have not tried yet. It seems to be a bit old though and may cause problems with the current Asterisk CVS/releases. ---------------------------------------- Michael Shuler, C.E.O. BitWise Systems, Inc. 1301 W. Pioneer Parkway Peoria, IL 61615 Office: (217) 585-0357 Cell: (309) 657-6365 Fax: (309) 213-3500 E-Mail: mike@bwsys.net Customer Service: (877) 976-0711> -----Original Message----- > From: asterisk-users-admin@lists.digium.com > [mailto:asterisk-users-admin@lists.digium.com] On Behalf Of > Joao Carlos Moura > Sent: Monday, March 15, 2004 11:53 AM > To: asterisk-users@lists.digium.com > Subject: [Asterisk-Users] asterisk MySQL > > > I need to develop an web interface to include clients automatically in > Asterisk. So, to make this possible I need > that all my peers and exten being at a database (Mysql). > Where do I find doc?s regarded for it? > > Thank you very much, > J Moura > > _______________________________________________ > 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 >
Hi all, I am using MySQL query inside my extentions.conf. i have more than 200 agents using the same extentions and i can see in each request asterisk try to connect mysql. My question is, Is there any way to make only one connection for all users who is using the same extentions. Here is my example working extentions: [mysqlt] exten => _X.,1,MYSQL(Connect connid 192.168.1.65 username password database) exten => _X.,2,MYSQL(Query r ${connid} INSERT\ INTO\ Userstabl\ set\ user=921) exten => s,n,MYSQL(Disconnect ${connid}) Please advice me how i can make one connection for all users? Thank You Abdul __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com