zabbix 从3.0.1 升级到3.2.1
来源:互联网 发布:宁芙的淘宝店 编辑:程序博客网 时间:2024/06/07 02:51
[root@server0 ~]# service zabbix_server stop
Shutting down zabbix_server: [确定]
[root@server0 ~]# service zabbix_agentd stop
Shutting down zabbix_agentd: [确定]
[root@server0 ~]# mv /usr/local/zabbix/ /usr/local/zabbix3.0
[root@server0 ~]# tar zxvf zabbix-3.2.1.tar.gz -C /usr/local/src
[root@server0 zabbix-3.2.1]# ./configure –prefix=/usr/local/zabbix –enable-server –enable-ipv6 –enable-agent –with-mysql –with-net-snmp –with-libcurl –with-libxml2 && make && make install
[root@server0 /]# mv /usr/local/zabbix/etc/zabbix_server.conf /usr/local/zabbix/etc/zabbix_server.conf.bak
[root@server0 /]# cp /usr/local/zabbix3.0/etc/zabbix_server.conf /usr/local/zabbix/etc/zabbix_server.conf
[root@server0 /]# mv /usr/local/zabbix/etc/zabbix_agentd.conf /usr/local/zabbix/etc/zabbix_agentd.conf.bak
[root@server0 /]# cp /usr/local/zabbix3.0/etc/zabbix_agentd.conf /usr/local/zabbix/etc/zabbix_agentd.conf
[root@server0 /]# service zabbix_server start
Starting zabbix_server: [确定]
此时如果不替换前端代码,直接访问zabbix web页面会有以下错误
[root@server0 /]#mv /usr/local/nginx/html/zabbix/ /usr/local/nginx/html/zabbix3.0
[root@server0 /]# cp -r /usr/local/src/zabbix-3.2.1/frontends/php/ /usr/local/nginx/html/zabbix
[root@server0 /]# cp /usr/local/nginx/html/zabbix3.0/conf/zabbix.conf.php /usr/local/nginx/html/zabbix/conf/
之后启动zabbix server,出现故障
[root@localhost html]# service zabbix_server start
Starting zabbix_server: [ OK ]
[root@localhost html]# service zabbix_server status
zabbix_server dead but subsys locked
[root@localhost ~]# ls /var/lock/subsys/
abrt-ccpp atd certmonger haldaemon local mysql nfsd rpc.rquotad xinetd
abrtd auditd cgconfig ksmtuned lvm2-monitor netfs rpcbind rpc.statd zabbix_server
abrt-oops autofs cpuspeed libvirtd mcelogd network rpc.idmapd rsyslog
acpid avahi-daemon cups libvirt-guests messagebus NetworkManager rpc.mountd sshd
查看日志/tmp/zabbix_server.log,提示无法对表problem_tag创建索引,Specified key was too long; max key length is 1000 bytes;
查看数据库zabbix的编码和表problem_tag的结构:
mysql> desc problem_tag;
+————–+———————+——+—–+———+——-+
| Field | Type | Null | Key | Default | Extra |
+————–+———————+——+—–+———+——-+
| problemtagid | bigint(20) unsigned | NO | PRI | NULL | |
| eventid | bigint(20) unsigned | NO | MUL | NULL | |
| tag | varchar(255) | NO | | NULL | |
| value | varchar(255) | NO | | NULL | |
+————–+———————+——+—–+———+——-+
4 rows in set (0.00 sec)
mysql> show variables like ‘%char%’;
+————————–+—————————————-+
| Variable_name | Value |
+————————–+—————————————-+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql/share/mysql/charsets/ |
+————————–+—————————————-+
8 rows in set (0.00 sec)
修改字段长度:
mysql> alter table problem_tag change value value varchar(125) not null;
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> alter table problem_tag change tag tag varchar(125) not null;
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> desc problem_tag;
+————–+———————+——+—–+———+——-+
| Field | Type | Null | Key | Default | Extra |
+————–+———————+——+—–+———+——-+
| problemtagid | bigint(20) unsigned | NO | PRI | NULL | |
| eventid | bigint(20) unsigned | NO | MUL | NULL | |
| tag | varchar(125) | NO | | NULL | |
| value | varchar(125) | NO | | NULL | |
+————–+———————+——+—–+———+——-+
4 rows in set (0.00 sec)
mysql> quit
Bye
成功启动
[root@localhost html]# service zabbix_server stop
Shutting down zabbix_server: [FAILED]
[root@localhost html]# service zabbix_server start
Starting zabbix_server: [ OK ]
[root@localhost html]# service zabbix_server status
zabbix_server (pid 30630 30629 30628 30627 30626 30625 30624 30623 30622 30621 30620 30619 30618 30617 30616 30615 30614 30612 30611 30610 30609 30608 30607 30606 30605 30604 30603 30598) is running…
注意:升级后,mysql数据库内容会自动更新,降级后库内数据不会自动降级,想降级必须提前备份数据库
参考:
http://www.linuxidc.com/Linux/2017-02/140480.htm
http://www.cnblogs.com/unchch/p/7495256.html
http://www.jb51.net/article/24499.htm
http://www.cnblogs.com/jun1019/p/6360452.html
MySQL相关参考
https://www.cnblogs.com/galengao/p/5755788.html
http://blog.51cto.com/zhongyilin/1369361
http://blog.csdn.net/lionhenryzxxy/article/details/58585716
- zabbix 从3.0.1 升级到3.2.1
- Zabbix 3.0 从入门到精通(zabbix使用详解)
- 从TensorFlow0.12升级到TensorFlow1.1
- zabbix从2.6到3.0 脚本参数设置的变化
- 如何从Hibernate2.1升级到Hibernate3.0?
- 如何从Hibernate2.1升级到Hibernate3.0?
- MySQL升级:从MySQL4.1到MySQL5.0
- 如何从Hibernate2.1升级到Hibernate3.0?
- 从PhysX2.8升级到PhysX3.2(1)
- 从storm0.8.1升级到storm0.9.0.1实践
- Xcode从5.1升级到5.1.1后,重装dyci
- 从ovirt engine3.6.0升级到3.6.1
- Ubuntu 12.04.1 LTS 升级 PHP 从5.3 到 5.5
- Ubuntu 12.04.1 mysql从5.5升级到5.6
- 记录从greendao2.1升级到greendao3.2!
- ubuntu jdk从 java1.7升级到jdk-9.0.1
- 1、从传统的JDBC升级到Hibernate入门
- J2EE程序从JBoss4.0.0及3.2.x升级到4.0.1+的问题解决办法
- vs2013---Qt教程
- Ubuntu安装(UEFI+GPT+SSD+HDD)心酸之旅
- Touch_Java 9-(1):String类
- 【JZOJ 5409】【NOIP2017提高A组集训10.21】Fantasy
- 在Android上实现HttpServer
- zabbix 从3.0.1 升级到3.2.1
- 对于 iOS 开发,人工智能意味着什么?
- 绝望!新 AlphaGo 放弃人类,柯洁:人类太多余了
- JZOJ5409. 【NOIP2017提高A组集训10.21】Fantasy
- Python 中的作用域规则和闭包简析
- 普通人的煎蛋 vs 程序员的煎蛋
- JavaSE_8系列博客——专家之路(一)---Java反射的总结
- Linux命令
- socket网络编程的超时设置