<div dir="ltr">the opensips-cp come with a sql procedure called opensips_cdrs_1_6() (or something like) did you check if you have this created ?<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/8/6 Nandini madhu <span dir="ltr">&lt;<a href="mailto:sermj2012@gmail.com" target="_blank">sermj2012@gmail.com</a>&gt;</span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div><div><div><div><div><div><div><div><div>Hi all,<br><br></div>I am using opensips-1.9.1-tls vaersion. And opensips-cp-5.0.<br>
<br></div>I am able to see some changes in acc table after made calling between clients.<br>
<br></div>But i did&#39;t see any changes in cdrs table.<br><br></div>I loaded dialog module and enabled cdr_flag in acc.<br><br></div>Please help me to solve this issue.<br><br></div>Here is my accounting module parameters:<br>

#### ACCounting module<br>loadmodule &quot;acc.so&quot;<br>modparam(&quot;acc&quot;, &quot;failed_transaction_flag&quot;, &quot;FAIL_TRANS_FLAG&quot;)<br>modparam(&quot;acc&quot;, &quot;report_cancels&quot;, 1)<br>##modparam(&quot;acc&quot;, &quot;report_ack&quot;, 0)<br>

modparam(&quot;acc&quot;, &quot;early_media&quot;, 0)<br>modparam(&quot;acc&quot;, &quot;log_level&quot;, 1)<br>modparam(&quot;acc&quot;, &quot;log_flag&quot;, &quot;LOG_FLAG&quot;)<br>modparam(&quot;acc&quot;, &quot;log_missed_flag&quot;, &quot;LOG_MISSED_FLAG&quot;)<br>

modparam(&quot;acc&quot;, &quot;db_flag&quot;, &quot;DB_FLAG&quot;)<br>modparam(&quot;acc&quot;, &quot;cdr_flag&quot;, &quot;CDR_FLAG&quot;)<br>modparam(&quot;acc&quot;, &quot;db_missed_flag&quot;, &quot;DB_MISSED_FLAG&quot;)<br>

modparam(&quot;acc&quot;, &quot;db_url&quot;, &quot;mysql://opensips:opensipsrw@opensips/opensips&quot;)<br>modparam(&quot;acc&quot;, &quot;db_table_acc&quot;, &quot;acc&quot;)<br>modparam(&quot;acc&quot;, &quot;acc_method_column&quot;, &quot;method&quot;)<br>

modparam(&quot;acc&quot;, &quot;acc_from_tag_column&quot;, &quot;from_tag&quot;)<br>modparam(&quot;acc&quot;, &quot;acc_to_tag_column&quot;, &quot;to_tag&quot;)<br>modparam(&quot;acc&quot;, &quot;acc_callid_column&quot;, &quot;callid&quot;)<br>

modparam(&quot;acc&quot;, &quot;acc_sip_code_column&quot;, &quot;sip_code&quot;)<br>modparam(&quot;acc&quot;, &quot;acc_sip_reason_column&quot;, &quot;sip_reason&quot;)<br>modparam(&quot;acc&quot;, &quot;acc_time_column&quot;, &quot;time&quot;)<br>

modparam(&quot;acc&quot;, &quot;db_extra&quot;, &quot;src_uri=$fU;caller_domain=$fd;dst_uri=$rU;callee_domain=$rd;legtype=$avp(s:LEG)&quot;)<br><br></div>And this is my script <br><br># main request routing logic<br><br>
route{<br>
    if (!mf_process_maxfwd_header(&quot;10&quot;)) {<br>        sl_send_reply(&quot;483&quot;,&quot;Too Many Hops&quot;);<br>        exit;<br>    }<br><br>    if (has_totag()) {<br>        # sequential requests within a dialog should<br>

        # take the path determined by record-routing<br>        if (loose_route()) {<br>            if (is_method(&quot;BYE&quot;)) {<br>                create_dialog();<br>                setflag(TRACE_FLAG);<br>                setflag(DB_FLAG); # do accounting ...<br>

                setflag(CDR_FLAG); # ... even if the transaction fails<br>            } else if (is_method(&quot;INVITE&quot;)) {<br>                # even if in most of the cases is useless, do RR for<br>                # re-INVITEs alos, as some buggy clients do change route set<br>

                # during the dialog.<br>                record_route();<br>            }<br><br>            # route it out to whatever destination was set by loose_route()<br>            # in $du (destination URI).<br>            route(relay);<br>

        } else {<br>            if ( is_method(&quot;ACK&quot;) ) {<br>                if ( t_check_trans() ) {<br>                    # non loose-route, but stateful ACK; must be an ACK after <br>                    # a 487 or e.g. 404 from upstream server<br>

                    t_relay();<br>                    exit;<br>                } else {<br>                    # ACK without matching transaction -&gt;<br>                    # ignore and discard<br>                    exit;<br>

                }<br>            }<br>            sl_send_reply(&quot;404&quot;,&quot;Not here&quot;);<br>        }<br>        exit;<br>    }<br><br>    # CANCEL processing<br>    if (is_method(&quot;CANCEL&quot;))<br>    {<br>

        if (t_check_trans())<br>            t_relay();<br>        exit;<br>    }<br><br>    t_check_trans();<br><br>    if ( !(is_method(&quot;REGISTER&quot;)  ) ) {<br>        if (from_uri==myself)<br>        {<br>        } else {<br>

            # if caller is not local, then called number must be local<br>            if (!uri==myself) {<br>                send_reply(&quot;403&quot;,&quot;Rely forbidden&quot;);<br>                exit;<br>            }<br>

        }<br>    }<br><br>    # preloaded route checking<br>    if (loose_route()) {<br>        xlog(&quot;L_ERR&quot;,<br>        &quot;Attempt to route with preloaded Route&#39;s [$fu/$tu/$ru/$ci]&quot;);<br>        if (!is_method(&quot;ACK&quot;))<br>

            sl_send_reply(&quot;403&quot;,&quot;Preload Route denied&quot;);<br>        exit;<br>    }<br><br>    # record routing<br>    if (!is_method(&quot;REGISTER|MESSAGE&quot;))<br>        record_route();<br><br>    # account only INVITEs<br>

    if (is_method(&quot;INVITE&quot;)) {<br>        setflag(DB_FLAG); # do accounting<br>    }<br><br>    <br>    if (!uri==myself) {<br>        append_hf(&quot;P-hint: outbound\r\n&quot;); <br>        route(relay);<br>    }<br>

<br>    # requests for my domain<br>    if (is_method(&quot;PUBLISH|SUBSCRIBE&quot;))<br>    {<br>        sl_send_reply(&quot;503&quot;, &quot;Service Unavailable&quot;);<br>        exit;<br>    }<br><br>    if (is_method(&quot;REGISTER&quot;))<br>

    {<br>        if (   0 ) setflag(TCP_PERSISTENT);<br><br>        if (!save(&quot;location&quot;))<br>            sl_reply_error();<br><br>        exit;<br>    }<br><br>    if ($rU==NULL) {<br>        # request with no Username in RURI<br>

        sl_send_reply(&quot;484&quot;,&quot;Address Incomplete&quot;);<br>        exit;<br>    }<br><br>    # do lookup with method filtering<br>    if (!lookup(&quot;location&quot;,&quot;m&quot;)) {<br>        t_newtran();<br>

        t_reply(&quot;404&quot;, &quot;Not Found&quot;);<br>        exit;<br>    } <br><br>    # when routing via usrloc, log the missed calls also<br>    setflag(ACC_MISSED);<br>    route(relay);<br>}<br><br><br>route[relay] {<br>

    # for INVITEs enable some additional helper routes<br>    if (is_method(&quot;INVITE&quot;)) {<br>        t_on_branch(&quot;per_branch_ops&quot;);<br>        t_on_reply(&quot;handle_nat&quot;);<br>        t_on_failure(&quot;missed_call&quot;);<br>

    }<br><br>    if (!t_relay()) {<br>        send_reply(&quot;500&quot;,&quot;Internal Error&quot;);<br>    };<br>    exit;<br>}<br><br><br>branch_route[per_branch_ops] {<br>    xlog(&quot;new branch at $ru\n&quot;);<br>

}<br><br><br>onreply_route[handle_nat] {<br>    <br>    xlog(&quot;incoming reply\n&quot;);<br>}<br><br><br>failure_route[missed_call] {<br>    if (t_was_cancelled()) {<br>        exit;<br>    }<br><br>    # uncomment the following lines if you want to block client <br>

    # redirect based on 3xx replies.<br>    ##if (t_check_status(&quot;3[0-9][0-9]&quot;)) {<br>    ##t_reply(&quot;404&quot;,&quot;Not found&quot;);<br>    ##    exit;<br>    ##}<br><br>}<br><br></div>Kindly help me<br>
<br>
</div>Thanks in advance<br><br></div>Regards<br><br></div>sermj<br></div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>