Hello all! I am trying to load sip.conf from mysql database. I have followed the instructions at <http://www.voip-info.org/wiki-Asterisk+sip+mysql+peers>. Seems that the authentication (user & psw) works fine but I would like to get more information from mysql and I don't know how to retrieve it. Could anybody help me? Any idea about how to do it? Regards, Victor. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20040910/e4b4b6d6/attachment.htm
What more information? Are you talking about mailbox, nat, etc..all those other options for SIP phones? I want to do SIP from database as well but most of our phones are NAT and need that option stored in the database. Matthew ----- Original Message ----- From: "Victor Alvarez" <victor@sentidocomun.es> To: <Asterisk-Users@lists.digium.com> Sent: Friday, September 10, 2004 6:50 AM Subject: [Asterisk-Users] sip.conf from mysql Hello all! I am trying to load sip.conf from mysql database. I have followed the instructions at <http://www.voip-info.org/wiki-Asterisk+sip+mysql+peers>. Seems that the authentication (user & psw) works fine but I would like to get more information from mysql and I don't know how to retrieve it. Could anybody help me? Any idea about how to do it? Regards, Victor. ---------------------------------------------------------------------------- ----> _______________________________________________ > 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
Victor Alvarez wrote:> I am trying to load sip.conf from mysql database. I have followed the > instructions at > _<http://www.voip-info.org/wiki-Asterisk+sip+mysql+peers>_. Seems that > the authentication (user & psw) works fine but I would like to get more > information from mysql and I don't know how to retrieve it.If you can live with a less-dynamic approach, check out: http://www.voip-info.org/wiki-Asterisk+sip+conf+from+mysql Using this 'keyword' & 'data' structure, you can have whatever keyword=value pairs you like in sip.conf. Use retrieve_sip_conf_from_mysql.pl to read the mysql table and write-out sip.conf. ryan
Hi, First of all thank you Matthew, Nicolas and Ryan for your response. I would like to get information like context, mailbox, callgroup, pickupgroup, codecs... also nat! If I make the substitution of the text file i wouldn't like to miss information in the process. retrieve_sip_conf_from_mysql.pl seems to be a good B plan. I will have to recharge sip.conf manually but.. If this is the way, I will follow it. Anyway if plan A works with user and password, Why it can't work with the rest of parameters?? I'll continue my work on Monday. Have a nice weekend! Victor. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20040910/3ec26a91/attachment.htm
Hi, After evaluate the different options, I have decided make an attempt changing chan_sip.c to retrieve full sip.conf from mysql database. Since Matthew may have made advances during last weekend, It would be good have a quick report of your research. I will also try to contact Ehud Gavron, the author of the current version according to chan_sip.c. Cheers, Victor Alvarez. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20040913/4ceef7bf/attachment.htm