Re: Accounting mysql

2 Sep 2015

      On Sep 2, 2015, at 2:54 AM, nicolas.clo@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.