Accounting mysql

[nicolas.clo at ricoh-industrie.fr]

 Yes sorry Alan, I realized too late that problem come from my nas which doesn't send by default
 Event-TimeStamp (55).
 Thanks.




On Sep 2, 2015, at 2:54 AM, nicolas.clo at ricoh-industrie.fr wrote:
> I have a problem to log accounting informations to mysql,
>
> rlm_sql_mysql: ERROR 1582 (Incorrect parameter count in the call to native function
> 'FROM_UNIXTIME'): 42000
>
> It seems to be that Freeradius can't retrieve "integer:Event-Timestamp" value.

  Because it isn't in the packet.

> FreeRADIUS Version 3.0.10 (git #f7065a7), for host i486-pc-linux-gnu, built on Sep  1 2015 at
> 15:39:31 on Debian 7.8
> Mysql 5.5.35
>...

  That isn't the full debug output.  And it's "-Xx", which isn't necessary.

  You can just add the Event-Timestamp if it doesn't already exist:

		 if (!Event-Timestamp) {
		 		 update request {
		 		 		 Event-Timestamp := "%l"
		 		 }
		 }

  Alan DeKok.


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html