Hi,
The CDRTool is not generate rating and prices.
My configuration:
-- billing_rates | id | gateway | domain | subscriber | name | destination | durationRate | trafficRate | application | connectCost | +----+---------+--------+------------+------+-------------+--------------+-------------+-------------+-------------+ | 1 | | | | 551 | 55 | 1500 | | audio | 0 | | 2 | | | | 552 | 55 | 1000 | | audio | 0 |
-- billing_profiles | id | gateway | domain | subscriber | name | rate_name1 | hour1 | rate_name2 | hour2 | rate_name3 | hour3 | rate_name4 | hour4 | +----+---------+--------+------------+------+------------+-------+------------+-------+------------+-------+------------+-------+ | 1 | | | | 551 | 551 | 18 | 552 | 0 | | 0 | | 0 | | 2 | | | | 552 | 552 | 18 | 552 | 0 | | 0 | | 0 |
-- billing_customers | id | gateway | domain | subscriber | profile_name1 | profile_name1_alt | profile_name2 | profile_name2_alt | timezone | increment | min_duration | country_code | +----+---------+-------------------+------------+---------------+-------------------+---------------+-------------------+-------------------+-----------+--------------+--------------+ | 1 | | mydomain.com | | 551 | | 552 | | America/Sao_Paulo | 0 | 0 | |
-- destinations | id | gateway | domain | subscriber | dest_id | dest_name | +----+---------+--------+------------+---------+-----------+ | 1 | | | | 55 | Brazil |
-- And the radacct: | 51 | 1vpzOG09ZNwBth5S@192.168.2.29 | 695fa85e025f57eb | 87002@mydomain.com | mydomain.com | | 5060 | | 2008-09-17 18:05:58 | 2008-09-17 18:06:03 | 5 | NULL | NULL | | 0 | 0 | 00551533334444@mydomain.com | 87002@mydomain.com | 200 | Sip-Session | | | 0 | 0 | NULL | Invite | 200 | as7e8c15b3 | gluy7ejee3XZ1ckO | =2B551533334444@200.200.200.200 | | audio | | | | 201.201.201.201 | 5060 | 00551533334444@mydomain.com | | 0 | | | 0.0000 | 1 | | NULL | | | | |
The configuration is correct?
Thanks. Diego.