[OpenSIPS-Users] CDRTool - ShowPrice -> No match for gateway parameter

[Adrian Georgescu]

Hi Dan,

I made a fix for this, please test the last version 6.7.7

Adrian

On Apr 8, 2009, at 9:26 PM, Dan-Cristian Bogos wrote:

> More on the subject ...
>
> Just to be sure that I am not doing any mistake, the log of mysql for
> the same command (ShowPrice             From=sip:123 at example2.com
> To=sip:0031650222333 at example.com Gateway=10.0.0.1 Duration=59) shows  
> the
> gateway parameter queried as suspected, faked:
>
> 090408 21:17:22	    314 Init DB     cdrtool
> 		    314 Query       select * from billing_customers
>        where subscriber = '123 at example2.com'
>        or domain        = 'example2.com'
>        or gateway       = '0.0.0.0'
>        or (subscriber = '' and domain = '' and gateway = '')
>        order by subscriber desc, domain desc, gateway desc limit 1
>
>
> Ta,
> DanB
>
> On Wed, 2009-04-08 at 17:34 +0200, Dan-Cristian Bogos wrote:
>> Guys,
>>
>> some strange thing I noticed in the last versions of CDRTool  
>> related to
>> usage of the Gateway parameter in ShowPrice. Based on logs it looks  
>> like
>> the gateway parameter is somehow faked (or perhaps wrongly  
>> converted).
>>
>> 1. On ShowPrice commands:
>>
>> * Using default dataset, I have replaced the default entry (gateway,
>> domain, subscriber empty) with (gateway=10.0.0.1 , subscriber and  
>> domain
>> empty). Reloaded the cdrtool from console and executed:
>> ShowPrice             From=sip:123 at example2.com
>> To=sip:0031650222333 at example.com Gateway=10.0.0.1 Duration=59
>>
>> The answer was:
>> 0
>>
>> In the syslog I could find:
>> Apr  8 17:12:54 DellLaptop cdrtool[11081]: ShowPrice
>> From=sip:123 at example2.com To=sip:0031650222333 at example.com
>> Gateway=10.0.0.1 Duration=59
>> Apr  8 17:12:54 DellLaptop cdrtool[11081]: Error: no customer found  
>> in
>> billing_customers table for billing party=123 at example2.com,
>> domain=example2.com, gateway=0.0.0.0
>>
>> In the mysql table I have:
>>
>> mysql> select * from billing_customers;
>> +----+----------+-------------+-------------------+--------------- 
>> +-------------------+---------------+------------------- 
>> +------------------+-----------+--------------+--------------+
>> | id | gateway  | domain      | subscriber        | profile_name1 |
>> profile_name1_alt | profile_name2 | profile_name2_alt | timezone
>> | increment | min_duration | country_code |
>> +----+----------+-------------+-------------------+--------------- 
>> +-------------------+---------------+------------------- 
>> +------------------+-----------+--------------+--------------+
>> |  4 | 10.0.0.1 |             |                   | 441           |
>> | 442           |                   | Europe/Amsterdam |         0 |
>> 0 |              |
>> |  5 |          | example.com |                   | 441           |
>> | 442           |                   | Europe/Amsterdam |         0 |
>> 0 |              |
>> |  6 |          |             | alice at example.com | 441           |
>> | 442           |                   | Europe/Amsterdam |         0 |
>> 0 |              |
>> +----+----------+-------------+-------------------+--------------- 
>> +-------------------+---------------+------------------- 
>> +------------------+-----------+--------------+--------------+
>> 3 rows in set (0.01 sec)
>>
>>
>> Ta,
>> DanB
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090409/0eb9aab9/attachment.htm