<html>
  <head>
    <meta content="text/html; charset=windows-1252"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    Hello,<br>
    <br>
    note that the $rU is the outgoing number after processing via
    kamailio.cfg. If you want the incoming number, then use $oU.<br>
    <br>
    Cheers,<br>
    Daniel<br>
    <br>
    <div class="moz-cite-prefix">On 25/06/15 10:54, Yasin CANER wrote:<br>
    </div>
    <blockquote cite="mid:558BC1AB.2040406@netgsm.com.tr" type="cite">
      <meta http-equiv="content-type" content="text/html;
        charset=windows-1252">
      Hello;<br>
          ACC module with db_mysql writes  Request Uri to Dst_user
      column in my configuration. When a international call happens , in
      kamailio acc table dont write 00 prefix to dst_user even if  Mysql
      dst_user column defined varchar(64). my acc configuration is
      below. could you help me about how to fix this problem.<br>
      <br>
      For example; When i call "0014152616602"  , acc modules writes
      "14152616602" to dst_user.<br>
      <br>
      Kamailio  4.1.7 x86_64/linux<br>
      Mysql      5.5.38<br>
      <br>
      --------------------------- ACCDB conf----------------------<br>
      modparam("acc", "cdr_enable", 1)<br>
      modparam("acc", "early_media", 0)<br>
      modparam("acc", "report_ack", 1)<br>
      modparam("acc", "report_cancels", 1)<br>
      modparam("acc", "detect_direction", 0)<br>
      modparam("acc", "db_url", DBURLCDR)<br>
      modparam("acc", "log_flag", FLT_ACC)<br>
      modparam("acc", "db_missed_flag", FLT_ACCMISSED)<br>
      modparam("acc", "db_table_missed_calls", "missed_calls")<br>
      modparam("acc", "db_flag", 1)<br>
      modparam("acc", "db_missed_flag", 3)<br>
      modparam("acc", "acc_time_column", "calldatetime")<br>
      modparam("acc",
      "db_extra","src_user=$fU;src_domain=$fd;src_ip=$si;<u>dst_user=$rU</u>;dst_domain=$rd;src_ousername=$avp(poparty);networkdatetime=$avp(networkdatetime)")<br>
-----------------------------------------------------------------------------------<br>
      <br>
      <br>
      PS. it calls correctly.<br>
      <div class="moz-signature">-- <br>
        <meta http-equiv="Content-Type" content="text/html;
          charset=windows-1252">
        <title></title>
        <div align="left">
          <div style="width:300px;" align="left"> <a
              moz-do-not-send="true" href="http://www.netgsm.com.tr"
              target="_blank"> <img
                src="cid:part1.01010302.03080808@gmail.com"
                alt"netgsm"="" border="0"> </a> </div>
        </div>
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
    </blockquote>
    <br>
    <pre class="moz-signature" cols="72">-- 
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Book: SIP Routing With Kamailio - <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a></pre>
  </body>
</html>