On 6 Aug 2012, at 06:47, Alan DeKok <aland@DEPLOYINGRADIUS.COM> wrote:
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.
Can you do a Git pull and verify the problem still exists? I fixed this a couple of weeks ago… -Arran