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