<div dir="ltr">I have debian and installed freeradius-xs package ... <div><br></div><div style>But the error persist...</div><div style><br></div><div><br></div></div><div class="gmail_extra"><br clear="all"><div>Willian Mazzardo<br>
Depto TI - SYSSVOIP<br><a href="http://www.syssvoip.com.br">www.syssvoip.com.br</a><br>55 3537 2030</div>
<br><br><div class="gmail_quote">2013/3/25 Tijmen de Mes <span dir="ltr"><<a 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 bgcolor="#FFFFFF" text="#000000">
<div>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 style="white-space:pre-wrap"></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.<div class="im"><br>
<br>
<pre cols="72">--
Tijmen de Mes
AG Projects</pre>
<br></div><div><div class="h5">
On 03/25/2013 02:51 PM, Willian Mazzardo - SYSSVOIP wrote:<br>
</div></div></div><div><div class="h5">
<blockquote type="cite">
<div dir="ltr">Ok .. changed and freeradius is UP.
<div><br>
</div>
<div>But, when I do some call, this is the trace:</div>
<div><br>
</div>
<div>
<div>[detail] <span style="white-space:pre-wrap"> </span>expand:
/var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d
-> /var/log/freeradius/radacct/<a href="http://127.0.0.1/detail-20130325" target="_blank">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 href="http://127.0.0.1/detail-20130325" target="_blank">127.0.0.1/detail-20130325</a></div>
<div>[detail] <span style="white-space:pre-wrap"> </span>expand:
%t -> Mon Mar 25 10:50:02 2013</div>
<div>++[detail] returns ok</div>
<div>[sql] <span style="white-space:pre-wrap"> </span>expand:
<span style="white-space:pre-wrap"> </span> CALL
update_radacct_record( 'radius', <span style="white-space:pre-wrap"> </span>FROM_UNIXTIME(%{Event-Timestamp}),
UNIX_TIMESTAMP('%S') - '%{Event-Timestamp}',
'', '%{X-RTP-Stat}', <span style="white-space:pre-wrap"> </span>'%{Acct-Session-Id}',
'%{Sip-To-Tag}',
'%{Sip-From-Tag}' ) -> <span style="white-space:pre-wrap"> </span> CALL
update_radacct_record( 'radius', <span style="white-space:pre-wrap"> </span>FROM_UNIXTIME(),
UNIX_TIMESTAMP('2013-03-25 10:50:02') - '',
'', '', <span style="white-space:pre-wrap"> </span>'<a href="http://280e1cb527443026017094174eee1d7c@187.53.208.106:5060" target="_blank">280e1cb527443026017094174eee1d7c@187.53.208.106:5060</a>',
'9309094362166693758',
'as18ead01f' )</div>
<div>[sql] <span style="white-space:pre-wrap"> </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 href="http://www.syssvoip.com.br" target="_blank">www.syssvoip.com.br</a><br>
<a href="tel:55%203537%202030" value="+555535372030" target="_blank">55 3537 2030</a></div>
<br>
</div>
</blockquote>
</div></div></div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a 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>