'zabbix server cannot connect to database
First, zabbix web gui can work, but zabbix server stutus is 'Not running'
It means mysql works correctly, because zabbix web can connect it.
Next, I checked zabbix server /var/log/zabbix/zabbix_server.log, here is the details:
14329:20160913:145134.438 database is down: reconnecting in 10 seconds 14329:20160913:145144.439 [Z3001] connection to database 'zabbix' failed: [0] could not connect to server: Connection refused Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 3306? received invalid response to SSL negotiation: R
Anyone who can help?
Solution 1:[1]
Solved. Both zabbix-mysql and zabbix-postgresql are installed. It seems there are some conflicts. Just remove zabbix-postgresql, it works.
Solution 2:[2]
+1 to the answer about zabbix-postgresql above In my case zabbix-server-pgsql was installed along with zabbix-server-mysql. After uninstalling zabbix-server-pgsql zabbix-server could be sucessfully started and connecting to MySQL DB.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | glover |
| Solution 2 | Kveldus |