After the database migration, I can not log in under my accounts.

[Mk51]

Hello.

Actually, the problem. My zabbix server does automatic database backups every day. I decided to move to another virtual machine, the necessary packages are installed. Clean zabbix works.
We migrate.

1. phpmyadmin dropped all tables.
2. Create mysql user for backup and restore. This is my personal need.

create user backup@localhost identified by 'readonly';
grant all privileges on *.* to backup@localhost;
flush privileges;
quit

3. Copy old database to new zabbix, and wait...some several tens of minutes...

gunzip < /root/zabbixDB.sql.gz | mysql -u backup -preadonly zabbixDB

4.

systemctl restart zabbix-server

5. Error message that the database (5ххххххххх many numbers) is old and does not fit the new zabbix version. However, the database itself was updated and the page opened. I didn't do anything myself.
6. Ok lets restart OS
7. I can't log into my accounts. Attempts to restore access by resetting passwords and changing the default authentication did not bring results. Incorrect username or password or account temporarily suspended.

mysql -u root -p
use zabbixDB
update zabbixDB.config set authentication_type='0' where configid='1';
update zabbixDB.users set passwd=md5('zabbix') where userid='1';
exit
systemctl restart zabbix-server

Any advice?

With respect.

[Mk51]

So
https://bestmonitoringtools.com/upgr...atest-version/

Its works.

I do not understand why it did not work the first time, but my actions are identical. The fact is that the database does not take up much data. 872.0 МБ 11 000 000 strings.

If I try to view all 24 graphs for 1 day for 1 device, the RAM is full and the php8.1-fpm crashes. 2GB RAM 2Core 1gb swap
I don't understand why, why the old server on php7.4-fpm runs smoothly. Same VMs

[tim.mooney]

If I try to view all 24 graphs for 1 day for 1 device, the RAM is full and the php8.1-fpm crashes. 2GB RAM 2Core 1gb swap
I don't understand why, why the old server on php7.4-fpm runs smoothly. Same VMs

You don't say what version of Zabbix you're trying to use in either of your posts, but are you sure PHP 8.1 is supported for the version of Zabbix you're trying to use?

When I look at the software requirements for the Zabbix 6.0.x front end, it still tells me that PHP 8 is not supported. Perhaps that's not clear, but that also means PHP 8.1 is not supported either.

[Mk51]

You don't say what version of Zabbix you're trying to use in either of your posts, but are you sure PHP 8.1 is supported for the version of Zabbix you're trying to use?

When I look at the software requirements for the Zabbix 6.0.x front end, it still tells me that PHP 8 is not supported. Perhaps that's not clear, but that also means PHP 8.1 is not supported either.

Sorry, I have php 8.1-fpm and Zabbix 6.2.0beta2

My level of Linux use is "install according to instructions from the Internet", so when I installed with commands, I was not at all stopped by the fact that I did not look at the recommended "maximum" requirements. And you are right, PHP 8.0 is not supported. I will try reinstalling an older version of php.

Thanks for the advice.

[Mk51]

PHP 8 is not supported.

Bingo, zabbix 6 and php7.4 are working fine. The database is updated automatically, you just need to clear all cookies and the problem with logging in will disappear.

Migrated successfully.

Thanks.