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

Fri May 7 09:02:09 CEST 2010

Can you send me the entire syslog entries for those calls from opensips and cdrtool machine logs to my email address ag at ag-projects.com

Adrian

On May 6, 2010, at 8:40 PM, Douglas Lane wrote:

> Hi Adrian,
> 
> Any further suggestions on this? I just don't know where to look, as I 
> can't see any errors being generated other than the dialog expiring and 
> cdrtool failing to execute the debitbalance call.
> 
> What else shall I provide you to diagnose further? Or where else can I 
> look to understand whats failing?
> 
> Thanks
> Doug
> 
> 
> On 2010/05/05 6:11 PM, Adrian Georgescu wrote:
>> Are you also using MediaProxy to close the calls that have RTP timeout?
>> 
>> Adrian
>> 
>> On May 5, 2010, at 6:05 PM, Douglas Lane wrote:
>> 
>> 
>>> 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
>>>> 
>>>> 
>>> _______________________________________________
>>> 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
>> 
> 
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> 