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
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@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@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/users
-
Adrian Georgescu -
David Villasmil