[OpenSIPS-Users] Regarding cdrs table in opensips
Nandini madhu
sermj2012 at gmail.com
Sat Aug 17 13:00:50 CEST 2013
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 <mike.tesliuk at ultra.net.br>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 <sermj2012 at gmail.com>
>
>> 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
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130817/01719726/attachment.htm>
More information about the Users
mailing list