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
