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:[email protected]
To=sip:[email protected] 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:[email protected] To=sip:[email protected]
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 [email protected],
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 |          |             | [email protected] | 441           |
| 442           |                   | Europe/Amsterdam |         0 |
0 |              | 
+----+----------+-------------+-------------------+---------------+-------------------+---------------+-------------------+------------------+-----------+--------------+--------------+
3 rows in set (0.01 sec)


Ta,
DanB


_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Reply via email to