zabbix 從5.0升級到5.4
Upgrade procedure
1 停止zabbix-server服務 Stop Zabbix processes
Stop Zabbix server to make sure that no new data is inserted into database.
# systemctl stop zabbix-server
If upgrading the proxy, stop proxy too.
# systemctl stop zabbix-proxy
2 備份歷史數據庫 Back up the existing Zabbix database
This is a very important step. Make sure that you have a backup of your database. It will help if the upgrade procedure fails (lack of disk space, power off, any unexpected problem).
3 備份配置文件 Back up configuration files, PHP files and Zabbix binaries
Make a backup copy of Zabbix binaries, configuration files and the PHP file directory.
Configuration files:
# mkdir /opt/zabbix-backup/ # cp /etc/zabbix/zabbix_server.conf /opt/zabbix-backup/ # cp /etc/httpd/conf.d/zabbix.conf /opt/zabbix-backup/
PHP files and Zabbix binaries:
# cp -R /usr/share/zabbix/ /opt/zabbix-backup/ # cp -R /usr/share/doc/zabbix-* /opt/zabbix-backup/
Backup MySQL
#mysqldump -uroot -p zabbix >20210830.sql
4 升級zabbix repo源 Update repository configuration package
To proceed with the upgrade your current repository package has to be updated.
# rpm -Uvh https://repo.zabbix.com/zabbix/5.4/rhel/8/x86_64/zabbix-release-5.4-1.el8.noarch.rpm
5 升級zabbix 程序 Upgrade Zabbix components
To upgrade Zabbix components you may run something like:
# yum upgrade zabbix-server-mysql zabbix-web-mysql zabbix-agent
If using PostgreSQL, substitute mysql with pgsql in the command. If upgrading the proxy, substitute server with proxy in the command. If upgrading the agent 2, substitute zabbix-agent with zabbix-agent2 in the command.
To upgrade the web frontend with Apache on RHEL 8 correctly, also run:
# yum install zabbix-apache-conf
and make the necessary changes to this file.
To upgrade the web frontend on RHEL 7 follow distribution-specific instructions (extra steps are required to install PHP 7.2 or newer).
6 檢查組件配置參數 Review component configuration parameters
See the upgrade notes for details on mandatory changes.
7 啟動zabbix-server 服務 Start Zabbix processes
Start the updated Zabbix components.
# systemctl start zabbix-server # systemctl start zabbix-proxy # systemctl start zabbix-agent # systemctl start zabbix-agent2
檢查狀態
導入數據庫 Import sql
需要先停止數據庫服務
#msyql -uzabbix -p zabbix < 20210830.sql
zabbix5.2版本升級到zabbix5.4版本后打開頁面報錯，報錯內容如下
問題一
Database error
The frontend does not match Zabbix database. Current database version (mandatory/optional): 5010000/5010000. Required mandatory version: 5040000. Contact your system administrator.
(圖片來自網絡)
解決辦法：
進入數據庫
mysql> show databases; mysql> use zabbix; mysql> update dbversion set mandatory=5040000; mysql> flush privileges;
重新打開web即可解決
問題二
zabbix-server 無法啟動，查看日志
tail -f /var/log/zabbix/zabbix_server.log
9332:20181010:174337.188 [Z3005] query failed: [1050] Table 'tag_filter' already exists [create table tag_filter ( `tag_filterid` bigint unsigned not null, `usrgrpid` bigint unsigned not null, `groupid` bigint unsigned not null, `tag` varchar(255) default '' not null, `value` varchar(255) default '' not null, primary key (tag_filterid)
Fix:
Login mysql
對log中提示的所有表都drop掉，直到提示upgrade 完成，這樣在瀏覽器上就可以正常打開和登陸zabbix
use zabbix; drop table tag_filter;
8 Clear web browser cookies and cache
After the upgrade you may need to clear web browser cookies and web browser cache for the Zabbix web interface to work properly.
本文來自希曼博客-www.ximan.tech，作者：希曼博客，轉載請注明原文鏈接：http://www.rzrgm.cn/lihuaichen/p/15215708.html
浙公網安備 33010602011771號