"acctupdatetime" missing in the radacct table; accounting failure

Suketu Soni 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.

Suketu Soni

More information about the Freeradius-Users mailing list