<div dir="ltr">this is the thread:<br><br><br><br>---------- Forwarded message ----------<br>From: <b class="gmail_sendername">Adrian Georgescu</b> <span dir="ltr"><<a href="mailto:ag@ag-projects.com">ag@ag-projects.com</a>></span><br>
Date: Wed, Jun 18, 2008 at 2:14 AM<br>Subject: [OpenSER-Users] cdrtool billing<br>To: <a href="mailto:users@lists.openser.org">users@lists.openser.org</a><br><br><br>David,<br>
<br>
When $RatingEngine['split_rating_<div class="gmail_quote">table'] setting is true, after<br>
changing the rates<br>
in the web interface or by importing them, you must run the script from<br>
scripts/splitRatingTables.php to split the central billing_rates table<br>
into<br>
individual tables for each rate id. You do not need this feature if<br>
you have<br>
less than 100K rates in your system.<br>
<br>
Adrian<br>
<br>
On Mon, Jun 16, 2008 at 5:55 PM, Iñaki Baz Castillo <ibc at<br>
<a href="http://in.ilimit.es/" target="_blank">in.ilimit.es</a>><br>
wrote:<br>
<br>
> El Monday 16 June 2008 17:44:56 David Villasmil escribió:<br>
><br>
> > But as it happens, when you specify a profile like I did: billing<br>
profile<br>
> > is NORMAL, but RATE NAME is 1, then you MUST CREATE A TABLE CALLED<br>
> > "BILLING_RATES_1", I don't know if cdrtool is supposed to create<br>
it but<br>
> > didn't do it for me. I had to manually create the table:<br>
><br>
> What about if you don't use numeric values as Rate Id?<br>
> I use Rate id with textual value ("Reducida", "Normal"...) and had<br>
not your<br>
> problem.<br>
><br>
<br>
At least in my case, it doesn't find the rate... Same thing, I had to<br>
create<br>
the table...<br>
<br>
without creating the table:<br>
<br>
Jun 16 12:02:30 rgi-sql CDRTool[15559]: Error: Cannot find rates for<br>
callid=<br>
00808260004800068104000005E9 at <a href="http://82.144.106.187/" target="_blank">82.144.106.187</a>, billing party=user at<br>
<a href="http://1.2.3.4/" target="_blank">1.2.3.4</a>,<br>
customer gateway=<a href="http://1.2.3.4/" target="_blank">1.2.3.4</a>, gateway=<a href="http://1.2.3.4/" target="_blank">1.2.3.4</a>, destination=1,<br>
profile=Normal,<br>
app=audio<br>
<br>
and then, having created the billing_rates_reducida table:<br>
<br>
Jun 16 12:03:16 rgi-sql CDRTool[21793]: ConnectFee=0.0000 Span=1<br>
Duration=6<br>
DestId=1 gateway=<a href="http://1.2.3.4/" target="_blank">1.2.3.4</a> Profile=Normal Period=weekday Rate=reducida<br>
Interval=0-24 Cost=0.0500/60 Price=0.0050<br>
<br>
</div><br><br><div class="gmail_quote">On Mon, Aug 25, 2008 at 9:47 PM, David Villasmil <span dir="ltr"><<a href="mailto:david.villasmil.work@gmail.com">david.villasmil.work@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div dir="ltr">I don't really think that is what Brian means....<br><br>Brian, take a look at the CDR directory... there should be a script called something like "split_rates" or something to that effect<br>
I could never see the rates on the cdr web either... i had to create my own web.. ;)<br>
After having done that, someone told me about that script... <br><br>you can also search the list for that thread<br><font color="#888888"><br>david</font><div><div></div><div class="Wj3C7c"><br><br><div class="gmail_quote">
On Mon, Aug 25, 2008 at 9:40 PM, Brian Del Shasta <span dir="ltr"><<a href="mailto:briandelshasta@gmail.com" target="_blank">briandelshasta@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div dir="ltr">I have the Application type set to 'audio', I'm assuming you don't actually mean 'type=audio'.<div>
<div></div><div><br><br><div class="gmail_quote">On Mon, Aug 25, 2008 at 12:47 PM, Iñaki Baz Castillo <span dir="ltr"><<a href="mailto:ibc@aliax.net" target="_blank">ibc@aliax.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">El Lunes, 25 de Agosto de 2008, Brian Del Shasta escribió:<br>
<div><div></div><div>> I believe my rating tables are configured correctly now thanks to David<br>
> Villasmil who sent me examples from his working setup. However, I am still<br>
> unable to see any rates. The rating engine seems to be started and I have<br>
> no problem identifying and matching calls based on specific criteria. But<br>
> I still see no rates. I'm wondering if anyone knows the best place to<br>
> troubleshoot the rating engine would be or if anyone has any other ideas?<br>
> Thank you in advance, and thanks again David for your help!<br>
<br>
</div></div>Make sure you set "type=audio" in Rates table.<br>
<font color="#888888"><br>
--<br>
Iñaki Baz Castillo<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.kamailio.org" target="_blank">Users@lists.kamailio.org</a><br>
<a href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</a><br>
</font></blockquote></div><br></div></div></div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.kamailio.org" target="_blank">Users@lists.kamailio.org</a><br>
<a href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div></div></div>
</blockquote></div><br></div>