FR 3 Event-Timestamp wrong format and Mysql FROM_UNIXTIME error

Alan DeKok aland at
Mon Aug 6 07:47:59 CEST 2012

lscrlstld wrote:
> I´m making initial tests with FR 3 (from git) using default configs with
> mysql db, but have mysql error.
> Debug info:
> rlm_sql_mysql: MySQL error 'You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right syntax to
> use near '5 2012 23:25:16 BRT),             acctupdatetime  =
> FROM_UNIXTIME(Aug  5 2012 23:25:16 BRT)' at line 1'
> rlm_sql (sql): Released connection (4)

  What are the lines BEFORE that?

> The %{Event-Timestamp} used in query have a wrong date/time format, it is
> not the timestamp.

  Yes.  That's why the "master" branch uses %{integer:Event-Timestamp},
which causes the timestamp to be printed as a Unix 32-bit number.

> Is it a dependency of OS setup? How this variable (Event-Timestamp) is
> generated? 

  The default config should work.

  Alan DeKok.

More information about the Freeradius-Users mailing list