I believe my rating tables are configured correctly now thanks to David Villasmil who sent me examples from his working setup. However, I am still unable to see any rates. The rating engine seems to be started and I have no problem identifying and matching calls based on specific criteria. But I still see no rates. I'm wondering if anyone knows the best place to troubleshoot the rating engine would be or if anyone has any other ideas? Thank you in advance, and thanks again David for your help!
El Lunes, 25 de Agosto de 2008, Brian Del Shasta escribió:
I believe my rating tables are configured correctly now thanks to David Villasmil who sent me examples from his working setup. However, I am still unable to see any rates. The rating engine seems to be started and I have no problem identifying and matching calls based on specific criteria. But I still see no rates. I'm wondering if anyone knows the best place to troubleshoot the rating engine would be or if anyone has any other ideas? Thank you in advance, and thanks again David for your help!
Make sure you set "type=audio" in Rates table.
I have the Application type set to 'audio', I'm assuming you don't actually mean 'type=audio'.
On Mon, Aug 25, 2008 at 12:47 PM, Iñaki Baz Castillo ibc@aliax.net wrote:
El Lunes, 25 de Agosto de 2008, Brian Del Shasta escribió:
I believe my rating tables are configured correctly now thanks to David Villasmil who sent me examples from his working setup. However, I am
still
unable to see any rates. The rating engine seems to be started and I
have
no problem identifying and matching calls based on specific criteria.
But
I still see no rates. I'm wondering if anyone knows the best place to troubleshoot the rating engine would be or if anyone has any other ideas? Thank you in advance, and thanks again David for your help!
Make sure you set "type=audio" in Rates table.
-- Iñaki Baz Castillo
Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
I don't really think that is what Brian means....
Brian, take a look at the CDR directory... there should be a script called something like "split_rates" or something to that effect I could never see the rates on the cdr web either... i had to create my own web.. ;) After having done that, someone told me about that script...
you can also search the list for that thread
david
On Mon, Aug 25, 2008 at 9:40 PM, Brian Del Shasta briandelshasta@gmail.comwrote:
I have the Application type set to 'audio', I'm assuming you don't actually mean 'type=audio'.
On Mon, Aug 25, 2008 at 12:47 PM, Iñaki Baz Castillo ibc@aliax.netwrote:
El Lunes, 25 de Agosto de 2008, Brian Del Shasta escribió:
I believe my rating tables are configured correctly now thanks to David Villasmil who sent me examples from his working setup. However, I am
still
unable to see any rates. The rating engine seems to be started and I
have
no problem identifying and matching calls based on specific criteria.
But
I still see no rates. I'm wondering if anyone knows the best place to troubleshoot the rating engine would be or if anyone has any other
ideas?
Thank you in advance, and thanks again David for your help!
Make sure you set "type=audio" in Rates table.
-- Iñaki Baz Castillo
Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
this is the thread:
---------- Forwarded message ---------- From: Adrian Georgescu ag@ag-projects.com Date: Wed, Jun 18, 2008 at 2:14 AM Subject: [OpenSER-Users] cdrtool billing To: users@lists.openser.org
David,
When $RatingEngine['split_rating_table'] setting is true, after changing the rates in the web interface or by importing them, you must run the script from scripts/splitRatingTables.php to split the central billing_rates table into individual tables for each rate id. You do not need this feature if you have less than 100K rates in your system.
Adrian
On Mon, Jun 16, 2008 at 5:55 PM, Iñaki Baz Castillo <ibc at in.ilimit.es> wrote:
El Monday 16 June 2008 17:44:56 David Villasmil escribió:
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:
What about if you don't use numeric values as Rate Id? I use Rate id with textual value ("Reducida", "Normal"...) and had
not your
problem.
At least in my case, it doesn't find the rate... Same thing, I had to create the table...
without creating the table:
Jun 16 12:02:30 rgi-sql CDRTool[15559]: Error: Cannot find rates for callid= 00808260004800068104000005E9 at 82.144.106.187, billing party=user at 1.2.3.4, customer gateway=1.2.3.4, gateway=1.2.3.4, destination=1, profile=Normal, app=audio
and then, having created the billing_rates_reducida table:
Jun 16 12:03:16 rgi-sql CDRTool[21793]: ConnectFee=0.0000 Span=1 Duration=6 DestId=1 gateway=1.2.3.4 Profile=Normal Period=weekday Rate=reducida Interval=0-24 Cost=0.0500/60 Price=0.0050
On Mon, Aug 25, 2008 at 9:47 PM, David Villasmil < david.villasmil.work@gmail.com> wrote:
I don't really think that is what Brian means....
Brian, take a look at the CDR directory... there should be a script called something like "split_rates" or something to that effect I could never see the rates on the cdr web either... i had to create my own web.. ;) After having done that, someone told me about that script...
you can also search the list for that thread
david
On Mon, Aug 25, 2008 at 9:40 PM, Brian Del Shasta < briandelshasta@gmail.com> wrote:
I have the Application type set to 'audio', I'm assuming you don't actually mean 'type=audio'.
On Mon, Aug 25, 2008 at 12:47 PM, Iñaki Baz Castillo ibc@aliax.netwrote:
El Lunes, 25 de Agosto de 2008, Brian Del Shasta escribió:
I believe my rating tables are configured correctly now thanks to David Villasmil who sent me examples from his working setup. However, I am
still
unable to see any rates. The rating engine seems to be started and I
have
no problem identifying and matching calls based on specific criteria.
But
I still see no rates. I'm wondering if anyone knows the best place to troubleshoot the rating engine would be or if anyone has any other
ideas?
Thank you in advance, and thanks again David for your help!
Make sure you set "type=audio" in Rates table.
-- Iñaki Baz Castillo
Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
David, I did find the script. It did re-create the table billing_rates_reducida successfully, but I had already created it manually per your suggestion. I looked through the old thread you posted as well, what log are you looking in to find this data?:
Jun 16 12:02:30 rgi-sql CDRTool[15559]: Error: Cannot find rates for callid= 00808260004800068104000005E9 at 82.144.106.187, billing party=user at 1.2.3.4, customer gateway=1.2.3.4, gateway=1.2.3.4, destination=1, profile=Normal, app=audio
and then, having created the billing_rates_reducida table:
Jun 16 12:03:16 rgi-sql CDRTool[21793]: ConnectFee=0.0000 Span=1 Duration=6 DestId=1 gateway=1.2.3.4 Profile=Normal Period=weekday Rate=reducida Interval=0-24 Cost=0.0500/60 Price=0.0050
Thanks
On Mon, Aug 25, 2008 at 2:47 PM, David Villasmil < david.villasmil.work@gmail.com> wrote:
I don't really think that is what Brian means....
Brian, take a look at the CDR directory... there should be a script called something like "split_rates" or something to that effect I could never see the rates on the cdr web either... i had to create my own web.. ;) After having done that, someone told me about that script...
you can also search the list for that thread
david
On Mon, Aug 25, 2008 at 9:40 PM, Brian Del Shasta < briandelshasta@gmail.com> wrote:
I have the Application type set to 'audio', I'm assuming you don't actually mean 'type=audio'.
On Mon, Aug 25, 2008 at 12:47 PM, Iñaki Baz Castillo ibc@aliax.netwrote:
El Lunes, 25 de Agosto de 2008, Brian Del Shasta escribió:
I believe my rating tables are configured correctly now thanks to David Villasmil who sent me examples from his working setup. However, I am
still
unable to see any rates. The rating engine seems to be started and I
have
no problem identifying and matching calls based on specific criteria.
But
I still see no rates. I'm wondering if anyone knows the best place to troubleshoot the rating engine would be or if anyone has any other
ideas?
Thank you in advance, and thanks again David for your help!
Make sure you set "type=audio" in Rates table.
-- Iñaki Baz Castillo
Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
El Lunes, 25 de Agosto de 2008, Brian Del Shasta escribió:
I have the Application type set to 'audio', I'm assuming you don't actually mean 'type=audio'.
Yes, I mean that.
The fact is that I don't remember now what I did to get it working but I can sure you that the solution is in reading several times the Readme.txt ;)
- Basically you must be sure that you filled the Destination table with the countries and regions prefixes. - Also fill correctly the Customer table with the rate profiles. - In Profiles be sure that all the rate Profiles have correctly set their rates. - In Rates be sure that Destination is the prefix set in Destinations tables, App=audio and Connect=(some umber or cero number).
After that it should work. Verify it by looking at the "Rating information" by clicking in the 1N, 2N, 3N link.
PD: Note that you can re-normalize calls by selecting "ReNormalize" in the CDRs form.
This is displayed in my syslog whenever I perform a CDR query within CDRTool. Is it relevant?
Aug 25 16:03:15 fndipt01 CDRTool[2450]: Error: failed to request mysql lock Aug 25 16:03:15 fndipt01 CDRTool[2450]: Unlock ser_radius:radacct Aug 25 16:03:15 fndipt01 CDRTool[2450]: Error in unLockNormalization()
On Mon, Aug 25, 2008 at 4:00 PM, Iñaki Baz Castillo ibc@aliax.net wrote:
El Lunes, 25 de Agosto de 2008, Brian Del Shasta escribió:
I have the Application type set to 'audio', I'm assuming you don't
actually
mean 'type=audio'.
Yes, I mean that.
The fact is that I don't remember now what I did to get it working but I can sure you that the solution is in reading several times the Readme.txt ;)
- Basically you must be sure that you filled the Destination table with the
countries and regions prefixes.
- Also fill correctly the Customer table with the rate profiles.
- In Profiles be sure that all the rate Profiles have correctly set their
rates.
- In Rates be sure that Destination is the prefix set in Destinations
tables, App=audio and Connect=(some umber or cero number).
After that it should work. Verify it by looking at the "Rating information" by clicking in the 1N, 2N, 3N link.
PD: Note that you can re-normalize calls by selecting "ReNormalize" in the CDRs form.
-- Iñaki Baz Castillo
Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
-
Brian Del Shasta -
David Villasmil -
Iñaki Baz Castillo