[OpenSIPS-Users] CDRTool - ReloadRatingTables and new destinations
Dan-Cristian Bogos
danb at sms4sip.com
Mon Mar 16 13:44:21 CET 2009
I understand that, but I did not normalize anything in my actions. I
just played with the ShowPrice over telnet (adding and deleting
destinations directly from the database, and then running ReloadTables
over telnet interface).
DanB
On Mon, 2009-03-16 at 13:39 +0100, Adrian Georgescu wrote:
> 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.
>
>
> Adrian
>
>
>
>
> On Mar 16, 2009, at 12:21 PM, Dan-Cristian Bogos wrote:
>
> >
> > Adrian,
> >
> > On Mon, 2009-03-16 at 11:50 +0100, Adrian Georgescu wrote:
> > > This is a problem unrelated to the destinations reload. Most
> > > likely
> > > you did not create the correct rating table data.
> >
> > I am not sure if it is due to correct rating table data (should see
> > no
> > Span price in that case I think), so bear with me to read the logs.
> >
> > Here comes a more detailed usage scenario:
> >
> > I have added a new number inside destination table (like you said,
> > no
> > rating defined, just the destination one).
> >
> > * First query will identify maybe correctly the destination 31
> > (since
> > the reload of rating tables was not yet done and the new destination
> > is
> > not yet in the memory).
> >
> > ShowPrice from=dan at itsyscom.com gateway=10.10.10.1 Duration=59
> > To=0031676000008
> > 0.1200
> > Duration: 60 s
> > App: audio
> > Destination: 31
> > Customer: default
> > Increment: 60 s
> > Connect: 0.0000
> > StartTime: 2009-03-16 10:08:45
> > --
> > Span: 1
> > Duration: 60 s
> > ProfileId: DEFAULT / weekday
> > RateId: DEFAULT / 0-24h
> > Rate: 0.1200 / 60 s
> > Price: 0.1200
> >
> > reloadratingtables
> > 1
> >
> > * Second and third attempt are after reloadratingtables succeed -
> > saw it
> > in mysql.log. Notice that the destination identified is still 31.
> >
> > ShowPrice from=dan at itsyscom.com gateway=10.10.10.1 Duration=59
> > To=0031676000008
> > 0.1200
> > Duration: 60 s
> > App: audio
> > Destination: 31
> > Customer: default
> > Increment: 60 s
> > Connect: 0.0000
> > StartTime: 2009-03-16 10:09:52
> > --
> > Span: 1
> > Duration: 60 s
> > ProfileId: DEFAULT / weekday
> > RateId: DEFAULT / 0-24h
> > Rate: 0.1200 / 60 s
> > Price: 0.1200
> >
> > ShowPrice from=dan at itsyscom.com gateway=10.10.10.1 Duration=59
> > To=0031676000008
> > 0.1200
> > Duration: 60 s
> > App: audio
> > Destination: 31
> > Customer: default
> > Increment: 60 s
> > Connect: 0.0000
> > StartTime: 2009-03-16 10:18:20
> > --
> > Span: 1
> > Duration: 60 s
> > ProfileId: DEFAULT / weekday
> > RateId: DEFAULT / 0-24h
> > Rate: 0.1200 / 60 s
> > Price: 0.1200
> >
> > Connection closed by foreign host.
> >
> > * Here I have restarted the cdrtool with /etc/init.d/cdrtool
> > restart.
> > Now the destination is correctly identified as 31676000008 (full
> > length), of course without Span section since I have no rating
> > defined
> > yet.
> >
> > DellLaptop:/usr/local/src/cdrtool# telnet localhost 9094
> > Trying 127.0.0.1...
> > Connected to localhost.
> > Escape character is '^]'.
> > ShowPrice from=dan at itsyscom.com gateway=10.10.10.1 Duration=59
> > To=0031676000008
> > 0
> > Duration: 60 s
> > App: audio
> > Destination: 31676000008
> > Customer: default
> > Increment: 60 s
> >
> >
> > Is my logic broken?
> > Same thing happens if I simply remove the destination (still showing
> > it
> > in ShowPrice even if there is no longer in the database.
> >
> > Ta,
> > DanB
> >
> >
>
More information about the Users
mailing list