[OpenSER-Users] cdrtool billing

[David Villasmil]

AHA!!  So THAT's what I was missing!!

Thanks a lot Adrian!

d

On Wed, Jun 18, 2008 at 2:14 AM, Adrian Georgescu <ag at ag-projects.com>
wrote:

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