"acctupdatetime" missing in the radacct table; accounting failure

Alan DeKok aland at deployingradius.com
Sat May 25 14:50:55 CEST 2019

On May 25, 2019, at 3:36 AM, Suketu Soni <suketusoni at hotmail.com> wrote:
> 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?

  You can just add the fields manually.  There is no need to change the insert statements.

  Alan DeKok.

More information about the Freeradius-Users mailing list