Re: [Daloradius-users] HELP: Unknown column 'acctupdatetime' in 'field list'

[sbb2019 <sb...@pr...>]

You can add that directly in the SQL database.

Sent with [ProtonMail](https://protonmail.com) Secure Email.

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Saturday, August 15, 2020 1:09 PM, Bruno Duarte <nuc...@ho...> wrote:

> Hi all,
>
> I am new to FreeRadius + MySQL. I have just installed DaloRADIUS in my server and it seems to be working quite well, except for the Accounting Part.
>
> Authentication is Ok, I can get Access-Accept messages from the server, but with Accounting I am getting the following error when running freeradius in debug mode:
>
> (4) sql: ERROR: rlm_sql_mysql: ERROR 1054 (Unknown column 'acctupdatetime' in 'field list'): 42S22
> (4) sql: SQL query returned: server error
> rlm_sql (sql): Released connection (5)
>
> I have already tried to check the schema.sql file, and this column is present in the radacct table, so I don't understand why the query is failing:
>
> CREATE TABLE radacct (
> ...
> acctupdatetime datetime NULL default NULL,
> ...
>
> Can someone give me an hint here?
>
> Thanks in advance.