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?
(2) sql : Creating session using 'accounting_start_query' (2) sql : expand: INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctupdatetime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', FROM_UNIXTIME(%{Event-Timestamp}), FROM_UNIXTIME(%{Event-Timestamp}), NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}') -> INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctupdatetime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress) VALUES ('00000004501F2B13', '58b529eb9a3fbf276615adc21fcc781a', 'usertest', '', '172.31.250.96', '4', '', FROM_UNIXTIME(Aug 5 2012 23:25:16 BRT), FROM_UNIXTIME(Aug 5 2012 23:25:16 BRT), NULL, '0', '', '', '', '0', '0', '200.2XX.2XX.XXX', 'usertest', '', 'Framed-User', '', '10.13.10.1') (2) sql : expand: /var/log/freeradius/sqltrace.sql -> /var/log/freeradius/sqltrace.sql rlm_sql (sql): Reserved connection (4) rlm_sql (sql): Executing query rlm_sql_mysql: query: INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctupdatetime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress) VALUES ('00000004501F2B13', '58b529eb9a3fbf276615adc21fcc781a', 'usertest', '', '172.31.250.96', '4', '', FROM_UNIXTIME(Aug 5 2012 23:25:16 BRT), FROM_UNIXTIME(Aug 5 2012 23:25:16 BRT), NULL, '0', '', '', '', '0', '0', '200.2XX.2XX.XXX', 'usertest', '', 'Framed-User', '', '10.13.10.1') rlm_sql_mysql: MYSQL check_error: 1064 received rlm_sql (sql): Database query 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), FROM_UNIXTIME(Aug 5 2012 23:25:16 BRT), NULL, '0', ''' at line 1' in query ' INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctupdatetime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress) VALUES ('00000004501F2B13', '58b529eb9a3fbf276615adc21fcc781a', 'usertest', '', '172.31.250.96', '4', '', FROM_UNIXTIME(Aug 5 2012 23:25:16 BRT), FROM_UNIXTIME(Aug 5 2012 23:25:16 BRT), NULL, '0', '', '', '', '0', '0', '200.2XX.2XX.XXX', 'usertest', '', 'Framed-User', '', '10.13.10.1')' rlm_sql_mysql: MYSQL check_error: 1064 received rlm_sql_mysql: Cannot store result 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), FROM_UNIXTIME(Aug 5 2012 23:25:16 BRT), NULL, '0', ''' at line 1' (2) sql : Failed creating session, updating session using 'accounting_start_query_alt' (2) sql : expand: UPDATE radacct SET acctstarttime = FROM_UNIXTIME(%{Event-Timestamp}), acctupdatetime = FROM_UNIXTIME(%{Event-Timestamp}), connectinfo_start = '%{Connect-Info}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}' -> UPDATE radacct SET acctstarttime = FROM_UNIXTIME(Aug 5 2012 23:25:16 BRT), acctupdatetime = FROM_UNIXTIME(Aug 5 2012 23:25:16 BRT), connectinfo_start = '' WHERE acctsessionid = '00000004501F2B13' AND username = 'usertest' AND nasipaddress = '172.31.250.96' (2) sql : expand: /var/log/freeradius/sqltrace.sql -> /var/log/freeradius/sqltrace.sql rlm_sql (sql): Executing query rlm_sql_mysql: query: UPDATE radacct SET acctstarttime = FROM_UNIXTIME(Aug 5 2012 23:25:16 BRT), acctupdatetime = FROM_UNIXTIME(Aug 5 2012 23:25:16 BRT), connectinfo_start = '' WHERE acctsessionid = '00000004501F2B13' AND username = 'usertest' AND nasipaddress = '172.31.250.96' rlm_sql_mysql: MYSQL check_error: 1064 received rlm_sql (sql): Database query 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' in query ' UPDATE radacct SET acctstarttime = FROM_UNIXTIME(Aug 5 2012 23:25:16 BRT), acctupdatetime = FROM_UNIXTIME(Aug 5 2012 23:25:16 BRT), connectinfo_start = '' WHERE acctsessionid = '00000004501F2B13' AND username = 'usertest' AND nasipaddress = '172.31.250.96'' rlm_sql_mysql: MYSQL check_error: 1064 received rlm_sql_mysql: Cannot store result 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) (2) [sql] = fail (2) Finished request 2. Waking up in 0.3 seconds.
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.
I´m using all default. For some reason the Event-Timestamp have the wrong format, I can see it in the sqltrace.sql too.