Accounting mysql

[Alan DeKok]

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.