"acctupdatetime" missing in the radacct table; accounting failure

[Suketu Soni]

Hello,

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.

--
Suketu Soni