El Monday 16 June 2008 16:53:37 David Villasmil escribió: 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(a)in.ilimit.es

I finally got it work, I'd like to explain here what the problem was and how I fixed it: To start with, after installing cdrtool, and adding some info my tables ended like this: select * from destinations; +----+----------------+--------+------------+---------+-----------+ | id | gateway | domain | subscriber | dest_id | dest_name | +----+----------------+--------+------------+---------+-----------+ | 3 | 1.2.3.4 | | | 1 | USA | +----+----------------+--------+------------+---------+-----------+ 1 row in set (0.00 sec) select * from billing_customers; +----+----------------+--------+------------+---------------+-------------------+---------------+-------------------+---------------+-----------+--------------+--------------+ | id | gateway | domain | subscriber | profile_name1 | profile_name1_alt | profile_name2 | profile_name2_alt | timezone | increment | min_duration | country_code | +----+----------------+--------+------------+---------------+-------------------+---------------+-------------------+---------------+-----------+--------------+--------------+ | 4 | 1.2.3.4 | | | Normal | Normal | Normal | Normal | America/Miami | 6 | 0 | | +----+----------------+--------+------------+---------------+-------------------+---------------+-------------------+---------------+-----------+--------------+--------------+ 1 row in set (0.00 sec) select * from billing_profiles; +----+---------+--------+------------+--------+------------+-------+------------+-------+------------+-------+------------+-------+ | id | gateway | domain | subscriber | name | rate_name1 | hour1 | rate_name2 | hour2 | rate_name3 | hour3 | rate_name4 | hour4 | +----+---------+--------+------------+--------+------------+-------+------------+-------+------------+-------+------------+-------+ | 3 | | | | Normal | 1 | 24 | | 0 | | 0 | | 0 | +----+---------+--------+------------+--------+------------+-------+------------+-------+------------+-------+------------+-------+ 1 row in set (0.00 sec) select * from billing_rates; +----+----------------+--------+------------+--------+-------------+--------------+-------------+-------------+-------------+ | id | gateway | domain | subscriber | name | destination | durationRate | trafficRate | application | connectCost | +----+----------------+--------+------------+--------+-------------+--------------+-------------+-------------+-------------+ | 7 | 1.2.3.4 | | | 1 | 001 | 100 | | audio | 0 | +----+----------------+--------+------------+--------+-------------+--------------+-------------+-------------+-------------+ 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: select * from billing_rates_1; +----+----------------+--------+------------+------+-------------+--------------+-------------+-------------+-------------+ | id | gateway | domain | subscriber | name | destination | durationRate | trafficRate | application | connectCost | +----+----------------+--------+------------+------+-------------+--------------+-------------+-------------+-------------+ | 8 | 1.2.3.4 | | | 1 | 1 | 5 | 10 | audio | 10 | +----+----------------+--------+------------+------+-------------+--------------+-------------+-------------+-------------+ and voilá! It started working... I hope my struggle helps someone! David On Mon, Jun 16, 2008 at 5:27 PM, David Villasmil < david.villasmil.work(a)gmail.com&gt; wrote:

On Mon, Jun 16, 2008 at 5:55 PM, Iñaki Baz Castillo &lt;ibc(a)in.ilimit.es&gt; wrote: 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(a)82.144.106.187, billing party=user(a)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?

Well, in any case, now we both know how it works... ;) thanks a lot! d On Mon, Jun 16, 2008 at 6:14 PM, Iñaki Baz Castillo &lt;ibc(a)in.ilimit.es&gt; wrote: