[Kamailio-Users] CDRTool not applying rates

[David Villasmil]

this is the thread:



---------- Forwarded message ----------
From: Adrian Georgescu <ag at ag-projects.com>
Date: Wed, Jun 18, 2008 at 2:14 AM
Subject: [OpenSER-Users] cdrtool billing
To: users at 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 at gmail.com> wrote:

> 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 at 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 at 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 at lists.kamailio.org
>>> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.kamailio.org
>> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20080825/2a3b8096/attachment.htm