<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"><<a href="mailto:sermj2012@gmail.com" target="_blank">sermj2012@gmail.com</a>></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'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 "acc.so"<br>modparam("acc", "failed_transaction_flag", "FAIL_TRANS_FLAG")<br>modparam("acc", "report_cancels", 1)<br>##modparam("acc", "report_ack", 0)<br>
modparam("acc", "early_media", 0)<br>modparam("acc", "log_level", 1)<br>modparam("acc", "log_flag", "LOG_FLAG")<br>modparam("acc", "log_missed_flag", "LOG_MISSED_FLAG")<br>
modparam("acc", "db_flag", "DB_FLAG")<br>modparam("acc", "cdr_flag", "CDR_FLAG")<br>modparam("acc", "db_missed_flag", "DB_MISSED_FLAG")<br>
modparam("acc", "db_url", "mysql://opensips:opensipsrw@opensips/opensips")<br>modparam("acc", "db_table_acc", "acc")<br>modparam("acc", "acc_method_column", "method")<br>
modparam("acc", "acc_from_tag_column", "from_tag")<br>modparam("acc", "acc_to_tag_column", "to_tag")<br>modparam("acc", "acc_callid_column", "callid")<br>
modparam("acc", "acc_sip_code_column", "sip_code")<br>modparam("acc", "acc_sip_reason_column", "sip_reason")<br>modparam("acc", "acc_time_column", "time")<br>
modparam("acc", "db_extra", "src_uri=$fU;caller_domain=$fd;dst_uri=$rU;callee_domain=$rd;legtype=$avp(s:LEG)")<br><br></div>And this is my script <br><br># main request routing logic<br><br>
route{<br>
if (!mf_process_maxfwd_header("10")) {<br> sl_send_reply("483","Too Many Hops");<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("BYE")) {<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("INVITE")) {<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("ACK") ) {<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 -><br> # ignore and discard<br> exit;<br>
}<br> }<br> sl_send_reply("404","Not here");<br> }<br> exit;<br> }<br><br> # CANCEL processing<br> if (is_method("CANCEL"))<br> {<br>
if (t_check_trans())<br> t_relay();<br> exit;<br> }<br><br> t_check_trans();<br><br> if ( !(is_method("REGISTER") ) ) {<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("403","Rely forbidden");<br> exit;<br> }<br>
}<br> }<br><br> # preloaded route checking<br> if (loose_route()) {<br> xlog("L_ERR",<br> "Attempt to route with preloaded Route's [$fu/$tu/$ru/$ci]");<br> if (!is_method("ACK"))<br>
sl_send_reply("403","Preload Route denied");<br> exit;<br> }<br><br> # record routing<br> if (!is_method("REGISTER|MESSAGE"))<br> record_route();<br><br> # account only INVITEs<br>
if (is_method("INVITE")) {<br> setflag(DB_FLAG); # do accounting<br> }<br><br> <br> if (!uri==myself) {<br> append_hf("P-hint: outbound\r\n"); <br> route(relay);<br> }<br>
<br> # requests for my domain<br> if (is_method("PUBLISH|SUBSCRIBE"))<br> {<br> sl_send_reply("503", "Service Unavailable");<br> exit;<br> }<br><br> if (is_method("REGISTER"))<br>
{<br> if ( 0 ) setflag(TCP_PERSISTENT);<br><br> if (!save("location"))<br> sl_reply_error();<br><br> exit;<br> }<br><br> if ($rU==NULL) {<br> # request with no Username in RURI<br>
sl_send_reply("484","Address Incomplete");<br> exit;<br> }<br><br> # do lookup with method filtering<br> if (!lookup("location","m")) {<br> t_newtran();<br>
t_reply("404", "Not Found");<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("INVITE")) {<br> t_on_branch("per_branch_ops");<br> t_on_reply("handle_nat");<br> t_on_failure("missed_call");<br>
}<br><br> if (!t_relay()) {<br> send_reply("500","Internal Error");<br> };<br> exit;<br>}<br><br><br>branch_route[per_branch_ops] {<br> xlog("new branch at $ru\n");<br>
}<br><br><br>onreply_route[handle_nat] {<br> <br> xlog("incoming reply\n");<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("3[0-9][0-9]")) {<br> ##t_reply("404","Not found");<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>