SQL error - Incorrect datetime value

Renato Sousa rensousa at gmail.com
Wed Jul 8 14:30:35 CEST 2015


Hello everyone,

I'm setting up a freeradius server 3.0.8 on FreeBSD 10. I am getting an
error in sql:

(29) sql: Executing 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
('00001A59-00000028', '8698639b48376aea32f23dc9a7989089', 'myuser',
'DEFAULT', '172.19.13.15', '0', 'Wireless-802.11', 1436344658, 1436344658,
NULL, '0', 'RADIUS', 'CONNECT 0Mbps 802.11b', '', '0', '0',
'2A-A4-3C-B2-FB-AD:mySSID', '34-BB-26-C2-1D-60', '', '', '', '')
(29) sql: ERROR: rlm_sql_mysql: ERROR 1292 (Incorrect datetime value:
'1436344658' for column 'acctstarttime' at row 1): 22007


I created the database using the mysql (version 5.6.24)  schema.sql file
provided on freeradius.
The problem is in mysql or freeradius?

Regards,

Renato


More information about the Freeradius-Users mailing list