zabbix没有10051端口解决

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