[OpenSIPS-Users] CDRTool Prepaid and Radius don't match

[Douglas Lane]

Hi Adrian,

Below is a log from our billing server - the server that runs cdrtool, 
freeradius and mysql:
May  5 09:29:40 billing cdrtool[17219]: Maximum duration for session 
4885f4b54051459e714848e243ecd742 at domain.com of telefusion at domain.com to 
destination 2783 having balance=15060.9566 is 3190
May  5 09:29:43 billing cdrtool[17219]: Session 
4885f4b54051459e714848e243ecd742 at domain.com for telefusion at domain.com 
has expired since 121 seconds May  5 09:40:45 billing cdrtool[17219]: 
DebitBalance Duration=1075.50027394 
CallId=4885f4b54051459e714848e243ecd742 at domain.com 
From=sip:telefusion at domain.com Gateway=1.2.3.4 To=sip:0837256524 at domain.com
May  5 09:40:45 billing cdrtool[17219]: ConnectFee=0.0000 
CallId=4885f4b54051459e714848e243ecd742 at domain.com Span=1 Duration=1075 
DestId=2783 subscriber=telefusion at domain.com 
Profile=telefusion_spl_wkday Period=weekday Rate=telefusion_spl_peak 
Interval=7-19 Cost=1.0500/60 Price=18.8125 PriceIn=17.9167
May  5 09:40:45 billing cdrtool[17219]: Error: session 
4885f4b54051459e714848e243ecd742 at domain.com of telefusion at domain.com 
does not exist
May  5 09:45:02 billing cdrtool[20233]: ConnectFee=0.0000 
CallId=4885f4b54051459e714848e243ecd742 at domain.com Span=1 Duration=1075 
DestId=2783 subscriber=telefusion at domain.com 
Profile=telefusion_spl_wkday Period=weekday Rate=telefusion_spl_peak 
Interval=7-19 Cost=1.0500/60 Price=18.8125 PriceIn=17.9167


And below is the log extract from OpenSIPS:
May  5 09:40:46 sbc1 call-control[4358]: warning: Rating engine failed 
query: DebitBalance Duration=1075.50027394 
CallId=4885f4b54051459e714848e243ecd742 at domain.com 
From=sip:telefusion at domain.com Gate
way=1.2.3.4 To=sip:0837256524 at domain.com
May  5 09:40:46 sbc1 call-control[4358]: Could not debit balance for 
call id 4885f4b54051459e714848e243ecd742 at domain.com of 
telefusion at domain.com to sip:0837256524 at domain.com
May  5 09:40:46 sbc1 /opt/opensips/sbin/opensips[27232]: 
DBG:dialog:destroy_dlg: dlg expired or not in list - dlg 0x7f529edae8c8 
[2773:299621302] with clid '4885f4b54051459e714848e243ecd742 at domain.com' an
d tags 'as4b9756d1' 'as2e1a01fc'

Now my concern is why this is happening. About 80% of all calls on this 
account are fine, its just these odd calls that don't get billed 
correctly by the prepaid service.

Any ideas on this?

Thanks
Doug


On 2010/04/26 9:19 PM, Adrian Georgescu wrote:
> Prepaid history is updated when DebitBalance is called by Call control
> module from OpenSIPS.
>
> If this function is called when the call ends (for which you must
> properly configure OpenSIPS and MediaProxy ) than you do not lose
> money but rather your simply have duplicated radius records likely
> caused by multiple messages being retransmitted or wrong configuration
> of the accounting part.
>
> You can check the syslog on OpenSIPS and CallControl for the calls in
> question (namely when they start and when they stop) and match them
> against the syslog entries for MaxSessionTime and DebitBalance in
> CDRTool rating engine. The Call Id is the key that can be matched in
> all logs.
>
> Than you have a better picture of what happens, if you loose or not
> any records in prepaid table.
>
> Adrian
>
> On Apr 26, 2010, at 9:09 PM, Douglas Lane wrote:
>
>    
>> Hey Guys,
>>
>> Sorry for all the dumb questions lately, been trying to work out whats
>> going wrong.
>>
>> I make use of the prepaid_history table in CDRTool to calculate the
>> daily usage for clients, and then email them a summary as well as
>> their
>> remaining balance. What I've recently noticed when doing an LEFT JOIN
>> between Radius and prepaid_history, is that radius has a load more
>> callid entries that prepaid_history does for the same user (and yes I
>> did a filter on SipMethod = 200) This concerns me as technically,
>> cdrtool is not updating the prepaid_history database correctly, and
>> therefore is actually loosing money.
>>      
>    
>> Anyone else having the same issues, or perhaps can point me in the
>> direction I need to troubleshoot at. I've check the logs and there is
>> nothing for mysql errors. Every call I've checked has a debit balance
>> request, but my concern is that some of them are not updating the
>> table.
>>
>> Thanks
>> Doug
>>
>>
>> _______________________________________________
>> 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
>