Upgrade\update zabbix 3.0 to 3.2 Centos 6 (RPM)

[batchenr]

Hi,

ok so,
this is the steps i folowod and it worked for me.

# Backup zabbixdb and all the configuration\bin files before doing any of this steps.

1. stop zabbix server
2. stop zabbix agent
3. please notice

now we will preform DB change and it may take some time.. i have 70G of DB data and it took 5-6 hours

and make sure you have extra 20-30 G space available as it changes it filled tmp database there but after it finished all the tmp data disappear.

and also i noticed because of the utf8 change my db data decrease from 70G to 56G

# zabbix db change :
alter zabbixdb and tables to use utf8_bin.

ALTER DATABASE zabbixdb CHARACTER SET utf8 COLLATE utf8_bin;

SET foreign_key_checks = 0;

#loop to changing all tables:


for i in $(mysql -D zabbixdb -e "show tables" ); do ALTER TABLE $i CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;

4.change zabbix repo

vim /etc/yum.repos.d/zabbix.repo to this :

[zabbix]
name=Zabbix Official Repository - $basearch
baseurl=http://repo.zabbix.com/zabbix/3.2/rhel/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-ZABBIX-A14FE591

[zabbix-deprecated]
name=Zabbix Official Repository deprecated - $basearch
baseurl=http://repo.zabbix.com/zabbix/3.2/rhel/6/$basearch/deprecated
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-ZABBIX-A14FE591

[zabbix-non-supported]
name=Zabbix Official Repository non-supported - $basearch
baseurl=http://repo.zabbix.com/non-supported/rhel/6/$basearch/
enabled=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-ZABBIX
gpgcheck=1

yum clean all


5. remove all zabbix rpms
rpm -qa | grep zabbix

then :
rpm -e all the packages.
yum install zabbix-server-mysql zabbix-web-mysql zabbix-java-gateway zabbix-get zabbix-sender zabbix-release


verify that it is going to install zabbix version 3.2.6
after its done restart zabbix agent\server\httpd\mysql


make sure in zabbix_server.conf that you change the
DBName
DBUser
DBPassword
DBHost

to what u had on the last configuration file (take values from the backup)
including all special conf u did if you add more pollers and stuff like that.


now after restart you should see db update 1% 2% ... at /var/log/zabbix/zabbix_server.log
let it finish and check ur zabbix server

hope it helped.