On Mar 15, 2019, at 10:55 AM, Somanath Mishra <somanath.mishra@planetsbrain.com> wrote:
Many thanks for the suggestion.after modified radius IP in controller it worked. but still not getting data in radaact table.showing error like "Incorrect datetime value: '1552660521' for column 'acctstarttime' at row 1". Please help.
here are the logs:
freeradius | (0) Received Access-Request Id 169 from 192.168.0.4:47212 to 172.25.0.101:1812 length 182
Please just post the output of "radiusd -X". There's no need to add a "freeradius | " header to every line. That makes it harder to read. And only post the *relevant* logs. If you have a question about accounting, you don't need to post authentication requests.
freeradius | (1) 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 ('1801000A-0001122B', 'd99b6270bc08322e50fc1284c175858d', '12378@@TM11', '', '192.168.0.4', '0', 'Wireless-802.11', 1552660517, 1552660517, NULL, '0', 'RADIUS', 'CONNECT Unknown Radio', '', '0', '0', '00:0c:29:67:6d:ec', '9c:4e:36:9c:71:18', '', '', '', '10.0.1.24') freeradius | (1) sql: ERROR: rlm_sql_mysql: ERROR 1292 (Incorrect datetime value: '1552660517' for column 'acctstarttime' at row 1): 22007
You're either running a very old version of FreeRADIUS, or you edited the MySQL queries and broke them. The default configuration in v3 (mods-config/sql/main/mysql/queries.conf) contains: ... AcctStartTime = FROM_UNIXTIME(%{integer:Event-Timestamp}), \ ... Which works. Use the standard queries that come with FreeRADIUS. Alan DeKok.