<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">A call once normalized is stored in the radiust table and remains unchanged unless you re-normalize the calls that you wish to have updated. So changing rating tables does not have any influence upon previously normalized calls, they remain with the previous values.<div><br></div><div>Adrian</div><div><br></div><div><br></div><div><div>On Mar 16, 2009, at 12:21 PM, Dan-Cristian Bogos wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div><br>Adrian,<br><br>On Mon, 2009-03-16 at 11:50 +0100, Adrian Georgescu wrote:<br><blockquote type="cite">This is a problem unrelated to the destinations reload. Most likely<br></blockquote><blockquote type="cite">you did not create the correct rating table data.<br></blockquote><br>I am not sure if it is due to correct rating table data (should see no<br>Span price in that case I think), so bear with me to read the logs.<br><br>Here comes a more detailed usage scenario:<br><br>I have added a new number inside destination table (like you said, no<br>rating defined, just the destination one). <br><br>* First query will identify maybe correctly the destination 31 (since<br>the reload of rating tables was not yet done and the new destination is<br>not yet in the memory).<br><br>ShowPrice <a href="mailto:from=dan@itsyscom.com">from=dan@itsyscom.com</a> gateway=10.10.10.1 Duration=59<br>To=0031676000008<br>0.1200<br>Duration: 60 s<br> App: audio<br> Destination: 31<br> Customer: default<br> Increment: 60 s<br> Connect: 0.0000<br> StartTime: 2009-03-16 10:08:45<br>--<br> Span: 1<br> Duration: 60 s<br> ProfileId: DEFAULT / weekday<br> RateId: DEFAULT / 0-24h<br> Rate: 0.1200 / 60 s<br> Price: 0.1200<br><br>reloadratingtables<br>1<br><br>* Second and third attempt are after reloadratingtables succeed - saw it<br>in mysql.log. Notice that the destination identified is still 31.<br><br>ShowPrice <a href="mailto:from=dan@itsyscom.com">from=dan@itsyscom.com</a> gateway=10.10.10.1 Duration=59<br>To=0031676000008<br>0.1200<br>Duration: 60 s<br> App: audio<br> Destination: 31<br> Customer: default<br> Increment: 60 s<br> Connect: 0.0000<br> StartTime: 2009-03-16 10:09:52<br>--<br> Span: 1<br> Duration: 60 s<br> ProfileId: DEFAULT / weekday<br> RateId: DEFAULT / 0-24h<br> Rate: 0.1200 / 60 s<br> Price: 0.1200<br><br>ShowPrice <a href="mailto:from=dan@itsyscom.com">from=dan@itsyscom.com</a> gateway=10.10.10.1 Duration=59<br>To=0031676000008<br>0.1200<br>Duration: 60 s<br> App: audio<br> Destination: 31<br> Customer: default<br> Increment: 60 s<br> Connect: 0.0000<br> StartTime: 2009-03-16 10:18:20<br>--<br> Span: 1<br> Duration: 60 s<br> ProfileId: DEFAULT / weekday<br> RateId: DEFAULT / 0-24h<br> Rate: 0.1200 / 60 s<br> Price: 0.1200<br><br>Connection closed by foreign host.<br><br>* Here I have restarted the cdrtool with /etc/init.d/cdrtool restart.<br>Now the destination is correctly identified as 31676000008 (full<br>length), of course without Span section since I have no rating defined<br>yet.<br><br>DellLaptop:/usr/local/src/cdrtool# telnet localhost 9094<br>Trying 127.0.0.1...<br>Connected to localhost.<br>Escape character is '^]'.<br>ShowPrice <a href="mailto:from=dan@itsyscom.com">from=dan@itsyscom.com</a> gateway=10.10.10.1 Duration=59<br>To=0031676000008<br>0<br>Duration: 60 s<br> App: audio<br> Destination: 31676000008<br> Customer: default<br> Increment: 60 s<br><br><br>Is my logic broken? <br>Same thing happens if I simply remove the destination (still showing it<br>in ShowPrice even if there is no longer in the database.<br><br>Ta,<br>DanB<br><br></div></blockquote></div><br></body></html>