It's been a while since I've needed this but I think gflags + avpops might be slightly more elegant. YMMV. I'm not sure what the overheard to calling a perl function is (however i hear with the perl mod, it's very fast). I'd love to hear feedback on this....
-Brett On Thu, May 28, 2009 at 1:42 AM, Alex Massover <[email protected]> wrote: > Not exactly, but something like this is possible – the script will run on > every INVITE transaction, but it will do a query only once at first run > (once per every process/child). > > > > You run a perl script for example on every INVITE, inside the script you > have something like: > > > > > > our $query_result; > > unless(defined($query_result)) > > { > > $query_result=……… #run your query here > > } > > #pass your query result to avp values or whatever > > > > > > > > The $query_result will be stored in the memory. > > > > -- > > Best Regards, > > Alex Massover > > VoIP R&D TL > > Jajah Inc. > > *From:* Sharath [mailto:[email protected]] > *Sent:* Thursday, May 28, 2009 1:38 AM > *To:* Alex Massover > *Cc:* [email protected] > *Subject:* Re: [OpenSIPS-Users] Sqlops in opensips ? > > > > Is it possible to load *custom values from a database from a custom table > during init time. Am I correct in assuming the AVPops module is scoped only > for a call within a transaction ? Can the perl module be used to make a db > query at init time ? > > thanks for answering. > -Sharath > > On Wed, May 27, 2009 at 7:46 AM, Alex Massover <[email protected]> wrote: > > > > I think perl module is most practical for you. > > > > -- > > Best Regards, > > Alex Massover > > VoIP R&D TL > > Jajah Inc. > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Sharath > *Sent:* Wednesday, May 27, 2009 12:42 AM > *To:* [email protected] > *Subject:* [OpenSIPS-Users] Sqlops in opensips ? > > > > hello, > > > Is there any module equivalent to sqlops of openser in opensips ? Basically > I want to run sql queries from proprietary tables and use them in the route > script file. > > thank you > -Sharath > > This mail was received via Mail-SeCure System. > > > > This mail was sent via Mail-SeCure System. > > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > > > This mail was received via Mail-SeCure System. > > > This mail was sent via Mail-SeCure System. > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
