Hi Fred,
Thanks for your response.
Still getting to grips with Kamailio but so far so good.
Kind regards, Luke
On 2 December 2015 at 18:07, Fred Posner fred@palner.com wrote:
On 12/02/2015 06:22 AM, Luke Milbourne wrote:
Hi All,
I need to run some SQL and then set the destination URI according to the results, if any.
I've got this working using APP_LUA, however, I've noticed SQLOPS.
Can anyone advise on which method is likely to produce better results.
I'm assuming my Lua function is connecting to the DB and then disconnecting each time.
If I use SQLOPS, does this mean Kamailio will keep a connection available to the DB?
-- Luke Milbourne mailto:luke.milbourne@gmail.com
Tel: 07857154817 Google Talk/Email: luke.milbourne@gmail.com mailto:luke.milbourne@gmail.com
SQLOPS is a great tool and allows you to free when desired (sql_result_free) as well as store the query results in xavps (or other methods). You can run sql queries as well as call stored procedures.
You could easily run the query, store in xavp, free results and the use the xavps later on (such as in failed route, etc).
Fred Posner The Palner Group, Inc. http://www.palner.com (web) +1-224-334-3733 (direct)
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users