[OpenSER-Users] cdrtool billing

David Villasmil david.villasmil.work at gmail.com
Mon Jun 16 17:27:21 CEST 2008


I just found two errors... something noone ever said (at least to me) aobut
cdrtool, i got this on the syslog:

Jun 16 11:18:37 rgi-sql ^\$V^H[15556]: Database error for query update
billing_rates_Normal set
gateway='82.144.106.187',domain='',subscriber='',destination='001',durationRate='5',application='audio',connectCost='0'
where  id = '6' and  (1=1)  : Table 'cdrtool.billing_rates_Normal' doesn't
exist (1146)

there IS no table by that name, Is cdrtool supposed to create it? DO you
have only billing_rates and billing_ratesNGN? or do you have many others?
each by the name of a profile?

I say this error too.. :S

Jun 16 11:24:15 rgi-sql CDRTool[15558]: Error: Cannot find rates for callid=
0080826000480002A49500000FAB at 82.144.106.187, billing party=
opencall at 82.144.106.187, customer gateway=82.144.106.187, gateway=
82.144.106.187, destination=1, profile=Normal, app=audio


Time to read again!

thanks anyway!

On Mon, Jun 16, 2008 at 5:20 PM, Iñaki Baz Castillo <ibc at in.ilimit.es>
wrote:

> El Monday 16 June 2008 16:53:37 David Villasmil escribió:
> > Tis say that's what I have... except you don't expand on you Customers'
> > table..
>
> Yes sorry, in your first mail it cost to me to understand the tables.
> Sincerelly the only advice I caould give to you is readin gslowly some
> times
> the README.txt file about accounting in CDRTool. Ok, it's not very easy but
> the fact is that it explains all. Re-read again, I had to read it several
> times after get it working (same problem as you XD).
>
> Regards.
>
> --
> Iñaki Baz Castillo
> ibc at in.ilimit.es
>
> _______________________________________________
> 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/20080616/ec5aa7fd/attachment.htm 


More information about the Users mailing list