hi, i'm reading a lot docs about asterisk realtime but i cannot understand how works sip realtime static i need NAT/qualify for SIP. this is not possible with dynamic realtime i want - save data to sql - asterisk -rx "reload" to read config (sip.conf with sip users) from sql it is possible? can you point me to some examples? thanks --------------------------------------- Marek Cervenka =======================================
You'll need to create a php or perl script to load your sip table into a txt file before doing a reload. You can create your own or just steal the code from AMP and modify it a tad. I believe the file name is retrieve_sip_conf_from_mysql.pl bp On 7/25/06, marek cervenka <cervajs@fpf.slu.cz> wrote:> hi, > > i'm reading a lot docs about asterisk realtime > but i cannot understand how works sip realtime static > > i need NAT/qualify for SIP. this is not possible with dynamic realtime > i want > - save data to sql > - asterisk -rx "reload" to read config (sip.conf with sip users) from sql > > it is possible? > can you point me to some examples? > thanks > > --------------------------------------- > Marek Cervenka > ======================================> > _______________________________________________ > --Bandwidth and Colocation provided by Easynews.com -- > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20060725/6b1a3ab5/attachment.htm
On Wednesday 26 July 2006 00:03, marek cervenka wrote:> i'm reading a lot docs about asterisk realtime > but i cannot understand how works sip realtime static > > i need NAT/qualify for SIP. this is not possible with dynamic realtime > i want > - save data to sql > - asterisk -rx "reload" to read config (sip.conf with sip users) from sql > > it is possible?For sip realtime static you have probably read: http://www.voip-info.org/wiki/view/Asterisk+RealTime+Static However, NAT/qualify for SIP(users) is perfectly possible with "dynamic" realtime: http://www.voip-info.org/wiki/view/Asterisk+RealTime+Sip And `sip_buddies` table gives extensive opportunities(including nat and qualify). And there is the advantage of using it(realtime), you do not need to reload when a new user comes. (This is valid for the needed extensions and voicemail attributes, as well) Sorry for twisting a bit your question, but basically "realtime static" means to store a .conf file into a database(in which case you must delete its equivalent from /etc/asterisk); "realtime" is when you store users, peers and friends into the database, keeping the skeletons of sip&iax2.conf files in /etc/astrisk. In that case the "users, peers and friends" sip or iax2 info is being read "on the fly". The appropriate extensions though, must be addressed with "switch => Realtime " statement from extensions.conf. Since all .conf files exist they have precedence. Also register=> can be done only from a .conf file. Hope it helps. Benchev