<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
    <title></title>
  </head>
  <body bgcolor="#ffffff" text="#000000">
    Hello,<br>
    <br>
    first, keep the mailing list on cc, otherwise future emails will be
    ignored.<br>
    <br>
    Then, the -ddd and -E parameters are for kamailio, not kamctl.<br>
    <br>
    Just run:<br>
    <br>
    kamailio -ddd -E<br>
    <br>
    of course, if you have a custom path to your config, keep you -c
    /path/to/cfg parameter.<br>
    <br>
    Cheers,<br>
    Daniel<br>
    <br>
    <br>
    On 8/18/10 6:20 PM, truong ngoc THANH wrote:
    <blockquote cite="mid:672752.22365.qm@web43139.mail.sp1.yahoo.com"
      type="cite">
      <style type="text/css"><!-- DIV {margin:0px;} --></style>
      <div style="font-family: times new roman,new york,times,serif;
        font-size: 12pt;">thanks Daniel,<br>
        thanks for help, but i cannot start :kamctl -ddd -E<br>
        or kamctl -ddd<br>
        or kamctl -E.<br>
        and can you show me how it work, or how the result when i
        declare the parameter, and how do I know the parameter is used
        for ?<br>
        so nice too get your help.<br>
        <div> </div>
        TRUONG NGOC THANH<br>
        Telecommunications Engineer<br>
        Tel: 0984 480 646<br>
        Y!M: ngoc217thanh
        <div><br>
        </div>
        <div style="font-family: times new roman,new york,times,serif;
          font-size: 12pt;"><br>
          <div style="font-family: times new roman,new york,times,serif;
            font-size: 12pt;"><font face="Tahoma" size="2">
              <hr size="1"><b><span style="font-weight: bold;">From:</span></b>
              Daniel-Constantin Mierla <a class="moz-txt-link-rfc2396E" href="mailto:miconda@gmail.com">&lt;miconda@gmail.com&gt;</a><br>
              <b><span style="font-weight: bold;">To:</span></b> truong
              ngoc THANH <a class="moz-txt-link-rfc2396E" href="mailto:ngoc217thanh@yahoo.com">&lt;ngoc217thanh@yahoo.com&gt;</a><br>
              <b><span style="font-weight: bold;">Cc:</span></b>
              kamailio <a class="moz-txt-link-rfc2396E" href="mailto:sr-users@lists.sip-router.org">&lt;sr-users@lists.sip-router.org&gt;</a><br>
              <b><span style="font-weight: bold;">Sent:</span></b> Wed,
              August 18, 2010 10:47:58 PM<br>
              <b><span style="font-weight: bold;">Subject:</span></b>
              Re: [SR-Users] help to config cfg_db module in kamailio
              3.0.1<br>
            </font><br>
            Hello,<br>
            <br>
            not a user of this module, however, start kamailio with
            parameters -ddd -E and paste the output here.<br>
            <br>
            Do you declare my.route_addr in config file as well? Might
            be that the parameter is declared in cfg_custom table, the
            startup debug log should give more hints.<br>
            <br>
            Thanks,<br>
            Daniel<br>
            <br>
            <br>
            On 8/18/10 7:13 AM, truong ngoc THANH wrote:
            <blockquote type="cite">
              <div style="font-family: times new roman,new
                york,times,serif; font-size: 12pt;">
                <style>
<!--
 
 _filtered {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;}
 _filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
 
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"sans-serif";}
span.EmailStyle15
        {font-family:"sans-serif";color:windowtext;}
.MsoChpDefault
        {}
 _filtered {margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
        {}
-->
</style>
                <p class="MsoNormal">Hi all ,</p>
                <p class="MsoNormal">I try to configure with cfg_db, but
                  after create and insert value into tables in mysql , I
                  cannot start kamailio.</p>
                <p class="MsoNormal">I add My config in kamalio.cfg</p>
                <p class="MsoNormal">==============</p>
                <p class="MsoNormal">Loadmodule “<a
                    moz-do-not-send="true" target="_blank"
                    href="http://cfg_db.so">cfg_db.so</a>”</p>
                <p class="MsoNormal">modparam("cfg_db", "db_url",
                  "mysql://openser:openserrw@localhost/kamailio")</p>
                <p class="MsoNormal">modparam("cfg_db", "transl_tbl",
                  "cfg_transl")</p>
                <p class="MsoNormal">modparam("cfg_db", "custom_tbl",
                  "cfg_custom")</p>
                <p class="MsoNormal">  </p>
                <p class="MsoNormal">I add and insert in mysql as:</p>
                <p class="MsoNormal">===============</p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;">cfg_transl table:</span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span>group_name|name|cfg_table|cfg_table_group_name_field|cfg_table_name_field|cfg_table_value_field</span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span>core|use_dst_blacklist|cfg_dns|||</span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span>core|dst_blacklist_mem|cfg_dns|||</span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span>core|dst_blacklist_expire|||</span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span>my|route_addr|cfg_my|my_group_name|my_name|my_value<span
                      style="">   </span>; overrides &lt;default&gt;
                    values</span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span>my|use_rtp_proxy|cfg_my|my_group_name|my_name|my_value</span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span>*|*||||<span
                      style=""> </span>; matches all param ids, points
                    to tables defined in row &lt;default&gt;</span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span>&lt;default&gt;||cfg_var|group_name|name|value<span
                      style="">  </span>; default cfg_table* values</span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">               </span></span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span>cfg_custom
                    table:</span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span>group_name|name|value_type|min_value|max_value|description</span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span>my|route_addr|S|||Routing
                    address</span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span>my|use_rtp_proxy|I|0|1|Use
                    RTP proxy</span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span></span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span>cfg_var table:</span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span>group_name|my_name|value</span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span>core|debug|4</span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span></span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span>cfg_my table:</span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span>my_group_name|my_name|my_value</span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span>my|route_addr|127.0.0.1</span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span>my|use_rtp_proxy|1</span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span></span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span>cfg_dns table:</span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span>group_name|name|value</span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span>dns|use_dst_blacklist|1</span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span>dns|dst_blacklist_mem|1024</span></p>
                <p class="MsoNormal" style=""><span style="font-size:
                    10pt;"><span style="">        </span>dns|dst_blacklist_expire|60</span></p>
                <p class="MsoNormal">  </p>
                <p class="MsoNormal">when I start kamailio<span style=""> 
                  </span>the log show :</p>
                <p class="MsoNormal">===============</p>
                <p class="MsoNormal">Aug 18 12:04:56 appliance
                  /usr/local/sbin/kamailio[2771]: INFO: usrloc
                  [hslot.c:53]: locks array size 512</p>
                <p class="MsoNormal">Aug 18 12:04:56 appliance
                  /usr/local/sbin/kamailio[2771]: ERROR: &lt;core&gt;
                  [cfg/cfg_script.c:80]: ERROR: new_cfg_script_var():
                  variable already exists: my.route_addr</p>
                <p class="MsoNormal">Aug 18 12:04:56 appliance
                  /usr/local/sbin/kamailio[2771]: ERROR: cfg_db
                  [cfg_db.c:335]: cfg_db: Error declaring cfg int
                  'my.route_addr'</p>
                <p class="MsoNormal">Aug 18 12:04:56 appliance
                  /usr/local/sbin/kamailio[2771]: ERROR: &lt;core&gt;
                  [sr_module.c:860]: init_mod(): Error while
                  initializing module cfg_db</p>
                <p class="MsoNormal">  </p>
                <p class="MsoNormal">Thanks for looking.</p>
                <div> </div>
                TRUONG NGOC THANH<br>
                Telecommunications Engineer<br>
                Tel: 0984 480 646<br>
                Y!M: ngoc217thanh
                <div><br>
                </div>
              </div>
              <br>
              <pre><fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a moz-do-not-send="true" rel="nofollow" class="moz-txt-link-abbreviated" ymailto="mailto:sr-users@lists.sip-router.org" target="_blank" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><span>
<a moz-do-not-send="true" target="_blank" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</span></pre>
            </blockquote>
            <br>
            <pre class="moz-signature">-- 
Daniel-Constantin Mierla
<span><a moz-do-not-send="true" target="_blank" href="http://www.asipto.com/">http://www.asipto.com/</a></span>
</pre>
          </div>
        </div>
      </div>
      <br>
    </blockquote>
    <br>
    <pre class="moz-signature" cols="72">-- 
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://www.asipto.com/">http://www.asipto.com/</a>
</pre>
  </body>
</html>