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@deployingradius.com>:
On Jul 8, 2015, at 8:30 AM, Renato Sousa <rensousa@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