[OpenSIPS-Users] CDRTool - MaxSessionTime and Debit balance cannot longer find the account info

[Dan-Cristian Bogos]

Adrian,

I have finally got the time to troubleshoot further my issue and found
the problem. I was using as my "cdr_source" for the RatingEngine a
"CDRS_cisco" like source, therefore I think this was the one messing up
some things when starting up the RatingEngine.

I don't expect you supporting cisco style cdrs for prepaid accounts, so
I will define the opensips datasource just for the sake of prepaid
accounts to work proper.

Again, thanks for the time looking on my issue.

Cheers,
DanB

On Tue, 2009-05-05 at 12:57 +0200, Adrian Georgescu wrote:
> Dan,
> 
> 
> I do not know what is wrong with your setup. I did the same and for me
> it works just fine:
> 
> 
> addbalance from=dan at mydomain.com value=10.00
> 1
> 
> 
> getbalance from=dan at mydomain.com
> 10.0000
> 
> 
> MaxSessionTime CallId=6432622xvv at 1 From=sip:dan at mydomain.com
> To=sip:00497751800123 at mydomain.com  Duration=7200 Gateway=10.0.0.1
> 7200
> 
> 
> 
> 
> May  5 12:54:34 ws1 cdrtool[17327]: MaxSessionTime CallId=6432622xvv at 1
> From=sip:dan at mydomain.com To=sip:00497751800123 at mydomain.com
> Duration=7200 Gateway=10.0.0.1
> May  5 12:54:34 ws1 cdrtool[17327]: MaxSessionTime=7200 Type=prepaid
> CallId=6432622xvv at 1 BillingParty=dan at mydomain.com DestId=49
> Balance=10.0000 Spans=1
> 
> 
> Regards,
> Adrian
> 
> 
> On May 1, 2009, at 3:51 PM, Dan-Cristian Bogos wrote:
> 
> > Guys,
> > 
> > I did a CDRTool upgrade to the latest 6.7.8 and it looks like there
> > is
> > something wrong with the account matching. Both MaxSessionTime and
> > DebitBalance are failing (in mysql it looks like the account is
> > queried
> > as empty string).
> > 
> > Let me know if the same scenario works for you.
> > 
> > Ta,
> > DanB
> > 
> > """ Log from CDRTool console:
> > 
> > version
> > CDRTool version 6.7.8
> > 
> > 
> > addbalance from=dan at mydomain.com value=10.00
> > 1
> > 
> > getbalance from=dan at mydomain.com
> > 20.0000
> > 
> > MaxSessionTime CallId=6432622xvv at 1 From=sip:dan at mydomain.com
> > To=sip:00497751800123 at mydomain.com  Duration=7200 Gateway=10.0.0.1
> > Lock=1
> > none
> > """
> > 
> > """ Log in syslog:
> > May  1 15:28:51 framdsrv01 cdrtool[5908]: addbalance
> > from=dan at mydomain.com value=10.00
> > May  1 15:28:51 framdsrv01 cdrtool[5908]: Prepaid account
> > dan at mydomain.com credited with 10.00
> > May  1 15:29:06 framdsrv01 cdrtool[5908]: getbalance
> > from=dan at mydomain.com
> > May  1 15:29:31 framdsrv01 cdrtool[5908]: MaxSessionTime
> > CallId=6432622xvv at 1 From=sip:dan at mydomain.com
> > To=sip:00497751800293 at mydomain.com Duration=7200 Gateway=10.0.0.1
> > Lock=1
> > May  1 15:29:31 framdsrv01 cdrtool[5908]: MaxSessionTime=unlimited
> > Type=postpaid CallId=6432622xvv at 1 BillingParty=
> > """
> > 
> > 
> > 
> > _______________________________________________
> > Users mailing list
> > Users at lists.opensips.org
> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> > 
> 
>