Tis say that's what I have... except you don't expand on you Customers' table..
mysql> select * from destinations; select * from billing_customers; select * from billing_profiles;select * from billing_rates;
+----+---------+--------+------------+---------+-----------+
| id | gateway | domain | subscriber | dest_id | dest_name |
+----+---------+--------+------------+---------+-----------+
| 3 | | | | 1 | USA |
+----+---------+--------+------------+---------+-----------+
1 row in set (0.00 sec)
+----+----------------+--------+------------+---------------+-------------------+---------------+-------------------+---------------+-----------+--------------+--------------+
| 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 | | | 1 | 1 | 1 | 1 | America/Miami | 6 | 0 | |
+----+----------------+--------+------------+---------------+-------------------+---------------+-------------------+---------------+-----------+--------------+--------------+
1 row in set (0.00 sec)
+----+---------+--------+------------+--------+------------+-------+------------+-------+------------+-------+------------+-------+
| 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)
+----+---------+--------+------------+--------+-------------+--------------+-------------+-------------+-------------+
| id | gateway | domain | subscriber | name | destination | durationRate | trafficRate | application | connectCost |
+----+---------+--------+------------+--------+-------------+--------------+-------------+-------------+-------------+
| 6 | | | | Normal | 001 | 5 | | audio | 0 |
+----+---------+--------+------------+--------+-------------+--------------+-------------+-------------+-------------+
1 row in set (0.00 sec)
mysql>
On Mon, Jun 16, 2008 at 2:37 PM, Iñaki Baz Castillo <ibc@in.ilimit.es> wrote:
> El Monday 16 June 2008 13:16:17 David Villasmil escribió:
>
>> I also have installed and configure cdrtool, but I can't seem to make
>> it work properly, as documentation is very bad I had to half-make it
>> work in starts and fits. Now i got it to al least show the destination
>> description as per the destination table which is linked to the rates
>> table, but it doesn't assigns the rate or calculates the price for the
>> call... this is very frustating... but hey, I'm learning here!
>
> Your tables are incorect. Let me put an example for Spain:
>
> * Destinations table:
> - Destination ID: 34 (needed !!!)
> - Description: Spain
>
> * Customers:
> - Domain: sip.yourdomain.com (the domain which clients authenticate).
> You can also set the source IP (Gateway) instead if all your clients come from
> the same source IP.
>
> * Profiles:
> - Profile ID: Normal
> - Rate Id1: reducida
> - 00-H1: 8
> - Rate Id2: cara
> - H1-H2: 22
> - Rate Id3: reducida
> - H2-H3: 24
>
> * Rates:
> - Rate Id: reducida
> - Destination: 34
> - Price: 5
> - App: audio ( NEEDED !!! )
> - Conecct: 0
> ---------
> - Rate Id: cara
> - Destination: 34
> - Price: 20
> - App: audio ( NEEDED !!! )
> - Conecct: 0
>
>
>
>
> --
> Iñaki Baz Castillo
> ibc@in.ilimit.es
>
> _______________________________________________
> Users mailing list
> Users@lists.openser.org
> http://lists.openser.org/cgi-bin/mailman/listinfo/users
>