SQL statement execution has failed - after reinstall version 5.4.4 - Debian 11

[RogerCWB]

Hi,

I reinstalled Zabbix on a new server, version 5.4.4, but now when I try to login I get the message below on the login screen:

SQL statement execution has failed "INSERT INTO auditlog (userid,clock,ip,action,resourcetype,note,auditid) VALUES ('3','1631722627','10.51.10.191','3','0','' ,'1')".



Any tips?

[Atsushi]

The user you are using to connect to the database probably does not have update permissions to the database. Check the account you are using to connect and its permissions.

[RogerCWB]

The user you are using to connect to the database probably does not have update permissions to the database. Check the account you are using to connect and its permissions.

Hi,

When I tried:
grant all privileges on zabbix.* to zabbix@localhost;

I receive the error: Can't find any matching row in the user table

Then I tried:
create user zabbix@localhost identified by 'password';

Then tried again grant all privileges, same error but now the users table is like that:

+--------------+
| User |
+--------------+
| zabbix |
| usvn |
| mariadb.sys |
| root |
| zabbix |
+--------------+

What is strange is the Database are on another server and I didn't change the rights of user zabbix.

EDIT:

The command is a little different on MariaDB

grant all privileges on zabbix.* to 'zabbix'@'localhost';
Query OK, 0 rows affected (0.006 sec)

Now worked, but same error, I can't login even with guest account.

EDIT PART2
I tried the command directly on MYSQL but looks like one field is missing from the table.

INSERT INTO auditlog (userid,clock,ip,action,resourcetype,note,auditid) VALUES ('3','1631830087','10.51.10.191','3','0','','1');
ERROR 1054 (42S22): Unknown column 'note' in 'field list'

[Atsushi]

Did you recreate the database? If you don't have column notes, it's not a database for Zabbix 5.4. Please recreate the database using the SQL statement for Zabbix 5.4.

[RogerCWB]

Did you recreate the database? If you don't have column notes, it's not a database for Zabbix 5.4. Please recreate the database using the SQL statement for Zabbix 5.4.

If I recreate the database I will lost the data isn't?

I installed it but I'm using the same database, I have 2 years of data.

[Atsushi]

Did you upgrade from an older version? Did you manually change the database after upgrading? If you have made any changes, restore them from your backup.
When the new version of Zabbix server starts, the database will be automatically upgraded. Please access from the new version of the web frontend after the upgrade process is complete.

[RogerCWB]

Did you upgrade from an older version? Did you manually change the database after upgrading? If you have made any changes, restore them from your backup.
When the new version of Zabbix server starts, the database will be automatically upgraded. Please access from the new version of the web frontend after the upgrade process is complete.

Thank you!

It worked, I lost a few months of data but it's better than losing everything.