<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>
This is all just basic setup. I don't know your exact setup, I
can only guess. <br>
<br>
You see it <span class="" style="white-space:pre"></span>FROM_UNIXTIME(),
is empty , so that won't work. You have to find out why the
event-timestamp attribute is now empty. To give you any hints,
what is in the detail file, and in which format, is the attribute
only defined once in the dictionaries?<br>
<br>
As a side note, if you are using Debian, we have freeradius-xs
package for sqeeuze and sid which is preconfigured with all these
things.<br>
<br>
<pre class="moz-signature" cols="72">--
Tijmen de Mes
AG Projects</pre>
<br>
On 03/25/2013 02:51 PM, Willian Mazzardo - SYSSVOIP wrote:<br>
</div>
<blockquote
cite="mid:CAL2ykgHDQCsBmQmZr+2ym6y754ux=BqxkJBOjT=WSnMi0iGD0g@mail.gmail.com"
type="cite">
<div dir="ltr">Ok .. changed and freeradius is UP.
<div><br>
</div>
<div style="">But, when I do some call, this is the trace:</div>
<div style=""><br>
</div>
<div style="">
<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-20130325">127.0.0.1/detail-20130325</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-20130325">127.0.0.1/detail-20130325</a></div>
<div>[detail] <span class="" style="white-space:pre"> </span>expand:
%t -> Mon Mar 25 10:50:02 2013</div>
<div>++[detail] returns ok</div>
<div>[sql] <span class="" style="white-space:pre"> </span>expand:
<span class="" style="white-space:pre"> </span> CALL
update_radacct_record( 'radius', <span
class="" style="white-space:pre"> </span>FROM_UNIXTIME(%{Event-Timestamp}),
UNIX_TIMESTAMP('%S') - '%{Event-Timestamp}',
'', '%{X-RTP-Stat}', <span
class="" style="white-space:pre"> </span>'%{Acct-Session-Id}',
'%{Sip-To-Tag}',
'%{Sip-From-Tag}' ) -> <span class=""
style="white-space:pre"> </span> CALL
update_radacct_record( 'radius', <span
class="" style="white-space:pre"> </span>FROM_UNIXTIME(),
UNIX_TIMESTAMP('2013-03-25 10:50:02') - '',
'', '', <span class=""
style="white-space:pre"> </span>'<a
moz-do-not-send="true"
href="http://280e1cb527443026017094174eee1d7c@187.53.208.106:5060">280e1cb527443026017094174eee1d7c@187.53.208.106:5060</a>',
'9309094362166693758',
'as18ead01f' )</div>
<div>[sql] <span class="" style="white-space:pre"> </span>expand:
/var/log/freeradius/sqltrace-%Y%m%d.log ->
/var/log/freeradius/sqltrace-20130325.log</div>
<div>rlm_sql (sql): Reserving sql socket id: 13</div>
<div>rlm_sql_mysql: MYSQL check_error: 2006, returning
SQL_DOWN</div>
<div>rlm_sql (sql): Attempting to connect rlm_sql_mysql #13</div>
<div>rlm_sql_mysql: Starting connect to MySQL server for #13</div>
<div>rlm_sql (sql): Connected new DB handle, #13</div>
<div>rlm_sql_mysql: MYSQL check_error: 1582 received</div>
<div>rlm_sql (sql): failed after re-connect</div>
<div>[sql] Couldn't update SQL accounting STOP record -
Incorrect parameter count in the call to native function
'FROM_UNIXTIME'</div>
<div>rlm_sql_mysql: MYSQL check_error: 1582 received</div>
<div>rlm_sql_mysql: Cannot store result</div>
<div>rlm_sql_mysql: MySQL error 'Incorrect parameter count in
the call to native function 'FROM_UNIXTIME''</div>
<div>rlm_sql (sql): Released sql socket id: 13</div>
<div>++[sql] returns fail</div>
<div><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>
</div>
</blockquote>
</body>
</html>