<div dir="ltr"><div><div><div><div><div>Hi Daniel,<br><br></div>I'm using 4.1.3<br><br></div>I used this, because I found it in an example written by you.<br><a href="http://by-miconda.blogspot.de/2009/12/best-of-new-in-kamailio-300-9.html">http://by-miconda.blogspot.de/2009/12/best-of-new-in-kamailio-300-9.html</a><br>

<br></div>Is there any other way I can initialize a hash with values from a database table not explicitly designed for use with htable module? (The other way I could solve my problem would be if I could use the is_domain_local() from the domain module also in the onreply_route.)<br>

<br></div><div>Thanks, Hugh, for pointing out the crash. I found a couple of core files from my test on my file system, too. I didn't see the "core was generated" message in the log, so I didn't think there was one there.<br>

</div><div><br></div>Best Regards,<br></div>Sebastian<br><div><div><div><div><div><div></div></div></div></div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, May 15, 2014 at 1:37 PM, Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
  
    
  
  <div bgcolor="#FFFFFF" text="#000000">
    Indeed, the db connection is not initialized at the time of
    executing event_route[htable:mod-init]. This is executed after all
    modules are initialized, but the sqlops connections are initialized
    in child init.<br>
    <br>
    However, it should not cause this crash. What version are you using?
    Because latest master and 4.1 have a simple condition at
    sql_api.c:257.<br>
    <br>
    Cheers,<br>
    Daniel<div><div class="h5"><br>
    <br>
    <div>On 15/05/14 12:44, Waite, Hugh wrote:<br>
    </div>
    </div></div><blockquote type="cite"><div><div class="h5">
      
      
      
      <div>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">I
            added this to my config to try and it caused a segfault on
            startup in sql_query.<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">It
            seems the db connection is not initialised at this point.<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
        <p class="MsoNormal"><span>(gdb) bt<u></u><u></u></span></p>
        <p class="MsoNormal"><span>#0  0x0000000000000000 in ?? ()<u></u><u></u></span></p>
        <p class="MsoNormal"><span>#1  0x00007f47450517ef in
            sql_do_query (con=0x7f474d573930, query=0x7ffffc18f350,
            res=0x7f474d7220a0) at sql_api.c:257<u></u><u></u></span></p>
        <p class="MsoNormal"><span>#2  0x00007f4745059a7b in sql_query
            (msg=0x7f47484ea540, dbl=0x7f474d573930 "@;WMG\177",
            query=0x7f474d6780e8 "\250\016rMG\177", res=0x7f474d7220a0
            "j8Wi") at sqlops.c:209<u></u><u></u></span></p>
        <p class="MsoNormal"><span>#3  0x0000000000419ca2 in do_action
            (h=0x7ffffc18fa50, a=0x7f474d7207b0, msg=0x7f47484ea540) at
            action.c:1117<u></u><u></u></span></p>
        <p class="MsoNormal"><span>#4  0x0000000000422878 in
            run_actions (h=0x7ffffc18fa50, a=0x7f474d720420,
            msg=0x7f47484ea540) at action.c:1599<u></u><u></u></span></p>
        <p class="MsoNormal"><span>#5  0x0000000000423017 in
            run_top_route (a=0x7f474d720420, msg=0x7f47484ea540,
            c=0x7ffffc18fa50) at action.c:1685<u></u><u></u></span></p>
        <p class="MsoNormal"><span>#6  0x00007f4742d1cbec in
            child_init (rank=-127) at htable.c:223<u></u><u></u></span></p>
        <p class="MsoNormal"><span>#7  0x00000000004f7ec2 in
            init_mod_child (m=0x7f474d56dad8, rank=-127) at
            sr_module.c:924<u></u><u></u></span></p>
        <p class="MsoNormal"><span>#8  0x00000000004f7d65 in
            init_mod_child (m=0x7f474d56e3e0, rank=-127) at
            sr_module.c:921<u></u><u></u></span></p>
        <p class="MsoNormal"><span>#9  0x00000000004f8048 in
            init_child (rank=-127) at sr_module.c:948<u></u><u></u></span></p>
        <p class="MsoNormal"><span>#10 0x000000000046ce42 in main_loop
            () at main.c:1571<u></u><u></u></span></p>
        <p class="MsoNormal"><span>#11 0x000000000047030b in main
            (argc=13, argv=0x7ffffc18fec8) at main.c:2533<u></u><u></u></span></p>
        <p class="MsoNormal"><span>(gdb) frame 1<u></u><u></u></span></p>
        <p class="MsoNormal"><span>#1  0x00007f47450517ef in
            sql_do_query (con=0x7f474d573930, query=0x7ffffc18f350,
            res=0x7f474d7220a0) at sql_api.c:257<u></u><u></u></span></p>
        <p class="MsoNormal"><b><span>257            
              if(con->dbf.raw_query(con->dbh, query,
              &db_res)!=0)<u></u><u></u></span></b></p>
        <p class="MsoNormal"><span>(gdb) p con<u></u><u></u></span></p>
        <p class="MsoNormal"><span>$1 = (sql_con_t *) 0x7f474d573930<u></u><u></u></span></p>
        <p class="MsoNormal"><span>(gdb) p con->dbf<u></u><u></u></span></p>
        <p class="MsoNormal"><b><span>$2 = {cap = 0, use_table = 0,
              init = 0, init2 = 0, close = 0, query = 0, fetch_result =
              0, raw_query = 0, free_result = 0, insert = 0, delete = 0,
              update = 0, replace = 0, last_inserted_id = 0,
              insert_update = 0, insert_delayed = 0,<u></u><u></u></span></b></p>
        <p class="MsoNormal"><b><span>  affected_rows = 0,
              start_transaction = 0, end_transaction = 0,
              abort_transaction = 0, query_lock = 0}<u></u><u></u></span></b></p>
        <p class="MsoNormal"><span>(gdb)<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Regards,<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Hugh<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
        <p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"" lang="EN-US">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"" lang="EN-US"> <a href="mailto:sr-users-bounces@lists.sip-router.org" target="_blank">sr-users-bounces@lists.sip-router.org</a>
            [<a href="mailto:sr-users-bounces@lists.sip-router.org" target="_blank">mailto:sr-users-bounces@lists.sip-router.org</a>]
            <b>On Behalf Of </b>Sebastian Damm<br>
            <b>Sent:</b> 15 May 2014 10:34<br>
            <b>To:</b> SIP Router - Kamailio (OpenSER) and SIP Express
            Router (SER) - Users Mailing List<br>
            <b>Subject:</b> [SR-Users] DB select htable:mod-init doesn't
            work<u></u><u></u></span></p>
        <p class="MsoNormal"><u></u> <u></u></p>
        <div>
          <div>
            <div>
              <div>
                <p class="MsoNormal" style="margin-bottom:12.0pt">Hi,<u></u><u></u></p>
              </div>
              <p class="MsoNormal" style="margin-bottom:12.0pt">I'm
                trying to fill a hash table on startup in the
                htable:mod-init event route. But it doesn't work.
                Kamailio doesn't start at all, but doesn't print out an
                error in the log.<u></u><u></u></p>
            </div>
            <p class="MsoNormal" style="margin-bottom:12.0pt">This is
              what the route looks like:<br>
              <br>
              event_route[htable:mod-init] {<br>
                      xlog("L_NOTICE", "Loading Carrier domains into
              Hash table.\n");<br>
                      sql_query("ser", "select domain_name from
              carrier_domains", "domains");<br>
                      xlog("L_NOTICE", "Loaded from database...\n");<br>
                      while($var(i)<$dbr(domains=>cols)) {<br>
                              xlog("L_NOTICE", "Entry:
              $dbr(domains=>[$var(i),0])\n");<br>
                              $sht(carrierips=>$var(i)) =
              $dbr(domains=>[$var(i),0]);<br>
                              $var(i) = $var(i) + 1;<br>
                      }<br>
              }<u></u><u></u></p>
          </div>
          <p class="MsoNormal">Of course, the necessary parameters are
            set.<br>
            modparam("htable", "htable", "carrierips=>size=6")<br>
            modparam("sqlops","sqlcon","ser=>mysql://<a href="http://user:password@127.0.0.1/ser" target="_blank">user:password@127.0.0.1/ser</a>")<br clear="all">
            <u></u><u></u></p>
          <div>
            <div>
              <div>
                <div>
                  <p class="MsoNormal"><u></u> <u></u></p>
                </div>
                <div>
                  <p class="MsoNormal" style="margin-bottom:12.0pt">In
                    the log I see the following:<br>
                    May 15 11:25:33 linux /usr/sbin/kamailio[20872]:
                    NOTICE: <script>: Loading Carrier domains into
                    Hash table.<u></u><u></u></p>
                </div>
                <div>
                  <p class="MsoNormal" style="margin-bottom:12.0pt">As
                    you can see, there should be a lot more output, but
                    nothing happens anymore after that. In ngrep I see
                    other queries going to the same database from other
                    modules, but my query from the event route is never
                    executed.<u></u><u></u></p>
                </div>
                <div>
                  <p class="MsoNormal" style="margin-bottom:12.0pt">Am I
                    missing something?<u></u><u></u></p>
                </div>
                <div>
                  <p class="MsoNormal">Best Regards,<br>
                    Sebastian<u></u><u></u></p>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
      <br>
      <hr>
      <font color="Gray" face="Arial" size="1">This e-mail and any
        attachment is for authorised use by the intended recipient(s)
        only. It may contain proprietary material, confidential
        information and/or be subject to legal privilege. It should not
        be copied, disclosed to, retained or used by, any other party.
        If you are not an intended recipient then please promptly delete
        this e-mail and any attachment and all copies and inform the
        sender. Thank you for understanding.<br>
      </font>
      <br clear="all">
      <br>
      <fieldset></fieldset>
      <br>
      </div></div><div class=""><pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
    </div></blockquote><span class="HOEnZb"><font color="#888888">
    <br>
    <pre cols="72">-- 
Daniel-Constantin Mierla - <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a href="http://twitter.com/#!/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a></pre>
  </font></span></div>

<br>_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br></blockquote></div><br><a href="http://www.sipgate.co.uk" target="_blank"></a>
</div></div>