[OpenSIPS-Users] db_extra_bye - after BYE values in CDR in 2.4
Pat Burke
pat at voxtelesys.com
Thu May 17 14:47:24 EDT 2018
Răzvan,
That is what I assumed when I updated the code, but I am not getting the values from after the BYE inserted. What am I doing wrong? Thanks for your help.
*****************************************
Here are the acc configuration values
#### Accounting module
loadmodule "acc.so"
modparam("acc","db_url","virtual://set1")
modparam("acc", "extra_fields", "db: setuptime_msec;end_setup_time;host_name;server_id;server_type;formatted_caller_number;formatted_callee_number;trunk_group;tech_prefix;dial_number;accountcode;prefered_codecs;callee_iso3;callee_iso2;callee_nanp;callee_dialcode;callee_routecode;caller_iso3;caller_iso2;caller_nanp;caller_dialcode;route_profile;caller_state;callee_state;callee_number_type;lrn;routeto_number;customer_rate;customer_rate_type;inter_intra;allowed_iso3s;max_carrier_rate;routing_history;current_carrier;current_carrier_price;current_carrier_idx;out_carrier;out_carrier_price;error_reason;host_ip;inbound_ip;outbound_ip;max_routes;vts_setup_ms;to180_msec;call_routed;carrier_choice;configuration_details;general_details;call_details;optional_details;additional_details;inbound_details;call_start_seconds;call_start_useconds;call_end_seconds;call_end_useconds;bye_src_ip;bye_time")
modparam("acc", "detect_direction", 1)
modparam("acc", "report_cancels", 1)
*****************************************
Here is the start of the script where the BYE is captured, you can see I am logging the acc_extra values just to make certain they are set.
route {
if (!mf_process_maxfwd_header("10")) {
sl_send_reply("483","Too Many Hops");
exit;
}
#xlog("L_INFO", "$ru ----- $rm\n");
if (has_totag()) {
if (is_method("BYE")) {
if ($avp(call_end_seconds) == NULL) {
xlog("L_WARN", "phb 1\n");
$acc_extra(bye_src_ip) = $si;
$acc_extra(bye_time) = $Ts;
get_timestamp($avp(call_end_seconds),$avp(call_end_useconds));
$acc_extra(call_end_seconds) = $avp(call_end_seconds);
$acc_extra(call_end_useconds) = $avp(call_end_useconds);
xlog("L_WARN", "phb 2 $acc_extra(bye_src_ip) = $si; $acc_extra(bye_time) = $Ts; $acc_extra(call_end_seconds) = $avp(call_end_seconds); $acc_extra(call_end_useconds) = $avp(call_end_useconds);\n");
} else {
xlog("L_INFO", "$rU SCRIPT:BILLING:DEBUG: Extra BYE received.\n");
}
}
*****************************************
Here is the output from the phone call. The values are set.
[2921]: phb 1
[2921]: phb 2 192.168.20.250 = 192.168.20.250; 1526580586 = 1526580586; 1526580586 = 1526580586; 232433 = 232433;
*****************************************
Here is the db insert that was actually sent to the database. The values that I set are ''.
insert into acc (method,from_tag,to_tag,callid,sip_code,sip_reason,time,setuptime_msec,end_setup_time,host_name,server_id,server_type,
formatted_caller_number,formatted_callee_number,trunk_group,tech_prefix,dial_number,accountcode,prefered_codecs,
callee_iso3,callee_iso2,callee_nanp,callee_dialcode,callee_routecode,caller_iso3,caller_iso2,caller_nanp,caller_dialcode,
route_profile,caller_state,callee_state,callee_number_type,lrn,routeto_number,customer_rate,customer_rate_type,inter_intra,
allowed_iso3s,max_carrier_rate,routing_history,current_carrier,current_carrier_price,current_carrier_idx,
out_carrier,out_carrier_price,
error_reason,host_ip,inbound_ip,outbound_ip,max_routes,vts_setup_ms,to180_msec,call_routed,carrier_choice,
configuration_details,
general_details,
call_details,
optional_details,
additional_details,
inbound_details,
call_start_seconds,call_start_useconds,
COLUMNS HERE -> call_end_seconds,call_end_useconds,bye_src_ip,bye_time,setuptime,created,duration,ms_duration )
values ('INVITE','e61fa171a5','2082486450','V30_d0RXCDUtMWYrRVFWYn1mZA--','200','OK','2018-05-17 15:39:25','2079','1526571565','wahoo-OpenSipsCore02','29','1',
'14024035128','14024035121','90761','none','14024035121','190761','PCMU|PCMA|telephone-event',
'USA','US','1','1402','4022060','USA','US','1','1402',
'30','NE','NE','Landline','4022060239','4022060','11000','FLAT','1',
'','0','[ { \"idx\": 2, \"cc\": \"1105\", \"cp\": 1000, \"st\": 1526571563, \"ct\": 1526571565, \"rs\": \"\", \"rr\": \"\" } ]','1105','1000','2',
'1111, 1105, 1067, 1088, 1060, 1076, 1062, 1051','726, 1000, 1020, 1800, 2400, 2500, 7000, 14400',
'1111 Diff Removed.','192.168.20.251','192.168.20.113','192.168.20.250','4','6','58','','1',
'{ \"max_cc\": \"15\", \"max_cps\": \"4\", \"ingress_server_id\": \"30\", \"core_server_group\": \"10002\", \"caller_format_profile\": 60000, \"callee_format_profile\": 50000, \"cnam_enabled\": 0, \"route_profile\": 30, \"auth_profile\": 5, \"dtmfmode\": \"2833\", \"t38\": 0, \"privacy\": 0, \"rtpproxy_group\": 1, \"landline_only\": 0, \"is_mark_up_rate\": 0, \"nanp_rate_id\": 5, \"international_rate_id\": 2, \"limit_calls_to_profit\": 0, \"mark_up_margin\": 0, \"min_profit_margin\": 0, \"max_mark_up\": 150000, \"immediate_media\": 0, \"tz\": \"US\\/Eastern\", \"dnc_mode\": \"NONE\", \"dnc_route\": \"ALWAYS\" }',
'{ }',
'{ \"inbound_media\": \"c=IN IP4 192.168.20.113\", \"proxy_media\": 1, \"default_caller_id\": \"14024034435\", \"default_caller_name\": \"UNKNOWN\", \"callername\": \"\", \"callernameset\": 0, \"dr_grp\": 1, \"dr_part\": \"INTRA\", \"cust_dr_grp\": 4, \"cust_dr_part\": \"CUST_INTRA\", \"callee_routecode\": \"4022060\", \"route_to_number\": \"4022060239\", \"callee_number_type\": \"Landline\", \"ringtype\": 180 }',
'{ }',
'{ \"flat_rates\": \"CAN,11000,11000!CNT,200000,200000!PRI,15000,15000!TFN,5000,5000!UAK,40000,40000!UHI,19000,19000!USA,11000,11000!VIR,25000,25000\", \"supplemental_rates\": \"none\" }',
'{ }',
'1526571565','940740',
VALUES HERE -> '','','','',2,'2018-05-17 15:39:23',4,3910)
The values for call_end_seconds,call_end_useconds,bye_src_ip,bye_time are all ''.
Regards,
Pat Burke
______________________________________________________________________________________
Direct: (402) 403-5121 | Cell: (402) 443-8929 | Email: pat at voxtelesys.com
1801 23rd Avenue North | Suite 217 | Fargo, North Dakota 58102
-----Original Message-----
> From: "Răzvan Crainea" <razvan at opensips.org>
> To: users at lists.opensips.org
> Date: 05/17/18 04:13
> Subject: Re: [OpenSIPS-Users] db_extra_bye - after BYE values in CDR in 2.4
>
> Hi, Pat!
>
> In the new 2.4, the process of setting extras became even simpler. All
> you have to do is to set the $acc_extra() value when the BYE is receved.
> Let me know if you have further questions.
>
> Best regards,
> Răzvan
>
> On 05/16/2018 11:38 PM, Pat Burke wrote:
> > Hello,
> >
> >
> > I am trying to store data in the CDR from both before the BYE and after
> > the BYE.
> >
> >
> > In OpenSIPS 2.2.x we did the following -
> >
> >
> > modparam("acc",
> > "db_extra","setuptime_msec=$avp(setuptime_msec);end_setup_time=$Ts;host_name=$avp(host_name)
> > ....
> >
> > modparam("acc", "db_extra_bye",
> > "call_end_seconds=$avp(call_end_seconds);call_end_useconds=$avp(call_end_useconds);bye_src_ip=$avp(bye_src_ip);bye_time=$avp(bye_time)")
> >
> >
> > All of the values were sent to the database.
> >
> >
> >
> >
> > In OpenSIPS 2.4.x we are doing the following -
> >
> > modparam("acc", "extra_fields", "db:
> > setuptime_msec;end_setup_time;host_name; ...
> > ;call_end_seconds;call_end_useconds;bye_src_ip;bye_time")
> >
> > I am setting the $acc_extra(call_end_seconds) values after the BYE, but
> > nothing is being sent to the database.
> >
> >
> > How do we handle the after BYE values into the CDR for 2.4?
> >
> >
> > Thanks in advance.
> >
> >
> > Regards,
> > *Pat Burke*
> >
> > Voxtelesys | solutions to grow your business
> > ______________________________________________________________________________________
> > Direct: (402) 403-5121 | Cell: (402) 443-8929 | Email:
> > pat at voxtelesys.com <mailto:pat at voxtelesys.com>
> > 1801 23rd Avenue North | Suite 217 | Fargo, North Dakota 58102
> >
> >
> > _______________________________________________
> > Users mailing list
> > Users at lists.opensips.org
> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >
>
> --
> Răzvan Crainea
> OpenSIPS Core Developer
> http://www.opensips-solutions.com
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
More information about the Users
mailing list