解决zabbix启动失败问题

一、启动zabbix-server报错

提示信息：

Job for zabbix-server.service failed because the control process exited with error code. See “systemctl status zabbix-server.service” and “journalctl -xe” for details.

找原因

1.执行journalctl -xe

[root@localhost ~]# journalctl -xe

2.错误原因：

/usr/sbin/zabbix_server: error while loading shared libraries:libmysqlclient.so.18: cannot open shared object file: No such file or directory

之前安装mysql5.7时，手动卸载了系统自带的mariadb-libs-5.5.56-2.el7.x86_64，安装mysql5.7之后只有libmysqlclient.so.20，所以找不到libmysqlclient.so.18文件

解决：

安装mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm，这个安装包中会包括所需版本的libmysqlclient.so
获取地址：https://dev.mysql.com/downloads/mysql/5.7.html#downloads

[root@localhost ~]# rpm -ivh mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm
准备中… ################################# [100%]
正在升级/安装… 1:mysql-community-libs-compat-5.7.2################################# [100%]

安装完成之后检查，有了/usr/lib64/mysql/libmysqlclient.so.18

[root@localhost ~]# find / -name libmysqlclient.so*
/usr/lib64/mysql/libmysqlclient.so.20
/usr/lib64/mysql/libmysqlclient.so.20.3.15
/usr/lib64/mysql/libmysqlclient.so.18
/usr/lib64/mysql/libmysqlclient.so.18.1.0

二、再次启动zabbix-server，不出意外，依旧没有成功，但是没有了提示信息。

[root@localhost ~]# systemctl status zabbix-server.service
●zabbix-server.service - Zabbix Server
Loaded: loaded (/usr/lib/systemd/system/zabbix-server.service; disabled; vendor preset: disabled)
Active: activating (auto-restart) (Result: exit-code) since 日 2019-12-22 05:11:15 CST; 8s ago
Process: 8178 ExecStop=/bin/kill -SIGTERM $MAINPID (code=exited, status=1/FAILURE)
Process: 8173 ExecStart=/usr/sbin/zabbix_server -c $CONFFILE(code=exited, status=0/SUCCESS)
Main PID: 8175 (code=exited,status=1/FAILURE)

查看日志

[root@localhost]# tail -f zabbix_server.log

原因：zabbix用户的权限问题

connection to database ‘zabbix’ failed: [1044] Access denied for user ‘zabbix’@’%’ to database ‘zabbix’

在mysql命令行中或Navicat中修改zabbix用户的权限即可。

再次启动，成功。