<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#ffffff" text="#000000">
    <tt>Hi Khaled,<br>
      <br>
      All the time the ACC module writes into the ACC table (and not
      into CDRS table) - the record you get into ACC table actually
      reflects a CDR - it has duration, setuptime, everything. <br>
      <br>
      So you get your CDR :)<br>
      <br>
      Regards,<br>
    </tt>
    <pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
    <br>
    On 04/04/2013 05:17 PM, M.Khaled W Chehab wrote:
    <blockquote cite="mid:019301ce313f$1b2ba970$5182fc50$@icucall.com"
      type="cite">
      <meta http-equiv="Content-Type" content="text/html;
        charset=ISO-8859-1">
      <meta name="Generator" content="Microsoft Word 14 (filtered
        medium)">
      <style><!--
/* Font Definitions */
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
        {font-family:Consolas;
        panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
        {font-family:"Courier New \;";
        panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri","sans-serif";
        color:black;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
pre
        {mso-style-priority:99;
        mso-style-link:"HTML Preformatted Char";
        margin:0in;
        margin-bottom:.0001pt;
        font-size:10.0pt;
        font-family:"Courier New";
        color:black;}
tt
        {mso-style-priority:99;
        font-family:"Courier New";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
        {mso-style-priority:99;
        mso-style-link:"Balloon Text Char";
        margin:0in;
        margin-bottom:.0001pt;
        font-size:8.0pt;
        font-family:"Tahoma","sans-serif";
        color:black;}
span.HTMLPreformattedChar
        {mso-style-name:"HTML Preformatted Char";
        mso-style-priority:99;
        mso-style-link:"HTML Preformatted";
        font-family:Consolas;
        color:black;}
span.BalloonTextChar
        {mso-style-name:"Balloon Text Char";
        mso-style-priority:99;
        mso-style-link:"Balloon Text";
        font-family:"Tahoma","sans-serif";}
span.EmailStyle22
        {mso-style-type:personal;
        font-family:"Calibri","sans-serif";
        color:windowtext;}
span.EmailStyle23
        {mso-style-type:personal;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
span.EmailStyle24
        {mso-style-type:personal;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
span.EmailStyle25
        {mso-style-type:personal;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
span.EmailStyle26
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page WordSection1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
        {page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
      <div class="WordSection1">
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Hi
            Bogdan,<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><o:p>&nbsp;</o:p></span></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">mysql&gt;
            select * from acc limit 1 ;<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">+----+--------+----------+-------------------+------------------+----------+------------+---------------------+--------+----------+------------+-----------+---------------------+----------------------------+----------------------------------+---------+-----+-----------------+--------------+-----------+---------+--------------+----------------+---------+-----------------------------------+-----+------+------+-------+-----------+------+--------------+-----------+-------------------+---------------------+---------------+<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">| id
            | method | from_tag | to_tag&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | callid&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
            sip_code | sip_reason | time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | cdr_id |
            duration | durationms | setuptime | created&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
            from_uri&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
            to_uri&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | gateway | ani |
            dest&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | source&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;| callsetup | leg_src |
            leg_dst&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | via&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | timeout |
            uaA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | uaB | uuid | pdd&nbsp; |
            rate&nbsp; | cusid&nbsp;&nbsp;&nbsp;&nbsp; | cost | dstname&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | dstprefix |
            trunkdialednumber | timestamp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | failure_count |<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">+----+--------+----------+-------------------+------------------+----------+------------+---------------------+--------+----------+------------+-----------+---------------------+----------------------------+----------------------------------+---------+-----+-----------------+--------------+-----------+---------+--------------+----------------+---------+-----------------------------------+-----+------+------+-------+-----------+------+--------------+-----------+-------------------+---------------------+---------------+<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">|&nbsp; 1
            | INVITE | 1a5a4937 | 3573387689-983960 | 1c11f97fbb29600c |
            200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | OK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 2013-03-27 15:41:42 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            19 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18782 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15 | 2013-03-27 15:41:27 |
            <a class="moz-txt-link-rfc2396E" href="sip:ew@77.42.241.66:8036">&lt;sip:ew@77.42.241.66:8036&gt;</a> |
            <a class="moz-txt-link-freetext" href="sip:777201001168108@5.104.224.33">sip:777201001168108@5.104.224.33</a> | Provider1 &nbsp;| ew&nbsp; |
            777201001168108 | 77.42.241.66 | NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
            201001168108 | 74.201.101.201 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | eyeBeam release
            3007n stamp 17816 |&nbsp;&nbsp;&nbsp;&nbsp; | NULL |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 0.031 | 100000020 |
            NULL | Egypt-Mobile | 777201&nbsp;&nbsp;&nbsp; | 201001168108&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
            2013-03-27 15:42:01 | 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;|<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">+----+--------+----------+-------------------+------------------+----------+------------+---------------------+--------+----------+------------+-----------+---------------------+----------------------------+----------------------------------+---------+-----+-----------------+--------------+-----------+---------+--------------+----------------+---------+-----------------------------------+-----+------+------+-------+-----------+------+--------------+-----------+-------------------+---------------------+---------------+<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><o:p>&nbsp;</o:p></span></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">mysql&gt;
            select * from cdrs&nbsp; limit 1 ;<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">+--------+---------------------+---------------------+----------+------------+------------------+--------------+-------------------+---------------------+-----+-----------------+--------------+----------------+----------+-----+---------+---------+------------+-----------+--------------+-----------+------------+---------------+---------+-------------+<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">|
            cdr_id | call_start_time&nbsp;&nbsp;&nbsp;&nbsp; | call_end_time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
            duration | durationms | sip_call_id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | sip_from_tag |
            sip_to_tag&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | created&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | ani |
            dest&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | source&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | via&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | sip_code |
            pdd | bye_leg | rate&nbsp;&nbsp;&nbsp; | cost&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;| cusid&nbsp;&nbsp;&nbsp;&nbsp; |
            dstname&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | dstprefix | sip_reason | customer_name |
            gateway | accduration |<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">+--------+---------------------+---------------------+----------+------------+------------------+--------------+-------------------+---------------------+-----+-----------------+--------------+----------------+----------+-----+---------+---------+------------+-----------+--------------+-----------+------------+---------------+---------+-------------+<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><o:p>&nbsp;</o:p></span></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">There
            is a difference in field as I am not getting any error while
            debugging using debug level 4 , moreover I was running store
            procedure before to fill cdrs table &nbsp;,now I am trying to let
            opensips write cdr &nbsp;directly to cdrs table .<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Regards<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);"> <o:p></o:p></span></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><o:p>&nbsp;</o:p></span></p>
        <div>
          <div style="border-right: medium none; border-width: 1pt
            medium medium; border-style: solid none none; border-color:
            rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color;
            padding: 3pt 0in 0in;">
            <p class="MsoNormal"><b><span style="font-size: 10pt;
                  font-family:
                  &quot;Tahoma&quot;,&quot;sans-serif&quot;; color:
                  windowtext;">From:</span></b><span style="font-size:
                10pt; font-family:
                &quot;Tahoma&quot;,&quot;sans-serif&quot;; color:
                windowtext;"> Bogdan-Andrei Iancu
                [<a class="moz-txt-link-freetext" href="mailto:bogdan@opensips.org">mailto:bogdan@opensips.org</a>] <br>
                <b>Sent:</b> Thursday, April 04, 2013 4:11 PM<br>
                <b>To:</b> M.Khaled W Chehab<br>
                <b>Cc:</b> 'OpenSIPS users mailling list'<br>
                <b>Subject:</b> Re: [OpenSIPS-Users] ACC CDR<o:p></o:p></span></p>
          </div>
        </div>
        <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
        <p class="MsoNormal"><tt><span style="font-size: 10pt;">Could
              you post the record from DB ?</span></tt><span
            style="font-size: 10pt; font-family: &quot;Courier
            New&quot;;"><br>
            <br>
            <tt>Regards,</tt><br>
            <br>
          </span><o:p></o:p></p>
        <pre>Bogdan-Andrei Iancu<o:p></o:p></pre>
        <pre>OpenSIPS Founder and Developer<o:p></o:p></pre>
        <pre><a moz-do-not-send="true" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a><o:p></o:p></pre>
        <p class="MsoNormal"><br>
          On 04/04/2013 03:36 PM, M.Khaled W Chehab wrote: <o:p></o:p></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Yes
            I can get the &nbsp;records &nbsp;in acc &nbsp;table </span><o:p></o:p></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">&nbsp;</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Regards</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">&nbsp;</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">&nbsp;</span><o:p></o:p></p>
        <div>
          <div style="border-right: medium none; border-width: 1pt
            medium medium; border-style: solid none none; padding: 3pt
            0in 0in; border-color: -moz-use-text-color;">
            <p class="MsoNormal"><b><span style="font-size: 10pt;
                  font-family:
                  &quot;Tahoma&quot;,&quot;sans-serif&quot;; color:
                  windowtext;">From:</span></b><span style="font-size:
                10pt; font-family:
                &quot;Tahoma&quot;,&quot;sans-serif&quot;; color:
                windowtext;"> Bogdan-Andrei Iancu [<a
                  moz-do-not-send="true"
                  href="mailto:bogdan@opensips.org">mailto:bogdan@opensips.org</a>]
                <br>
                <b>Sent:</b> Thursday, April 04, 2013 3:16 PM<br>
                <b>To:</b> M.Khaled W Chehab<br>
                <b>Cc:</b> 'OpenSIPS users mailling list'<br>
                <b>Subject:</b> Re: [OpenSIPS-Users] ACC CDR</span><o:p></o:p></p>
          </div>
        </div>
        <p class="MsoNormal">&nbsp;<o:p></o:p></p>
        <p class="MsoNormal"><tt><span style="font-size: 10pt;">And you
              get no record in the "ACC" table ?</span></tt><span
            style="font-size: 10pt; font-family: &quot;Courier New
            ;&quot;,&quot;serif&quot;;"><br>
            <br>
          </span><tt><span style="font-size: 10pt;">Regards,</span></tt><span
            style="font-size: 10pt; font-family: &quot;Courier New
            ;&quot;,&quot;serif&quot;;"><br>
            <br>
            <br>
          </span><o:p></o:p></p>
        <pre>Bogdan-Andrei Iancu<o:p></o:p></pre>
        <pre>OpenSIPS Founder and Developer<o:p></o:p></pre>
        <pre><a moz-do-not-send="true" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a><o:p></o:p></pre>
        <p class="MsoNormal"><br>
          On 04/04/2013 03:13 PM, M.Khaled W Chehab wrote: <o:p></o:p></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Hi
            Bogdan,</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">&nbsp;</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Already&nbsp;
            dialog module loaded ,</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">$var(a) =
            "udp:"+$avp(termip)+":5060";</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            $fs = $var(a) ;</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">&nbsp;</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">setflag(1); #
            do accounting</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            setflag(2); #Missed calls</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            #setflag(3); #transaction falis</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            setflag(4); #CDR flag</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            # create dialog with timeout</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            if ( !create_dialog("B") ) {</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            send_reply("500","Internal Server Error");</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            exit;</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            }</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            $dlg_val("customerid") = $avp(Cusid);</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            engage_media_proxy();</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            topology_hiding();</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">please advice </span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">regards</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">&nbsp;</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">&nbsp;</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">&nbsp;</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">&nbsp;</span><o:p></o:p></p>
        <div>
          <div style="border-right: medium none; border-width: 1pt
            medium medium; border-style: solid none none; padding: 3pt
            0in 0in; border-color: -moz-use-text-color;">
            <p class="MsoNormal"><b><span style="font-size: 10pt;
                  font-family:
                  &quot;Tahoma&quot;,&quot;sans-serif&quot;; color:
                  windowtext;">From:</span></b><span style="font-size:
                10pt; font-family:
                &quot;Tahoma&quot;,&quot;sans-serif&quot;; color:
                windowtext;"> Bogdan-Andrei Iancu [<a
                  moz-do-not-send="true"
                  href="mailto:bogdan@opensips.org">mailto:bogdan@opensips.org</a>]
                <br>
                <b>Sent:</b> Thursday, April 04, 2013 3:10 PM<br>
                <b>To:</b> M.Khaled W Chehab<br>
                <b>Cc:</b> 'OpenSIPS users mailling list'<br>
                <b>Subject:</b> Re: [OpenSIPS-Users] ACC CDR</span><o:p></o:p></p>
          </div>
        </div>
        <p class="MsoNormal">&nbsp;<o:p></o:p></p>
        <p class="MsoNormal"><tt><span style="font-size: 10pt;">Hi
              Khaled,</span></tt><span style="font-size: 10pt;
            font-family: &quot;Courier New&quot;;"><br>
            <br>
            <tt>Load the "dialog" module too and do "create_dialog()"
              for the initial INVITEs.</tt><br>
            <br>
            <tt>Regards,</tt><br>
            <br>
            <br>
            <br>
          </span><o:p></o:p></p>
        <pre>Bogdan-Andrei Iancu<o:p></o:p></pre>
        <pre>OpenSIPS Founder and Developer<o:p></o:p></pre>
        <pre><a moz-do-not-send="true" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a><o:p></o:p></pre>
        <p class="MsoNormal"><br>
          On 04/03/2013 06:48 PM, M.Khaled W Chehab wrote: <o:p></o:p></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Hello,</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">&nbsp;</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="color: rgb(31, 73, 125);">I
            already add &nbsp;the below config to my script and no call can
            be found in cdrs table </span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            modparam("acc", "db_flag", 1)</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            modparam("acc", "db_missed_flag", 2)</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            modparam("acc", "log_missed_flag", 2)</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            modparam("acc", "failed_transaction_flag", 3)</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            modparam("acc", "cdr_flag", 4)</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if
            (!has_totag() &amp;&amp;is_method("INVITE")) {</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            setflag(1); # do accounting</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            setflag(2); #Missed calls</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            #setflag(3); #transaction falis</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; setflag(4); #CDR flag</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">whats missing ?</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">Regards</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">Khaled</span><o:p></o:p></p>
        <p class="MsoNormal"><span style="font-size: 9pt; font-family:
            &quot;Courier New&quot;; color: windowtext;">&nbsp;</span><o:p></o:p></p>
        <div>
          <div style="border-right: medium none; border-width: 1pt
            medium medium; border-style: solid none none; padding: 3pt
            0in 0in; border-color: -moz-use-text-color;">
            <p class="MsoNormal"><b><span style="font-size: 10pt;
                  font-family:
                  &quot;Tahoma&quot;,&quot;sans-serif&quot;; color:
                  windowtext;">From:</span></b><span style="font-size:
                10pt; font-family:
                &quot;Tahoma&quot;,&quot;sans-serif&quot;; color:
                windowtext;"> Bogdan-Andrei Iancu [<a
                  moz-do-not-send="true"
                  href="mailto:bogdan@opensips.org">mailto:bogdan@opensips.org</a>]
                <br>
                <b>Sent:</b> Wednesday, April 03, 2013 6:25 PM<br>
                <b>To:</b> OpenSIPS users mailling list<br>
                <b>Cc:</b> M.Khaled W Chehab<br>
                <b>Subject:</b> Re: [OpenSIPS-Users] ACC CDR</span><o:p></o:p></p>
          </div>
        </div>
        <p class="MsoNormal">&nbsp;<o:p></o:p></p>
        <p class="MsoNormal"><tt><span style="font-size: 10pt;">Hello,</span></tt><span
            style="font-size: 10pt; font-family: &quot;Courier New
            ;&quot;,&quot;serif&quot;;"><br>
            <br>
          </span><tt><span style="font-size: 10pt;">Use the ACC module
              together with DIALOG module and set the cdr_flag option in
              ACC (see <a moz-do-not-send="true"
                href="http://www.opensips.org/html/docs/modules/1.9.x/acc.html#id294245">http://www.opensips.org/html/docs/modules/1.9.x/acc.html#id294245</a>)
              - you need to set this flag at at INVITE time only (plus
              one of the acc flags).</span></tt><span style="font-size:
            10pt; font-family: &quot;Courier New
            ;&quot;,&quot;serif&quot;;"><br>
            <br>
          </span><tt><span style="font-size: 10pt;">Regards,</span></tt><span
            style="font-size: 10pt; font-family: &quot;Courier New
            ;&quot;,&quot;serif&quot;;"><br>
            <br>
            <br>
            <br>
            <br>
          </span><o:p></o:p></p>
        <pre>Bogdan-Andrei Iancu<o:p></o:p></pre>
        <pre>OpenSIPS Founder and Developer<o:p></o:p></pre>
        <pre><a moz-do-not-send="true" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a><o:p></o:p></pre>
        <p class="MsoNormal"><br>
          On 04/03/2013 04:55 PM, M.Khaled W Chehab wrote: <o:p></o:p></p>
        <p class="MsoNormal">Dears ,<o:p></o:p></p>
        <p class="MsoNormal">&nbsp;<o:p></o:p></p>
        <p class="MsoNormal">Is there a way to right directly to CDRS
          table in mysql &nbsp;.<o:p></o:p></p>
        <p class="MsoNormal">&nbsp;<o:p></o:p></p>
        <p class="MsoNormal">Regards<o:p></o:p></p>
        <pre>&nbsp;<o:p></o:p></pre>
        <pre>&nbsp;<o:p></o:p></pre>
        <pre>_______________________________________________<o:p></o:p></pre>
        <pre>Users mailing list<o:p></o:p></pre>
        <pre><a moz-do-not-send="true" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><o:p></o:p></pre>
        <pre><a moz-do-not-send="true" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><o:p></o:p></pre>
      </div>
    </blockquote>
  </body>
</html>