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 >> [email protected] of [email protected] to >> destination 2783 having balance=15060.9566 is 3190 >> May 5 09:29:43 billing cdrtool[17219]: Session >> [email protected] for [email protected] >> has expired since 121 seconds May 5 09:40:45 billing cdrtool[17219]: >> DebitBalance Duration=1075.50027394 >> [email protected] >> From=sip:[email protected] Gateway=1.2.3.4 To=sip:[email protected] >> May 5 09:40:45 billing cdrtool[17219]: ConnectFee=0.0000 >> [email protected] Span=1 Duration=1075 >> DestId=2783 [email protected] >> 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 >> [email protected] of [email protected] >> does not exist >> May 5 09:45:02 billing cdrtool[20233]: ConnectFee=0.0000 >> [email protected] Span=1 Duration=1075 >> DestId=2783 [email protected] >> 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 >> [email protected] >> From=sip:[email protected] Gate >> way=1.2.3.4 To=sip:[email protected] >> May 5 09:40:46 sbc1 call-control[4358]: Could not debit balance for >> call id [email protected] of >> [email protected] to sip:[email protected] >> 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 '[email protected]' 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 >>>> [email protected] >>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>>> >>>> >>>> >>> _______________________________________________ >>> Users mailing list >>> [email protected] >>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>> >>> >> _______________________________________________ >> Users mailing list >> [email protected] >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
