[OpenSIPS-Users] CDRTool Prepaid

[Philipp Hoffmann]

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

----- Original Nachricht ----
Von:     Laszlo <laszlo at voipfreak.net>
An:      OpenSIPS users mailling list <users at lists.opensips.org>
Datum:   04.04.2010 19:49
Betreff: Re: [OpenSIPS-Users] CDRTool Prepaid

> Hi Philipp,
> 
> 2010/4/4 Philipp Hoffmann <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 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';
> >
> >
> +----+-------------+----------------------------------+---------+-----------
> ----------+-----------------+-----------------+--------------+
> > | id | reseller_id | account                          | balance |
> > change_date         | active_sessions | session_counter | max_sessions |
> >
> >
> +----+-------------+----------------------------------+---------+-----------
> ----------+-----------------+-----------------+--------------+
> > | 10 |           0 | 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 <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
>