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

2012-08-06 Thread Arran Cudbard-Bell
On 6 Aug 2012, at 23:05, "lscrlstld" 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 numbe

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

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
> 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