[OpenSIPS-Users] CDRTool Prepaid

Philipp Hoffmann philipp.hoffmann at arcor.de
Sun Apr 4 20:24:52 CEST 2010


Hi Laszlo,

thanks for your reply.

Take a look:
http://img143.imageshack.us/img143/6237/cdruh.jpg

hoff01 at sip.hns-rechenzentrum.de, is my subscriber and billing costumer 
for this call.

I use OpenSIPS's functions prefix, strip to get the right e.164-number.
So, I have change the CDRTool's standard class for number translation, 
for the right result:

49 => Germany
800 => Prefix for free calls
3301000 => Hotline of the Germany telecom (Deutsche Telekom)

83.169.18.105 is our SS7 interconnection gateway.

Why set CDRTool Customer: subscriber=pierrel01 at sip.hns-rechenzentrum.de? 
I didn't set any CDRTool param in my opensips.cfg.

Philipp

Am 04.04.2010 19:49, schrieb Laszlo:
> Hi Philipp,
>
> 2010/4/4 Philipp Hoffmann <philipp.hoffmann at arcor.de 
> <mailto:philipp.hoffmann at arcor.de>>
>
>     Dear list,
>
>     I have created a prepaid account in our CDRTool database, but I
>     recived any time "postpaid not limited" in syslog:
>
>     Apr  3 11:32:33 ser1 call-control[2215]: Call id 535fc5df9397086
>     of user at domain.de <mailto:user at domain.de> to
>     sip:498003301000 at xx.xx.xx.xx:5060;transport=udp is postpaid not
>     limited
>
>     .... but if I manualy check this, the MySQL result tells:
>
>     mysql> select * from prepaid where account = 'user at domain.de
>     <mailto:user at domain.de>';
>     +----+-------------+----------------------------------+---------+---------------------+-----------------+-----------------+--------------+
>     | id | reseller_id | account                          | balance |
>     change_date         | active_sessions | session_counter |
>     max_sessions |
>     +----+-------------+----------------------------------+---------+---------------------+-----------------+-----------------+--------------+
>     | 10 |           0 | user at domain.de <mailto:user at domain.de> |
>      5.0000 | 0000-00-00 00:00:00 |                 |               0
>     |            2 |
>     +----+-------------+----------------------------------+---------+---------------------+-----------------+-----------------+--------------+
>     1 row in set (0.00 sec)
>
>     Another example for this:
>
>     > > telnet xx.xx.xx.xx 9024
>     MaxSessionTime Duration=36000 CallId=535fc5df9397086
>     From=sip:user at domain.de <mailto:sip%3Auser at domain.de>
>     Gateway=xx.xx.xx.xx To=sip:498003301000 at xx.xx.xx.xx:5060;transport=udp
>
>     type=prepaid
>
>     Callcontrol's config.ini point to the right cdrtool host.
>
>     Any idea?
>
>     Regards,
>     Philipp
>
>
> If you have a look at the cdrs in cdrtool, all fields are filled 
> correctly? Like canonical uri, etc.
> Can you paste an example event from radacct?
>
> -Laszlo
>
>
> _______________________________________________
> 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/20100404/afb1e586/attachment.htm 


More information about the Users mailing list