FR 3 Event-Timestamp wrong format and Mysql FROM_UNIXTIME error

Arran Cudbard-Bell a.cudbardb at freeradius.org
Mon Aug 6 19:23:41 CEST 2012


On 6 Aug 2012, at 06:47, Alan DeKok <aland at 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


More information about the Freeradius-Users mailing list