1、查看zabbix的日志
[root@bogon ldap]# cat /tmp/zabbix_server.log
'/var/lib/mysql/mysql.sock' (2)
2848:20181204:084007.165 database is down: reconnecting in 10 seconds
2848:20181204:084017.167 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
2848:20181204:084017.167 database is down: reconnecting in 10 seconds
看到没有连接上mysql数据库
2、修改zabbix的配置文件 zabbix_server.conf
找到 #DBSocket= 去掉前面的#注释,改成 DBSocket=/tmp/mysql.sock
sed -i 's/# DBSocket=/DBSocket=/tmp/mysql.sock/g' /usr/local/zabbix/etc/zabbix_server.conf
3、重启zabbbix 解决
/etc/init.d/zabbix_server stop && /etc/init.d/zabbix_server start
4、再次查看日志
[root@bogon ldap]# cat /tmp/zabbix_server.log
9135:20181204:085433.351 using configuration file: /usr/local/zabbix/etc/zabbix_server.conf
9135:20181204:085433.358 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
9135:20181204:085433.358 database is down: reconnecting in 10 seconds
9135:20181204:085443.360 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
9135:20181204:085443.360 database is down: reconnecting in 10 seconds
9135:20181204:085453.361 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
9135:20181204:085453.362 database is down: reconnecting in 10 seconds
上面原因是zabbix的配置文件里面连接mysql数据库的密码写错了,改正重启zabxix_server即可
[root@bogon ~]# vi /usr/local/zabbix/etc/zabbix_server.conf
DBPassword=zabbix@123
参照文档:
http://bbs.51cto.com/thread-919418-1.html