Hi Laszlo, thanks for your reply.
Take a look: http://img143.imageshack.us/img143/6237/cdruh.jpg [email protected], 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: [email protected]? I didn't set any CDRTool param in my opensips.cfg. Philipp ----- Original Nachricht ---- Von: Laszlo <[email protected]> An: OpenSIPS users mailling list <[email protected]> Datum: 04.04.2010 19:49 Betreff: Re: [OpenSIPS-Users] CDRTool Prepaid > Hi Philipp, > > 2010/4/4 Philipp Hoffmann <[email protected]> > > > 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 > > [email protected] to sip:[email protected]:5060;transport=udp is > > postpaid not limited > > > > .... but if I manualy check this, the MySQL result tells: > > > > mysql> select * from prepaid where account = '[email protected]'; > > > > > +----+-------------+----------------------------------+---------+----------- > ----------+-----------------+-----------------+--------------+ > > | id | reseller_id | account | balance | > > change_date | active_sessions | session_counter | max_sessions | > > > > > +----+-------------+----------------------------------+---------+----------- > ----------+-----------------+-----------------+--------------+ > > | 10 | 0 | [email protected] | 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:[email protected] <sip%[email protected]> Gateway=xx.xx.xx.xx > > To=sip:[email protected]: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 > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
