Radius sql_session_start Error Freeradius Version 3.0
path to edit = /etc/freeradius/3.0/policy.d/accounting
line number = 95-98
error_encountered after making changes = attr_filter.access_reject: Matched entry DEFAULT at line 11 (3) [attr_filter.access_reject] = updated (3) [eap] = noop (3) policy remove_reply_message_if_eap { (3) if (&reply:EAP-Message && &reply:Reply-Message) { (3) if (&reply:EAP-Message && &reply:Reply-Message) -> FALSE (3) else { (3) [noop] = noop (3) } # else = noop (3) } # policy remove_reply_message_if_eap = noop
------------ Actual error is at the top of the above and will be highlighted in red as follows ---------------
(4) 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('', '3e7211075968e6eba26469a20816dff0', 'admin', '', '127.0.1.1', NULLIF('1812', ''), '', FROM_UNIXTIME(1653722857), NULL, NULL, 0, '', '', NULL, 0, 0, '', '', NULL, '', NULL, '', '', '', '', '') (4) sql: ERROR: rlm_sql_mysql: ERROR 1048 (Column 'acctterminatecause' cannot be null): 23000
Accept-Reject reply instead of Access-Accept on correct authentication
Just update the table by the name of 'acctterminatecause' with the following sql command
Solution -
ALTER TABLE `radacct` CHANGE `acctterminatecause` `acctterminatecause` VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL;