[Kamailio-Users] CDRTool not applying rates

List overview All Threads
Download

newer

older

[Serusers] ser 0.10 doucmentation

Re: [Kamailio-Users] presence fail

Brian Del Shasta

25 Aug 2008 25 Aug '08

1:20 p.m.

I believe my rating tables are configured correctly now thanks to David Villasmil who sent me examples from his working setup. However, I am still unable to see any rates. The rating engine seems to be started and I have no problem identifying and matching calls based on specific criteria. But I still see no rates. I'm wondering if anyone knows the best place to troubleshoot the rating engine would be or if anyone has any other ideas? Thank you in advance, and thanks again David for your help!

Attachments:

attachment.html (text/html — 556 bytes)

Show replies by date

Iñaki Baz Castillo

25 Aug 25 Aug

1:47 p.m.

El Lunes, 25 de Agosto de 2008, Brian Del Shasta escribió:

...

Make sure you set "type=audio" in Rates table. -- Iñaki Baz Castillo

Brian Del Shasta

3:40 p.m.

I have the Application type set to 'audio', I'm assuming you don't actually mean 'type=audio'. On Mon, Aug 25, 2008 at 12:47 PM, Iñaki Baz Castillo <ibc(a)aliax.net> wrote:

...

El Lunes, 25 de Agosto de 2008, Brian Del Shasta escribió:

I believe my rating tables are configured correctly now thanks to David Villasmil who sent me examples from his working setup. However, I am

still

unable to see any rates. The rating engine seems to be started and I

have

no problem identifying and matching calls based on specific criteria.

But

I still see no rates. I'm wondering if anyone knows the best place to troubleshoot the rating engine would be or if anyone has any other ideas? Thank you in advance, and thanks again David for your help!

Make sure you set "type=audio" in Rates table. -- Iñaki Baz Castillo _______________________________________________ Users mailing list Users(a)lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

David Villasmil

3:47 p.m.

I don't really think that is what Brian means.... Brian, take a look at the CDR directory... there should be a script called something like "split_rates" or something to that effect I could never see the rates on the cdr web either... i had to create my own web.. ;) After having done that, someone told me about that script... you can also search the list for that thread david On Mon, Aug 25, 2008 at 9:40 PM, Brian Del Shasta <briandelshasta(a)gmail.com>wrote;wrote:

...

I have the Application type set to 'audio', I'm assuming you don't actually mean 'type=audio'. On Mon, Aug 25, 2008 at 12:47 PM, Iñaki Baz Castillo <ibc(a)aliax.net>wrote;wrote:

El Lunes, 25 de Agosto de 2008, Brian Del Shasta escribió:

I believe my rating tables are configured correctly now thanks to David Villasmil who sent me examples from his working setup. However, I am

still

unable to see any rates. The rating engine seems to be started and I

have

no problem identifying and matching calls based on specific criteria.

But

I still see no rates. I'm wondering if anyone knows the best place to troubleshoot the rating engine would be or if anyone has any other

ideas?

Thank you in advance, and thanks again David for your help!

_______________________________________________ Users mailing list Users(a)lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

David Villasmil

3:48 p.m.

this is the thread: ---------- Forwarded message ---------- From: Adrian Georgescu <ag(a)ag-projects.com> Date: Wed, Jun 18, 2008 at 2:14 AM Subject: [OpenSER-Users] cdrtool billing To: users(a)lists.openser.org David, When $RatingEngine['split_rating_table'] setting is true, after changing the rates in the web interface or by importing them, you must run the script from scripts/splitRatingTables.php to split the central billing_rates table into individual tables for each rate id. You do not need this feature if you have less than 100K rates in your system. Adrian On Mon, Jun 16, 2008 at 5:55 PM, Iñaki Baz Castillo <ibc at in.ilimit.es> wrote:

...

El Monday 16 June 2008 17:44:56 David Villasmil escribió: > But as it happens, when you specify a profile like I did: billing

profile

...

> is NORMAL, but RATE NAME is 1, then you MUST CREATE A TABLE CALLED > "BILLING_RATES_1", I don't know if cdrtool is supposed to create

it but

...

didn't do it for me. I had to manually create the table:

What about if you don't use numeric values as Rate Id? I use Rate id with textual value ("Reducida", "Normal"...) and had

not your

...

problem.

At least in my case, it doesn't find the rate... Same thing, I had to create the table... without creating the table: Jun 16 12:02:30 rgi-sql CDRTool[15559]: Error: Cannot find rates for callid= 00808260004800068104000005E9 at 82.144.106.187, billing party=user at 1.2.3.4, customer gateway=1.2.3.4, gateway=1.2.3.4, destination=1, profile=Normal, app=audio and then, having created the billing_rates_reducida table: Jun 16 12:03:16 rgi-sql CDRTool[21793]: ConnectFee=0.0000 Span=1 Duration=6 DestId=1 gateway=1.2.3.4 Profile=Normal Period=weekday Rate=reducida Interval=0-24 Cost=0.0500/60 Price=0.0050 On Mon, Aug 25, 2008 at 9:47 PM, David Villasmil < david.villasmil.work(a)gmail.com> wrote:

...

I have the Application type set to 'audio', I'm assuming you don't actually mean 'type=audio'. On Mon, Aug 25, 2008 at 12:47 PM, Iñaki Baz Castillo <ibc(a)aliax.net>wrote;wrote:

El Lunes, 25 de Agosto de 2008, Brian Del Shasta escribió:

I believe my rating tables are configured correctly now thanks to David Villasmil who sent me examples from his working setup. However, I am

still

unable to see any rates. The rating engine seems to be started and I

have

no problem identifying and matching calls based on specific criteria.

But

I still see no rates. I'm wondering if anyone knows the best place to troubleshoot the rating engine would be or if anyone has any other

ideas?

Thank you in advance, and thanks again David for your help!

_______________________________________________ Users mailing list Users(a)lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

Brian Del Shasta

4:04 p.m.

David, I did find the script. It did re-create the table billing_rates_reducida successfully, but I had already created it manually per your suggestion. I looked through the old thread you posted as well, what log are you looking in to find this data?: Jun 16 12:02:30 rgi-sql CDRTool[15559]: Error: Cannot find rates for callid= 00808260004800068104000005E9 at 82.144.106.187, billing party=user at 1.2.3.4, customer gateway=1.2.3.4, gateway=1.2.3.4, destination=1, profile=Normal, app=audio and then, having created the billing_rates_reducida table: Jun 16 12:03:16 rgi-sql CDRTool[21793]: ConnectFee=0.0000 Span=1 Duration=6 DestId=1 gateway=1.2.3.4 Profile=Normal Period=weekday Rate=reducida Interval=0-24 Cost=0.0500/60 Price=0.0050 Thanks On Mon, Aug 25, 2008 at 2:47 PM, David Villasmil < david.villasmil.work(a)gmail.com> wrote:

...

I have the Application type set to 'audio', I'm assuming you don't actually mean 'type=audio'. On Mon, Aug 25, 2008 at 12:47 PM, Iñaki Baz Castillo <ibc(a)aliax.net>wrote;wrote:

El Lunes, 25 de Agosto de 2008, Brian Del Shasta escribió:

I believe my rating tables are configured correctly now thanks to David Villasmil who sent me examples from his working setup. However, I am

still

unable to see any rates. The rating engine seems to be started and I

have

no problem identifying and matching calls based on specific criteria.

But

I still see no rates. I'm wondering if anyone knows the best place to troubleshoot the rating engine would be or if anyone has any other

ideas?

Thank you in advance, and thanks again David for your help!

_______________________________________________ Users mailing list Users(a)lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

Iñaki Baz Castillo

5 p.m.

El Lunes, 25 de Agosto de 2008, Brian Del Shasta escribió:

...

I have the Application type set to 'audio', I'm assuming you don't actually mean 'type=audio'.

Yes, I mean that. The fact is that I don't remember now what I did to get it working but I can sure you that the solution is in reading several times the Readme.txt ;) - Basically you must be sure that you filled the Destination table with the countries and regions prefixes. - Also fill correctly the Customer table with the rate profiles. - In Profiles be sure that all the rate Profiles have correctly set their rates. - In Rates be sure that Destination is the prefix set in Destinations tables, App=audio and Connect=(some umber or cero number). After that it should work. Verify it by looking at the "Rating information" by clicking in the 1N, 2N, 3N link. PD: Note that you can re-normalize calls by selecting "ReNormalize" in the CDRs form. -- Iñaki Baz Castillo

Brian Del Shasta

5:57 p.m.

This is displayed in my syslog whenever I perform a CDR query within CDRTool. Is it relevant? Aug 25 16:03:15 fndipt01 CDRTool[2450]: Error: failed to request mysql lock Aug 25 16:03:15 fndipt01 CDRTool[2450]: Unlock ser_radius:radacct Aug 25 16:03:15 fndipt01 CDRTool[2450]: Error in unLockNormalization() On Mon, Aug 25, 2008 at 4:00 PM, Iñaki Baz Castillo <ibc(a)aliax.net> wrote:

...

El Lunes, 25 de Agosto de 2008, Brian Del Shasta escribió:

I have the Application type set to 'audio', I'm assuming you don't

actually

mean 'type=audio'.

5967

days inactive

5967

days old

sr-users@lists.kamailio.org

Manage subscription

7 comments

3 participants

tags (0)

participants (3)

Brian Del Shasta
David Villasmil
Iñaki Baz Castillo