Re: [OpenSER-Users] cdrtool billing

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: