[OpenSER-Users] cdrtool billing

[David Villasmil]

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




strange... I gues our versions are not the same?

I'm using v 6.4.1, you?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20080616/1468ab78/attachment.htm