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

[Bruno D. <nuc...@ho...>]

Hi,
Thanks for your response.

Can you provide me the command to add that please?

Thanks a lot.
________________________________
From: sbb2019 <sb...@pr...>
Sent: Saturday, August 15, 2020 7:39:55 PM
To: Bruno Duarte <nuc...@ho...>
Cc: dal...@li... <dal...@li...>
Subject: Re: [Daloradius-users] HELP: Unknown column 'acctupdatetime' in 'field list'

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.