Upgrade from 3.0.24 to 5.0.4 on a new server

[Tariq Hasan]

Hi
has anybody been through this pain? Any hints and tips on how to automate or make this easier?

[ZaBeast]

The upgrade is pretty simple, it shouldn't hurt . I recommend this step-by-step guide if you are upgrading your Zabbix to 5.0 version: https://bestmonitoringtools.com/upgr...atest-version/

[Tariq Hasan]

Hi ZaBeast

I am building a new Zabbix 5 server from scratch on RHEL8.
We currently have an Zabbix 3 server on Ubuntu. We are not planning to do an upgrade, this is a fresh install. My question was how easy is it to 'copy' the old config across.

Regards

Tariq

[ZaBeast]

Hi ZaBeast

I am building a new Zabbix 5 server from scratch on RHEL8.
We currently have an Zabbix 3 server on Ubuntu. We are not planning to do an upgrade, this is a fresh install. My question was how easy is it to 'copy' the old config across.

Regards

Tariq

It is pretty easy.

1. Backup Zabbix DB on your old server:
Example:

mysqldump -h localhost -u'[B]root[/B]' -p'[B]rootDBpass[/B]' --single-transaction '[B]zabbix[/B]' | gzip > /opt/zabbix_backup/db_files/zabbix_backup.sql.gz

2. Install Zabbix on the new server but don't start the Zabbix server

3. Drop the new database and restore the old database
Example:

mysql -u'root' -p'rootDBpass' -e "drop database zabbix"
mysql -u'root' -p'rootDBpass' -e "create database zabbix character set utf8 collate utf8_bin;"
mysql -u'root' -p'rootDBpass' -e "grant all privileges on zabbix.* to zabbix@localhost identified by 'zabbixDBpass';"

mysql -u'root' -p'rootDBpass' zabbix -e "set global innodb_strict_mode='OFF';"
zcat /opt/zabbix_backup/db_files/zabbix_backup.sql.gz | mysql -h localhost -u'root' -p'rootDBpass' 'zabbix'
mysql -u'root' -p'rootDBpass' zabbix -e "set global innodb_strict_mode='ON';"

4. Update Zabbix and Web server configuration

5. Start the Zabbix server and it will do the DB upgrade

6. Patch DB to support precision of approximately 15 digits and bigger range and to fix error message “database is not upgraded to use double precision values”

[Tariq Hasan]

Hi ZaBeast

Will that do 'EVERYTHING' - Users, User Groups. Hosts, Host Groups, Maintenance Periods, etc etc?

[ZaBeast]

Hi ZaBeast

Will that do 'EVERYTHING' - Users, User Groups. Hosts, Host Groups, Maintenance Periods, etc etc?

Yes. Zabbix keeps everything in the database.