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