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