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]<mailto:[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]>
[mailto:[email protected]<mailto:[email protected]>]
On Behalf Of Sharath
Sent: Wednesday, May 27, 2009 12:42 AM
To: [email protected]<mailto:[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]<mailto:[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
