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
