SQL error - Incorrect datetime value

[Renato Sousa]

 Hello Alan,

I checked the file
/usr/local/etc/raddb/mods-config/sql/main/mysql/queries.conf and contains
FROM_UNIXTIME () functions.
The file keeps the default installation settings.


start {
                        #
                        #  Insert a new record into the sessions table
                        #
                        query = "\
                                INSERT INTO ${....acct_table1} \
                                        (${...column_list}) \
                                VALUES \
                                        ('%{Acct-Session-Id}', \
                                        '%{Acct-Unique-Session-Id}', \
                                        '%{SQL-User-Name}', \
                                        '%{Realm}', \
                                        '%{NAS-IP-Address}', \
                                        '%{NAS-Port}', \
                                        '%{NAS-Port-Type}', \

*FROM_UNIXTIME*(%{integer:Event-Timestamp}),
\
                                       *
FROM_UNIXTIME*(%{integer:Event-Timestamp}),
\
                                        NULL, \
                                        '0', \
                                        '%{Acct-Authentic}', \
                                        '%{Connect-Info}', \
                                        '', \
                                        '0', \
                                        '0', \
                                        '%{Called-Station-Id}', \
                                        '%{Calling-Station-Id}', \
                                        '', \
                                        '%{Service-Type}', \
                                        '%{Framed-Protocol}', \
                                        '%{Framed-IP-Address}')"

Why freeradius does not perform the function in the query?

Bet Regards,

Renato

2015-07-08 9:38 GMT-03:00 Alan DeKok <aland at deployingradius.com>:

> On Jul 8, 2015, at 8:30 AM, Renato Sousa <rensousa at gmail.com> wrote:
> > I'm setting up a freeradius server 3.0.8 on FreeBSD 10. I am getting an
> > error in sql:
>
>   You're using the wrong queries.  All of the times should have
> FROM_UNIXTIME(...).
>
>   This is what's in the v3.0.x branch.
>
>   Alan DeKok.
>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html