<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Laszlo,<br>
<br>
thanks for your reply.<br>
<br>
Take a look:<br>
<a class="moz-txt-link-freetext" href="http://img143.imageshack.us/img143/6237/cdruh.jpg">http://img143.imageshack.us/img143/6237/cdruh.jpg</a><br>
<br>
<a class="moz-txt-link-abbreviated" href="mailto:hoff01@sip.hns-rechenzentrum.de">hoff01@sip.hns-rechenzentrum.de</a>, is my subscriber and billing costumer
for this call.<br>
<br>
I use OpenSIPS's functions prefix, strip to get the right e.164-number.<br>
So, I have change the CDRTool's standard class for number translation,
for the right result:<br>
<br>
49 => Germany<br>
800 => Prefix for free calls<br>
3301000 => Hotline of the Germany telecom (Deutsche Telekom)<br>
<br>
83.169.18.105 is our SS7 interconnection gateway.<br>
<br>
Why set CDRTool Customer:
<a class="moz-txt-link-abbreviated" href="mailto:subscriber=pierrel01@sip.hns-rechenzentrum.de">subscriber=pierrel01@sip.hns-rechenzentrum.de</a>? I didn't set any CDRTool
param in my opensips.cfg.<br>
<br>
Philipp<br>
<br>
Am 04.04.2010 19:49, schrieb Laszlo:
<blockquote
cite="mid:o2qa950b2031004041049s29f33e2eldac886fbdf26480f@mail.gmail.com"
type="cite">Hi Philipp,<br>
<br>
<div class="gmail_quote">2010/4/4 Philipp Hoffmann <span dir="ltr"><<a
moz-do-not-send="true" href="mailto:philipp.hoffmann@arcor.de">philipp.hoffmann@arcor.de</a>></span><br>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Dear
list,<br>
<br>
I have created a prepaid account in our CDRTool database, but I recived
any time "postpaid not limited" in syslog:<br>
<br>
Apr 3 11:32:33 ser1 call-control[2215]: Call id 535fc5df9397086 of <a
moz-do-not-send="true" href="mailto:user@domain.de">user@domain.de</a>
to <a class="moz-txt-link-freetext" href="sip:498003301000@xx.xx.xx.xx:5060;transport=udp">sip:498003301000@xx.xx.xx.xx:5060;transport=udp</a> is postpaid not
limited<br>
<br>
.... but if I manualy check this, the MySQL result tells:<br>
<br>
mysql> select * from prepaid where account = '<a
moz-do-not-send="true" href="mailto:user@domain.de">user@domain.de</a>';<br>
+----+-------------+----------------------------------+---------+---------------------+-----------------+-----------------+--------------+<br>
| id | reseller_id | account | balance |
change_date | active_sessions | session_counter | max_sessions |<br>
+----+-------------+----------------------------------+---------+---------------------+-----------------+-----------------+--------------+<br>
| 10 | 0 | <a moz-do-not-send="true"
href="mailto:user@domain.de">user@domain.de</a> | 5.0000 | 0000-00-00
00:00:00 | | 0 | 2 |<br>
+----+-------------+----------------------------------+---------+---------------------+-----------------+-----------------+--------------+<br>
1 row in set (0.00 sec)<br>
<br>
Another example for this:<br>
<br>
> > telnet xx.xx.xx.xx 9024<br>
MaxSessionTime Duration=36000 CallId=535fc5df9397086 From=<a
moz-do-not-send="true" href="mailto:sip%3Auser@domain.de">sip:user@domain.de</a>
Gateway=xx.xx.xx.xx To=<a class="moz-txt-link-freetext" href="sip:498003301000@xx.xx.xx.xx:5060;transport=udp">sip:498003301000@xx.xx.xx.xx:5060;transport=udp</a><br>
<br>
type=prepaid<br>
<br>
Callcontrol's config.ini point to the right cdrtool host.<br>
<br>
Any idea?<br>
<br>
Regards,<br>
Philipp<br>
</blockquote>
</div>
<br>
If you have a look at the cdrs in cdrtool, all fields are filled
correctly? Like canonical uri, etc.<br>
Can you paste an example event from radacct?<br>
<br>
-Laszlo<br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>