Hi,
This is all just basic setup. I don't know your exact setup, I can only
guess.
You see it 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?
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.
--
Tijmen de Mes
AG Projects
On 03/25/2013 02:51 PM, Willian Mazzardo - SYSSVOIP wrote:
Ok .. changed and freeradius is UP.
But, when I do some call, this is the trace:
[detail] expand:
/var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d ->
/var/log/freeradius/radacct/127.0.0.1/detail-20130325
<http://127.0.0.1/detail-20130325>
[detail]
/var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands
to /var/log/freeradius/radacct/127.0.0.1/detail-20130325
<http://127.0.0.1/detail-20130325>
[detail] expand: %t -> Mon Mar 25 10:50:02 2013
++[detail] returns ok
[sql] expand: CALL update_radacct_record( 'radius',
FROM_UNIXTIME(%{Event-Timestamp}),
UNIX_TIMESTAMP('%S') - '%{Event-Timestamp}', '',
'%{X-RTP-Stat}', '%{Acct-Session-Id}',
'%{Sip-To-Tag}', '%{Sip-From-Tag}' ) -> CALL
update_radacct_record( 'radius', FROM_UNIXTIME(),
UNIX_TIMESTAMP('2013-03-25 10:50:02') - '',
'', '',
'[email protected]:5060
<http://[email protected]:5060>',
'9309094362166693758', 'as18ead01f' )
[sql] expand: /var/log/freeradius/sqltrace-%Y%m%d.log ->
/var/log/freeradius/sqltrace-20130325.log
rlm_sql (sql): Reserving sql socket id: 13
rlm_sql_mysql: MYSQL check_error: 2006, returning SQL_DOWN
rlm_sql (sql): Attempting to connect rlm_sql_mysql #13
rlm_sql_mysql: Starting connect to MySQL server for #13
rlm_sql (sql): Connected new DB handle, #13
rlm_sql_mysql: MYSQL check_error: 1582 received
rlm_sql (sql): failed after re-connect
[sql] Couldn't update SQL accounting STOP record - Incorrect parameter
count in the call to native function 'FROM_UNIXTIME'
rlm_sql_mysql: MYSQL check_error: 1582 received
rlm_sql_mysql: Cannot store result
rlm_sql_mysql: MySQL error 'Incorrect parameter count in the call to
native function 'FROM_UNIXTIME''
rlm_sql (sql): Released sql socket id: 13
++[sql] returns fail
Willian Mazzardo
Depto TI - SYSSVOIP
www.syssvoip.com.br <http://www.syssvoip.com.br>
55 3537 2030
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
