zabbix 链接docker 容器mysql报错 50588:20220207:155535.075 [Z3001] connection to database 'zabbix' failed: [200 2] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.soc k' (2)
今天打算安装zabbix并且使用docker的mysql
正常安装没有出现问题,到了最后页面安装成功后有一个错误
查看日志发现是数据库连接失败
[root@server ~]# more /var/log/zabbix/zabbix_server.log
50588:20220207:155405.054 Starting Zabbix Server. Zabbix 5.0.20 (revision bf8d
9f8abb).
50588:20220207:155405.054 ****** Enabled features ******
50588:20220207:155405.054 SNMP monitoring: YES
50588:20220207:155405.054 IPMI monitoring: YES
50588:20220207:155405.054 Web monitoring: YES
50588:20220207:155405.054 VMware monitoring: YES
50588:20220207:155405.054 SMTP authentication: YES
50588:20220207:155405.054 ODBC: YES
50588:20220207:155405.054 SSH support: YES
50588:20220207:155405.054 IPv6 support: YES
50588:20220207:155405.054 TLS support: YES
50588:20220207:155405.054 ******************************
50588:20220207:155405.054 using configuration file: /etc/zabbix/zabbix_server.
conf
50588:20220207:155405.056 [Z3001] connection to database 'zabbix' failed: [200
2] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.soc
k' (2)
50588:20220207:155405.056 database is down: reconnecting in 10 seconds
50588:20220207:155415.059 [Z3001] connection to database 'zabbix' failed: [200
2] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.soc
k' (2)
50588:20220207:155415.059 database is down: reconnecting in 10 seconds
50588:20220207:155425.062 [Z3001] connection to database 'zabbix' failed: [200
2] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.soc
k' (2)
50588:20220207:155425.062 database is down: reconnecting in 10 seconds
50588:20220207:155435.062 [Z3001] connection to database 'zabbix' failed: [200
2] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.soc
k' (2)
经过各种尝试修改参数,调整ip,调整mysql配置无效后打算放弃之际看到配置文件中的DBHost没有填写,于是尝试填上mysql的ip地址后重启服务发现连接成功
[root@server ~]# vim /etc/zabbix/zabbix_server.conf
增加mysql服务器的IP地址后重启服务发现连接成功没有报错了。