Hi, I am running zabbix3.4.11 with mysql5.7 RDS as my backend database. I'm currently having trouble updating MySQL 5.7 to 8.0.
After updating MySQL, the connection from zabbix to mysql was dropping and trying to connect every 10 seconds. The error message in zabbix_server.log states: "[Z3001] Connection to database 'zabbix' failed: [2026] SSL connection error: Unknown error number." But I'm not using ssl for this connection, so I don't know how I can resolve this issue. I also tried updating zabbix from 3.4.11 to 4.0.0, but that doesn't work either.
Please let me know if you have any solutions or ideas.
See also:
OS: ubuntu16.04.4
zabbix:3.4.11 (eventually 4.0.0)
Backend DB: MySQL5.7.41 to MySQL8.0.32
After updating MySQL, the connection from zabbix to mysql was dropping and trying to connect every 10 seconds. The error message in zabbix_server.log states: "[Z3001] Connection to database 'zabbix' failed: [2026] SSL connection error: Unknown error number." But I'm not using ssl for this connection, so I don't know how I can resolve this issue. I also tried updating zabbix from 3.4.11 to 4.0.0, but that doesn't work either.
Please let me know if you have any solutions or ideas.
See also:
OS: ubuntu16.04.4
zabbix:3.4.11 (eventually 4.0.0)
Backend DB: MySQL5.7.41 to MySQL8.0.32