"acctupdatetime" missing in the radacct table; accounting failure
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
On May 25, 2019, at 3:36 AM, Suketu Soni <suketusoni@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.
Thanks, Alan. Added two fields in the 'radacct'. The server is sending Accounting-Response now. -- Suketu Soni ________________________________ From: Freeradius-Users <freeradius-users-bounces+suketusoni=hotmail.com@lists.freeradius.org> on behalf of Alan DeKok <aland@deployingradius.com> Sent: Saturday, May 25, 2019 12:50 PM To: FreeRadius users mailing list Subject: Re: "acctupdatetime" missing in the radacct table; accounting failure On May 25, 2019, at 3:36 AM, Suketu Soni <suketusoni@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. - List info/subscribe/unsubscribe? See https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.freeradius.org%2Flist%2Fusers.html&data=02%7C01%7C%7C0f8cc4150824481e412808d6e10ff3b0%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636943855965219240&sdata=NbEsuh5MdEC3vc6TKKipufWaep1l6ZZUY2P1Y917zmE%3D&reserved=0
participants (2)
-
Alan DeKok -
Suketu Soni