[OpenSIPS-Users] ACC Module - BYE's not working

[Liviu Chircu]

The new accounting system gives you a choice: a dialog-level approach, 
by enabling "cdr", which results in a single table row containing all 
relevant info for a CDR (start time, pick up time, end time, etc.) or a 
transaction-level approach which allows you to log each request that is 
relevant to your accounting.

By enabling the "cdr" flag, and calling do_accounting() for both INVITEs 
and BYEs, you seem to be doing both dialog and transaction accounting at 
the same time, and the module silently discards the BYE.

If you really need those BYEs in there, however, you can force them in 
with acc_db_request() instead. Mind you that they might get inserted 
before the INVITE rows, since the INVITE CDR is really only completed 
when the in-dialog BYE reply arrives.

The documentation might use some updates to more clearly reflect the 
above, so thanks for the report!

Regards,

Liviu Chircu
OpenSIPS Developer
http://www.opensips-solutions.com

On 15.08.2017 15:52, Jonathan Mabrito wrote:
> HI Liviu,
>
> I am not sure attachments work on this list system, so let me know if 
> it doesn't. In the meantime...assuming they do, I am attaching a 
> ~205KB  zip with the debug log. Just do a text search from the bottom 
> of the log for "BYE" and you will see my last attempt. It was a 
> inbound attempt from the PSTN to our PBX and I dialed +1 6504526830. I 
> verified the INVITE was in the ACC table in the MYSQL database, but 
> not the BYE.
>
> On Mon, Aug 14, 2017 at 12:28 PM Liviu Chircu <liviu at opensips.org 
> <mailto:liviu at opensips.org>> wrote:
>
>     Hi Jonathan,
>
>     Tried to reproduce it on 2.3.1 - no success. Can you also provide
>     the debug logs between the last two statements you posted?
>
>     Regards,
>
>     Liviu Chircu
>     OpenSIPS Developer
>     http://www.opensips-solutions.com
>
>     On 11.08.2017 15:43, Jonathan Mabrito wrote:
>>     I recently upgraded from OpenSIPS 2.2 to 2.3.1. Within the ACC
>>     module, I would get accounting information in the DB on the
>>     INVITES and the BYES on 2.2. After the upgrade to 2.3.1, I am
>>     getting the INVITES, but not the BYES. I made the adjustments per
>>     the migration guide for the extra_fields modparam that was
>>     introduced.
>>
>>     Here is the script clause I am using for BYE's:
>>     /                if(loose_route())/
>>     /{/
>>     /xlog("Transaction is a loose route \n");/
>>     /
>>     /
>>     /if(is_method("BYE")){/
>>     /#Accounting/
>>     /xlog("Processing BYE Message")/
>>     /if((!($ru =~ 'sip:05.*')) && (!($ru =~ '172.18.24.102.*')) &&
>>     (!($ru =~ 'sip.*@172.18.24.102:5060
>>     <mailto:sip.*@172.18.24.102:5060>')))/
>>     /{/
>>     /xlog("Processing BYE Accounting")/
>>     /$acc_extra(FROM) = $fu;/
>>     /$acc_extra(TO) = $tu;/
>>     /$acc_extra(RULE) = $avp(dr_rule_id);/
>>     /$acc_extra(DEST) = $avp(dr_gw_id);/
>>     /$acc_extra(REQURI) = $ru;/
>>     /do_accounting("db", "cdr|missed|failed", "acc");/
>>     /}/
>>     /}/
>>     /
>>     /
>>     /route(relay);/
>>     /}/
>>     /
>>     /
>>     In the syslog, I see these 4 statements back to back consecutively :
>>     /Aug 10 15:54:16 VOPS /usr/sbin/opensips[8980]: Transaction is a
>>     loose route/
>>     /Aug 10 15:54:16 VOPS /usr/sbin/opensips[8980]: Processing BYE
>>     Message/
>>     /Aug 10 15:54:16 VOPS /usr/sbin/opensips[8980]: Processing BYE
>>     Accounting/
>>     /Aug 10 15:54:16 VOPS /usr/sbin/opensips[8980]: route[relay]/
>>     /
>>     /
>>     So from what I can tell, when the BYE happens, it is making it
>>     into the proper section of the script. Any idea why the BYE isn't
>>     being accounted?
>>     /
>>     /
>>     /
>>     /
>>     -- 
>>     -Jonathan
>>
>>
>>     _______________________________________________
>>     Users mailing list
>>     Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>     _______________________________________________
>     Users mailing list
>     Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
> -- 
> -Jonathan
>
>
> _______________________________________________
> 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/20170816/b8a04b7b/attachment.html>