"acctupdatetime" missing in the radacct table; accounting failure
suketusoni at hotmail.com
Sat May 25 09:36:33 CEST 2019
This question is for FreeRADIUS Version 3.0.13.
The server is not responding with Accounting-Response, and the debug suggested:
(1) sql: ERROR: rlm_sql_mysql: ERROR 1054 (Unknown column 'acctupdatetime' in 'field list'): 42S22
(1) sql: SQL query returned: server error
The "radacct" table in mysql does not have "acctupdatetime" and "acctinterval". However, the structure for the "radacct" table in "/etc/raddb/mods-config/sql/main/mysql/schema.sql" file does have "AcctUpdateTime" and "AcctInterval".
Can you please advise if these fields should be added in mysql manually and the insert statements for the same?
Thank you very much.
More information about the Freeradius-Users