Ad Widget

**Markku** · 07-11-2022, 21:58

19-zcat /usr/share/zabbix-sql-scripts/mysql/server.sql.gz | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix

You already imported your old database before that, don't try to import the Zabbix default schema anymore.

Also, don't try to use the GUI before the database has been upgraded, so start the new Zabbix server first, let it update the database, then go to GUI.

Markku

**superlava** · 08-11-2022, 11:55

Originally posted by Qais

Hi Dears

first I am not a Linux expert

I have Zabbix 5.0.17 installed on Centos 7

Since no more Centos so I am trying to migrate Zabbix5.0.17 to ubuntu22.04.1 Zabbix 6.2

The Procedure I tried and Failed with it

1- Prepared new fresh ubuntu22.04.1
--------------------------------preparing the platform

2- apt install apache2 php php-mysql php-mysqlnd php-ldap php-bcmath php-mbstring php-gd php-pdo php-xml libapache2-mod-php
3- apt install mariadb-server mariadb-client
4- systemctl start apache2
5-systemctl enable apache
6-systemctl start MariaDB

---------------------------------preparing the DB
7-mysql_secure_installation
-----------------------------------------------------------
8-mysql -uroot -p
9- create database zabbix character set utf8mb4 collate utf8mb4_bin;
10-create user user@localhost IDENTIFIED by 'userpassword';
11-grant all privileges on zabbix.* TO user@localhost;
12-flush privileges;
13-quit;

-----------------putting the mysqldump to run on the new server
14-mysql -u root -p zabbix < /home/BACKUP/zabbix.sql

-----------------------installing zabbix server
15-wget https://repo.zabbix.com/zabbix/6.2/u...u22.04_all.deb

16-dpkg -i zabbix-release_6.2-2+ubuntu22.04_all.deb
17-apt update
18-apt install zabbix-server-mysql zabbix-frontend-php zabbix-apache-conf zabbix-sql-scripts zabbix-agent
19-zcat /usr/share/zabbix-sql-scripts/mysql/server.sql.gz | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix

after that I logged in GUI in Database connection configuration I have this error

The Zabbix database version does not match current requirements. Your database version: 5000000. Required version: 6020000. Please contact your system administrator.

zabbix Log file

2369:20221107:171742.313 using configuration file: /etc/zabbix/zabbix_server.conf
2369:20221107:171742.365 cannot use database "zabbix": its "users" table is empty (is this the Zabbix proxy database?)
2372:20221107:171754.574 Starting Zabbix Server. Zabbix 6.2.4 (revision 885eaefa6f7).
2372:20221107:171754.574 ****** Enabled features ******
2372:20221107:171754.574 SNMP monitoring: YES
2372:20221107:171754.574 IPMI monitoring: YES
2372:20221107:171754.574 Web monitoring: YES
2372:20221107:171754.574 VMware monitoring: YES
2372:20221107:171754.574 SMTP authentication: YES
2372:20221107:171754.574 ODBC: YES
2372:20221107:171754.574 SSH support: YES
2372:20221107:171754.574 IPv6 support: YES
2372:20221107:171754.574 TLS support: YES
2372:20221107:171754.574 ******************************
2372:20221107:171754.574 using configuration file: /etc/zabbix/zabbix_server.conf
2372:20221107:171754.673 cannot use database "zabbix": its "users" table is empty (is this the Zabbix proxy database?)

Please could help me with this

Thanks

Migrating to Rocky Linux or Alma Linux would be recommended here as both are derived from RHEL.

Ad Widget

Migrate Zabbix from Centos to Ubuntu

Migrate Zabbix from Centos to Ubuntu

Comment

Comment