docker部署zabbix,访问zabbix web页面时,报数据库找不到表,应该是初始化时,sql脚本未导入到zabbix库中。
# 查看zabbix-server日志
docker logs compose_zabbix-server_1 -f
一直报如下错误:
**** MySQL server is not available. Waiting 5 seconds...
# 在 zabbix-server 中用mysql命令连接数据库提示ssl的问题。
ERROR 2026 (HY000): SSL connection error: error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol
# 查看数据库中关于ssl关键词的变量
mysql> show variables like '%ssl%'; +---------------+-----------------+ | Variable_name | Value | +---------------+-----------------+ | have_openssl | YES | | have_ssl | YES | | ssl_ca | ca.pem | | ssl_capath | | | ssl_cert | server-cert.pem | | ssl_cipher | | | ssl_crl | | | ssl_crlpath | | | ssl_key | server-key.pem | +---------------+-----------------+ 9 rows in set (0.00 sec)
# 添加 skip-ssl 这行
root@d6fcbeeee611:~# cat /etc/mysql/conf.d/docker.cnf [mysqld] skip-host-cache skip-name-resolve skip-ssl
重启mysql容器
# 再次查看ssl状态变为关闭
mysql> show variables like '%ssl%'; +---------------+----------+ | Variable_name | Value | +---------------+----------+ | have_openssl | DISABLED | | have_ssl | DISABLED | | ssl_ca | | | ssl_capath | | | ssl_cert | | | ssl_cipher | | | ssl_crl | | | ssl_crlpath | | | ssl_key | | +---------------+----------+ 9 rows in set (0.00 sec)
重新 docker-compose up 导入成功。
ssl参数是启用ssl连接
root@82a862f5f9f5:/# mysqld --verbose --help |grep ssl --ssl Enable SSL for connection (automatically enabled with (Defaults to on; use --skip-ssl to disable.)
原创文章,转载请注明。本文链接地址: https://www.rootop.org/pages/5238.html