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

[Dan-Cristian Bogos]

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