Hi Mike, I have checked and it is working fine with my system and i got the call details in both acc and cdrs tables. thanks a lot.
But i have a small doubt regarding the voice call in opensips. Even i installed media proxy and rtp proxy with opensips, when i am trying to call clients from one among other. i am getting *"wating for ack"*, appearing on the callee side of sip client display and i am unable to listen voice from callee side to caller while i can listen voice from caller to callee. Isthere any configuration changes need to done with i the configuration file. Please let me know. Regards sermj On Tue, Aug 6, 2013 at 6:34 PM, Mike Tesliuk <[email protected]>wrote: > the opensips-cp come with a sql procedure called opensips_cdrs_1_6() (or > something like) did you check if you have this created ? > > > 2013/8/6 Nandini madhu <[email protected]> > >> Hi all, >> >> I am using opensips-1.9.1-tls vaersion. And opensips-cp-5.0. >> >> I am able to see some changes in acc table after made calling between >> clients. >> >> But i did't see any changes in cdrs table. >> >> I loaded dialog module and enabled cdr_flag in acc. >> >> Please help me to solve this issue. >> >> Here is my accounting module parameters: >> #### ACCounting module >> loadmodule "acc.so" >> modparam("acc", "failed_transaction_flag", "FAIL_TRANS_FLAG") >> modparam("acc", "report_cancels", 1) >> ##modparam("acc", "report_ack", 0) >> modparam("acc", "early_media", 0) >> modparam("acc", "log_level", 1) >> modparam("acc", "log_flag", "LOG_FLAG") >> modparam("acc", "log_missed_flag", "LOG_MISSED_FLAG") >> modparam("acc", "db_flag", "DB_FLAG") >> modparam("acc", "cdr_flag", "CDR_FLAG") >> modparam("acc", "db_missed_flag", "DB_MISSED_FLAG") >> modparam("acc", "db_url", "mysql://opensips:opensipsrw@opensips >> /opensips") >> modparam("acc", "db_table_acc", "acc") >> modparam("acc", "acc_method_column", "method") >> modparam("acc", "acc_from_tag_column", "from_tag") >> modparam("acc", "acc_to_tag_column", "to_tag") >> modparam("acc", "acc_callid_column", "callid") >> modparam("acc", "acc_sip_code_column", "sip_code") >> modparam("acc", "acc_sip_reason_column", "sip_reason") >> modparam("acc", "acc_time_column", "time") >> modparam("acc", "db_extra", >> "src_uri=$fU;caller_domain=$fd;dst_uri=$rU;callee_domain=$rd;legtype=$avp(s:LEG)") >> >> And this is my script >> >> # main request routing logic >> >> route{ >> if (!mf_process_maxfwd_header("10")) { >> sl_send_reply("483","Too Many Hops"); >> exit; >> } >> >> if (has_totag()) { >> # sequential requests within a dialog should >> # take the path determined by record-routing >> if (loose_route()) { >> if (is_method("BYE")) { >> create_dialog(); >> setflag(TRACE_FLAG); >> setflag(DB_FLAG); # do accounting ... >> setflag(CDR_FLAG); # ... even if the transaction fails >> } else if (is_method("INVITE")) { >> # even if in most of the cases is useless, do RR for >> # re-INVITEs alos, as some buggy clients do change route >> set >> # during the dialog. >> record_route(); >> } >> >> # route it out to whatever destination was set by >> loose_route() >> # in $du (destination URI). >> route(relay); >> } else { >> if ( is_method("ACK") ) { >> if ( t_check_trans() ) { >> # non loose-route, but stateful ACK; must be an ACK >> after >> # a 487 or e.g. 404 from upstream server >> t_relay(); >> exit; >> } else { >> # ACK without matching transaction -> >> # ignore and discard >> exit; >> } >> } >> sl_send_reply("404","Not here"); >> } >> exit; >> } >> >> # CANCEL processing >> if (is_method("CANCEL")) >> { >> if (t_check_trans()) >> t_relay(); >> exit; >> } >> >> t_check_trans(); >> >> if ( !(is_method("REGISTER") ) ) { >> if (from_uri==myself) >> { >> } else { >> # if caller is not local, then called number must be local >> if (!uri==myself) { >> send_reply("403","Rely forbidden"); >> exit; >> } >> } >> } >> >> # preloaded route checking >> if (loose_route()) { >> xlog("L_ERR", >> "Attempt to route with preloaded Route's [$fu/$tu/$ru/$ci]"); >> if (!is_method("ACK")) >> sl_send_reply("403","Preload Route denied"); >> exit; >> } >> >> # record routing >> if (!is_method("REGISTER|MESSAGE")) >> record_route(); >> >> # account only INVITEs >> if (is_method("INVITE")) { >> setflag(DB_FLAG); # do accounting >> } >> >> >> if (!uri==myself) { >> append_hf("P-hint: outbound\r\n"); >> route(relay); >> } >> >> # requests for my domain >> if (is_method("PUBLISH|SUBSCRIBE")) >> { >> sl_send_reply("503", "Service Unavailable"); >> exit; >> } >> >> if (is_method("REGISTER")) >> { >> if ( 0 ) setflag(TCP_PERSISTENT); >> >> if (!save("location")) >> sl_reply_error(); >> >> exit; >> } >> >> if ($rU==NULL) { >> # request with no Username in RURI >> sl_send_reply("484","Address Incomplete"); >> exit; >> } >> >> # do lookup with method filtering >> if (!lookup("location","m")) { >> t_newtran(); >> t_reply("404", "Not Found"); >> exit; >> } >> >> # when routing via usrloc, log the missed calls also >> setflag(ACC_MISSED); >> route(relay); >> } >> >> >> route[relay] { >> # for INVITEs enable some additional helper routes >> if (is_method("INVITE")) { >> t_on_branch("per_branch_ops"); >> t_on_reply("handle_nat"); >> t_on_failure("missed_call"); >> } >> >> if (!t_relay()) { >> send_reply("500","Internal Error"); >> }; >> exit; >> } >> >> >> branch_route[per_branch_ops] { >> xlog("new branch at $ru\n"); >> } >> >> >> onreply_route[handle_nat] { >> >> xlog("incoming reply\n"); >> } >> >> >> failure_route[missed_call] { >> if (t_was_cancelled()) { >> exit; >> } >> >> # uncomment the following lines if you want to block client >> # redirect based on 3xx replies. >> ##if (t_check_status("3[0-9][0-9]")) { >> ##t_reply("404","Not found"); >> ## exit; >> ##} >> >> } >> >> Kindly help me >> >> Thanks in advance >> >> Regards >> >> sermj >> >> _______________________________________________ >> Users mailing list >> [email protected] >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
