Hello,

see the discussion started by:

http://lists.sip-router.org/pipermail/sr-users/2015-October/date.html

With old versions, you can try with next example at the top of request route:

if($var(do) == 0) { lock("start"); if($sht(do)==0) { $sht(do) = 1; $var(do) = 1; } else { $var(do) = 2; } unlock("start"); }

if($var(do)==1) { $var(do) = 2; # do here the one time operations }

Cheers, Daniel

On 08/10/15 10:00, Sunil More wrote:

Hi All,

I am new to Kamailio world. I am trying to initialize some details at Kamailio startup, this requires some database queries from a few tables.

I have read about the htable event, however sql queries are not working in this route. I have come upon following errors. Please suggest a solution for this.

Route used:

event_route[htable:mod-init] { xlog("L_INFO", "********Initailising the startup route ******\n"); sql_xquery("cb","SELECT id, media_server_port, name FROM domains","ra"); }

error :

Oct 8 13:28:32 P172 /usr/local/kamailio/sbin/kamailio[28735]: INFO:

<script>: ********Initailising the startup route ****** Oct 8 13:28:32 P172 kamailio: ERROR: <core> [daemonize.c:303]: daemonize(): Main process exited before writing to pipe Thanking You, Sunil More Ph : 9503338275 _______________________________________________ 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