<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi,<br>
<br>
Please check sql.conf in freeradius. The event timestamp should be
a timeststamp not a datetime.<br>
<br>
What do you have configured there? It should be like
FROM_UNIXTIME(%{Event-Timestamp}), \ <br>
<pre class="moz-signature" cols="72">--
Tijmen de Mes
AG Projects</pre>
On 03/24/2013 06:34 AM, Willian Mazzardo - SYSSVOIP wrote:<br>
</div>
<blockquote
cite="mid:CAL2ykgH6F-mEMq-m8Zyygtv6rVTDSe0og_8Dzu6LWQb0HEiWhg@mail.gmail.com"
type="cite">
<div dir="ltr">I think I have found the problem....
<div><br>
</div>
<div style="">see the log:</div>
<div style=""><br>
</div>
<div style="">
<div>Going to the next request</div>
<div>Ready to process requests.</div>
<div>rad_recv: Accounting-Request packet from host 127.0.0.1
port 45662, id=207, length=327</div>
<div><span class="" style="white-space:pre"> </span>Acct-Status-Type
= Failed</div>
<div><span class="" style="white-space:pre"> </span>Service-Type
= Sip-Session</div>
<div><span class="" style="white-space:pre"> </span>Sip-Response-Code
= 487</div>
<div><span class="" style="white-space:pre"> </span>Sip-Method
= Invite</div>
<div><span class="" style="white-space:pre"> </span>Event-Timestamp
= "Mar 24 2013 02:26:30 BRT"</div>
<div><span class="" style="white-space:pre"> </span>Sip-From-Tag
= "2008462333"</div>
<div><span class="" style="white-space:pre"> </span>Sip-To-Tag
= "as4a8dfb83"</div>
<div><span class="" style="white-space:pre"> </span>Acct-Session-Id
= "411815482"</div>
<div><span class="" style="white-space:pre"> </span>User-Name
= "<a moz-do-not-send="true"
href="mailto:559101999@187.53.208.109">559101999@187.53.208.109</a>"</div>
<div><span class="" style="white-space:pre"> </span>Calling-Station-Id
= "<a moz-do-not-send="true"
href="mailto:sip%3A559101999@187.53.208.109">sip:559101999@187.53.208.109</a>"</div>
<div><span class="" style="white-space:pre"> </span>Called-Station-Id
= "<a moz-do-not-send="true"
href="mailto:sip%3A05596412757@187.53.208.109">sip:05596412757@187.53.208.109</a>"</div>
<div><span class="" style="white-space:pre"> </span>Sip-Translated-Request-URI
= "<a moz-do-not-send="true"
href="mailto:sip%3A555596412757@177.126.178.106">sip:555596412757@177.126.178.106</a>"</div>
<div><span class="" style="white-space:pre"> </span>Canonical-URI
= "<a moz-do-not-send="true"
href="mailto:sip%3A555596412757@187.53.208.109">sip:555596412757@187.53.208.109</a>"</div>
<div><span class="" style="white-space:pre"> </span>User-Agent
= "Linphone/3.5.2 (eXosip2/3.6.0)"</div>
<div><span class="" style="white-space:pre"> </span>Contact =
"<<a moz-do-not-send="true"
href="http://sip:559101999@192.168.10.110:5066">sip:559101999@192.168.10.110:5066</a>>"</div>
<div><span class="" style="white-space:pre"> </span>NAS-Port
= 5060</div>
<div><span class="" style="white-space:pre"> </span>Acct-Delay-Time
= 0</div>
<div><span class="" style="white-space:pre"> </span>NAS-IP-Address
= 127.0.0.1</div>
<div># Executing section preacct from file
/etc/freeradius/radiusd.conf</div>
<div>+- entering group preacct {...}</div>
<div>++[preprocess] returns ok</div>
<div>[suffix] Looking up realm "187.53.208.109" for User-Name
= "<a moz-do-not-send="true"
href="mailto:559101999@187.53.208.109">559101999@187.53.208.109</a>"</div>
<div>[suffix] No such realm "187.53.208.109"</div>
<div>++[suffix] returns noop</div>
<div>++[files] returns noop</div>
<div># Executing section accounting from file
/etc/freeradius/radiusd.conf</div>
<div>+- entering group accounting {...}</div>
<div>[detail] <span class="" style="white-space:pre"> </span>expand:
/var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d
-> /var/log/freeradius/radacct/<a moz-do-not-send="true"
href="http://127.0.0.1/detail-20130324">127.0.0.1/detail-20130324</a></div>
<div>[detail]
/var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d
expands to /var/log/freeradius/radacct/<a
moz-do-not-send="true"
href="http://127.0.0.1/detail-20130324">127.0.0.1/detail-20130324</a></div>
<div>[detail] <span class="" style="white-space:pre"> </span>expand:
%t -> Sun Mar 24 02:26:50 2013</div>
<div>++[detail] returns ok</div>
<div>[sql] WARNING: Unknown module "Sip-Application-Type" in
string expansion "%', '%{User-Agent}',
'%{From-Header}' )"</div>
<div>[sql] <span class="" style="white-space:pre"> </span>expand:
/var/log/freeradius/sqltrace-%Y%m%d.log ->
/var/log/freeradius/sqltrace-20130324.log</div>
<div>rlm_sql (sql): Reserving sql socket id: 22</div>
<div>rlm_sql_mysql: MYSQL check_error: 1064 received</div>
<div>rlm_sql (sql): Couldn't insert SQL accounting FAILED
record - You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the
right syntax to use near '24 2013 02:26:30 BRT),
FROM_UNIXTIME(Mar 24 2013 02:26:30 BRT), ' at line 1</div>
<div>rlm_sql_mysql: MYSQL check_error: 1064 received</div>
<div>rlm_sql_mysql: Cannot store result</div>
<div>rlm_sql_mysql: MySQL error 'You have an error in your SQL
syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near '24 2013
02:26:30 BRT), FROM_UNIXTIME(Mar 24 2013
02:26:30 BRT), ' at line 1'</div>
<div>rlm_sql (sql): Released sql socket id: 22</div>
<div>++[sql] returns fail</div>
<div>Finished request 2.</div>
<div>Cleaning up request 2 ID 207 with timestamp +29</div>
<div>Going to the next request</div>
<div>Ready to process requests.</div>
<div><br>
</div>
<div><br>
</div>
<div style="">I think is a DATE/TIME problem ...</div>
<div style=""><br>
</div>
<div style="">Am I right?</div>
<div style=""><br>
</div>
</div>
</div>
<div class="gmail_extra"><br clear="all">
<div>Willian Mazzardo<br>
Depto TI - SYSSVOIP<br>
<a moz-do-not-send="true" href="http://www.syssvoip.com.br">www.syssvoip.com.br</a><br>
55 3537 2030</div>
<br>
<br>
<div class="gmail_quote">2013/3/23 Willian Mazzardo - SYSSVOIP <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:willian@syssvoip.com.br" target="_blank">willian@syssvoip.com.br</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Hi Tijmen... thanks for your help... I have
installed, but in mysql, the table radacct.201303 is not
creating automatically.
<div><br>
</div>
<div>How can I debug this?</div>
</div>
<div class="gmail_extra">
<br clear="all">
<div>Willian Mazzardo<br>
Depto TI - SYSSVOIP<br>
<a moz-do-not-send="true"
href="http://www.syssvoip.com.br" target="_blank">www.syssvoip.com.br</a><br>
<a moz-do-not-send="true" href="tel:55%203537%202030"
value="+555535372030" target="_blank">55 3537 2030</a></div>
<div>
<div class="h5">
<br>
<br>
<div class="gmail_quote">2013/3/23 Tijmen de Mes <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:tijmen@ag-projects.com"
target="_blank">tijmen@ag-projects.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word">Hi,
<div><br>
</div>
<div>I believe you can find everything you need
in the install guide:</div>
<div><a moz-do-not-send="true"
href="http://cdrtool.ag-projects.com/projects/cdrtool/wiki/Installation_Guide"
target="_blank">http://cdrtool.ag-projects.com/projects/cdrtool/wiki/Installation_Guide</a></div>
<div>
<div><br>
</div>
<div>Best regards,</div>
<div><br>
</div>
<div>--</div>
<div>Tijmen de Mes</div>
<div>AG Projects</div>
</div>
<div><br>
<div>
<div>Op 24 mrt. 2013, om 02:38 heeft Willian
Mazzardo - SYSSVOIP <<a
moz-do-not-send="true"
href="mailto:willian@syssvoip.com.br"
target="_blank">willian@syssvoip.com.br</a>>
het volgende geschreven:</div>
<div>
<div><br>
<blockquote type="cite">
<p dir="ltr">Hi... im sorry intruding
this topic to talk about different,
but, have anyone some tutorial to
install cdrtool in debian with
opensips?</p>
<p dir="ltr">Thanks</p>
<div class="gmail_quote">On Mar 23,
2013 10:31 PM, "Tijmen de Mes" <<a
moz-do-not-send="true"
href="mailto:tijmen@ag-projects.com"
target="_blank">tijmen@ag-projects.com</a>>
wrote:<br type="attribution">
<blockquote class="gmail_quote"
style="margin:0 0 0
.8ex;border-left:1px #ccc
solid;padding-left:1ex">
Hi,<br>
<br>
We had a bug which sneaked in due
to another change and this is
already fixed in trunk and will be
part of the new release.<br>
<br>
The patch is here:<br>
<a moz-do-not-send="true"
href="http://cdrtool.ag-projects.com/projects/cdrtool/repository/revisions/2421"
target="_blank">http://cdrtool.ag-projects.com/projects/cdrtool/repository/revisions/2421</a><br>
<br>
Best regards,<br>
<br>
--<br>
Tijmen de Mes<br>
AG Projects<br>
<br>
Op 24 mrt. 2013, om 00:26 heeft
dotnetdub <<a
moz-do-not-send="true"
href="mailto:dotnetdub@gmail.com"
target="_blank">dotnetdub@gmail.com</a>>
het volgende geschreven:<br>
<br>
> On 23 March 2013 20:52,
Laszlo <<a
moz-do-not-send="true"
href="mailto:laszlo@voipfreak.net"
target="_blank">laszlo@voipfreak.net</a>>
wrote:<br>
>> +1 on this<br>
>><br>
><br>
> We will do our best to
contribute a patch..<br>
><br>
>
_______________________________________________<br>
> Users mailing list<br>
> <a moz-do-not-send="true"
href="mailto:Users@lists.opensips.org"
target="_blank">Users@lists.opensips.org</a><br>
> <a moz-do-not-send="true"
href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users"
target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Users@lists.opensips.org"
target="_blank">Users@lists.opensips.org</a><br>
<a moz-do-not-send="true"
href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users"
target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</blockquote>
</div>
_______________________________________________<br>
Users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Users@lists.opensips.org"
target="_blank">Users@lists.opensips.org</a><br>
<a moz-do-not-send="true"
href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users"
target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</blockquote>
</div>
</div>
</div>
<br>
</div>
</div>
<br>
_______________________________________________<br>
Users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Users@lists.opensips.org"
target="_blank">Users@lists.opensips.org</a><br>
<a moz-do-not-send="true"
href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users"
target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
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>
</body>
</html>