radius accounting not starting....

Somanath Mishra somanath.mishra at planetsbrain.com
Sun Mar 17 15:12:00 CET 2019


On Sun, March 17, 2019 7:25 pm, Matthew Newton wrote:
> On Sun, 2019-03-17 at 12:35 +0530, Somanath Mishra wrote:
>
>> '%{NAS-Port-Type}', \
>> FROM_UNIXTIME(%{integer:Event
>> -Timestamp}),
>> \
>> FROM_UNIXTIME(%{integer:Event
>> -Timestamp}),
>> \
>>
>
> ...
>
>
>> servicetype, framedprotocol, framedipaddress) VALUES
>> ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-
>> Name}',
>> '%{Realm}', '%{NAS-IP-Address}', '%{%{NAS-Port-ID}:-%{NAS-Port}}',
>> '%{NAS-Port-Type}', %{%{integer:Event-Timestamp}:-date('now')},
>> %{%{integer:Event-Timestamp}:-date('now')}, NULL, '0',
>>
>
> You need to find out what config file FreeRADIUS is actually using,
> because it's not using the one you quoted above. The query is different.
>
> --
> Matthew




so i did fresh installation of V3.0.18 from docker hub....

still have same issue "Incorrect datetime value: '1552831358' for column
'acctstarttime' at row 1" error..

Here are Logs:

freeradius    | (6) sql:    --> 98789@@TM11
freeradius    | (6) sql: SQL-User-Name set to '98789@@TM11'
freeradius    | (6) 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, framedipv6address,
framedipv6prefix, framedinterfaceid, delegatedipv6prefix) VALUES
('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}',
'%{Realm}', '%{NAS-IP-Address}', '%{%{NAS-Port-ID}:-%{NAS-Port}}',
'%{NAS-Port-Type}', %{%{integer:Event-Timestamp}:-date('now')},
%{%{integer:Event-Timestamp}:-date('now')}, NULL, '0',
'%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0',
'%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}',
'%{Framed-Protocol}', '%{Framed-IP-Address}', '%{Framed-IPv6-Address}',
'%{Framed-IPv6-Prefix}', '%{Framed-Interface-Id}',
'%{Delegated-IPv6-Prefix}')
freeradius    | (6) sql:    --> 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, framedipv6address,
framedipv6prefix, framedinterfaceid, delegatedipv6prefix) VALUES
('1801000A-000B2EFA', 'a7b6b2a2756c0cca834f46639edde9bf', '98789@@TM11',
'', '192.168.0.4', '0', 'Wireless-802.11', 1552831358, 1552831358, 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    | (6) 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, framedipv6address,
framedipv6prefix, framedinterfaceid, delegatedipv6prefix) VALUES
('1801000A-000B2EFA', 'a7b6b2a2756c0cca834f46639edde9bf', '98789@@TM11',
'', '192.168.0.4', '0', 'Wireless-802.11', 1552831358, 1552831358, 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    | (6) sql: ERROR: rlm_sql_mysql: ERROR 1292 (Incorrect
datetime value: '1552831358' for column 'acctstarttime' at row 1): 22007
freeradius    | (6) sql: SQL query returned: server error
freeradius    | rlm_sql (sql): Released connection (10)
freeradius    | Need 6 more connections to reach 10 spares
freeradius    | rlm_sql (sql): Opening additional connection (14), 1 of 28
pending slots used
freeradius    | rlm_sql_mysql: Starting connect to MySQL server
freeradius    | rlm_sql_mysql: Connected to database 'radius' on
172.25.0.100 via TCP/IP, server version 5.7.25, protocol version 10
freeradius    | (6)     [sql] = fail
freeradius    | (6)   } # accounting = fail
freeradius    | (6) Not sending reply to client.
freeradius    | (6) Finished request
freeradius    | (6) Cleaning up request packet ID 99 with timestamp +172
freeradius    | Waking up in 0.9 seconds.
freeradius    | (3) Cleaning up request packet ID 97 with timestamp +168
freeradius    | Ready to process requests



and in queries.conf file we have :

 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-ID}:-%{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}', \
                                        '%{Framed-IPv6-Address}', \
                                        '%{Framed-IPv6-Prefix}', \
                                        '%{Framed-Interface-Id}', \
                                        '%{Delegated-IPv6-Prefix}')"




still have confusion why it is throwing error????please help...Is there
any issue with docker hub freeradius server files???



More information about the Freeradius-Users mailing list