zabbix监控系统3.X升级4

1.关闭服务

1. systemctl stop zabbix-service

2. systemctl stop httpd

2.更新repo

1. # cat zabbix.repo

2. [zabbix]

3. name=Zabbix Official Repository - $basearch

4. baseurl=http://repo.zabbix.com/zabbix/4.4/rhel/7/$basearch/

5. enabled=1

6. gpgcheck=1

7. gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-ZABBIX-A14FE591

8.  

9. [zabbix-non-supported]

10. name=Zabbix Official Repository non-supported - $basearch

11. baseurl=http://repo.zabbix.com/non-supported/rhel/7/$basearch/

12. enabled=1

13. gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-ZABBIX

14. gpgcheck=1

3.刷新yum缓存

yum makecache

4.更新zabbixrpm包

yum upgrade zabbix-server-mysql zabbix-web-mysql zabbix-agent zabbix-proxy-mysql

5.开启zabbix-service服务

systemctl start zabbix-server.service

6.查看logs

1. # tail -f /var/log/zabbix/zabbix_server.log

2. 40651:20200117:090620.296 ODBC: YES

3. 40651:20200117:090620.296 SSH2 support: YES

4. 40651:20200117:090620.296 IPv6 support: YES

5. 40651:20200117:090620.296 TLS support: YES

6. 40651:20200117:090620.296 ******************************

7. 40651:20200117:090620.296 using configuration file: /etc/zabbix/zabbix_server.conf

8. 40651:20200117:090620.300 current database version (mandatory/optional): 03040000/03040007

9. 40651:20200117:090620.300 required mandatory version: 04040000

10. 40651:20200117:090620.300 starting automatic database upgrade

11. 40651:20200117:090620.524 completed 0% of database upgrade

12. 40651:20200117:090711.272 slow query: 50.706882 sec, "alter table `events` add `name` varchar(2048) default '' not null"

13. 40651:20200117:090711.273 completed 1% of database upgrade

14. 40651:20200117:090737.112 slow query: 24.320271 sec, "update events set name='Cannot calculate trigger expression.' where source=3 and object=0 and value=1"

15. 40651:20200117:090737.115 completed 2% of database upgrade

16. 40651:20200117:090739.151 completed 3% of database upgrade

17. 40651:20200117:090739.402 completed 4% of database upgrade

18. 40651:20200117:090739.587 completed 5% of database upgrade

19. 40651:20200117:090739.741 completed 6% of database upgrade

20. 40651:20200117:090739.813 completed 7% of database upgrade

21. 40651:20200117:090739.814 completed 8% of database upgrade

22. 40651:20200117:090739.859 completed 9% of database upgrade

23. 40651:20200117:090757.424 slow query: 17.439447 sec, "alter table `alerts` modify `sendto` varchar(1024) default '' not null"

24. 40651:20200117:090757.424 completed 10% of database upgrade

25. 40651:20200117:090757.530 completed 11% of database upgrade

26. 40651:20200117:090757.548 completed 12% of database upgrade

27. 40651:20200117:090757.561 completed 13% of database upgrade

28. 40651:20200117:090757.606 completed 14% of database upgrade

29. 40651:20200117:090757.805 completed 15% of database upgrade

30. 40651:20200117:090757.854 completed 16% of database upgrade

31. 40651:20200117:090757.859 completed 17% of database upgrade

32. 40651:20200117:090803.691 slow query: 3.049138 sec, "alter table `items` add `url` varchar(2048) default '' not null"

33. 40651:20200117:090806.154 completed 18% of database upgrade

34. 40651:20200117:090810.992 completed 19% of database upgrade

35. 40651:20200117:090814.145 slow query: 3.152700 sec, "alter table `items` add `follow_redirects` integer default '1' not null"

36. 40651:20200117:090817.203 slow query: 3.058451 sec, "alter table `items` add `post_type` integer default '0' not null"

等待数据库升级完成。

7.解决中文乱码

ln -fs /usr/share/fonts/wqy-microhei/wqy-microhei.ttc /etc/alternatives/zabbix-web-font

8.解决zabbix4监控oracle11

出现升级后无法监控oracle

Message from 192.168.239.201 is missing header. Message ignored.

升级orabbix，下载地址：https://github.com/106140873/orabbix4zabbix4

conf使用之前的conf文件。