Re: RES: FR 3 Event-Timestamp wrong format and Mysql FROM_UNIXTIME error

2012-08-07 Thread Arran Cudbard-Bell
On 6 Aug 2012, at 23:05, lscrlstld lscrls...@gmail.com wrote: 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.

RES: FR 3 Event-Timestamp wrong format and Mysql FROM_UNIXTIME error

2012-08-06 Thread lscrlstld
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

Re: RES: FR 3 Event-Timestamp wrong format and Mysql FROM_UNIXTIME error

2012-08-06 Thread Alan DeKok
lscrlstld wrote: '%{NAS-Port-Type}', FROM_UNIXTIME(%{Event-Timestamp}), Well, that's wrong. That was fixed ~2 weeks ago. I also said it should be %{integer:Event-Timestamp} Please grab an updated copy of the dialup.conf file. Alan DeKok. - List info/subscribe/unsubscribe?

RES: FR 3 Event-Timestamp wrong format and Mysql FROM_UNIXTIME error

2012-08-06 Thread lscrlstld
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