search

cookieY / Yearning

🐳 A most popular sql audit platform for mysql
http://next.yearning.io/
GNU Affero General Public License v3.0
8.52k stars 1.99k forks source link

[Question] 对开启SSL认证的mysql数据库执行查询时，无结果响应 #1124

Closed liubowyf closed 14 hours ago

liubowyf commented 1 week ago

Describe the question 对开启SSL认证的mysql数据库执行查询时，无结果响应，执行ddl语句及dml语句可以正常执行，当前使用版本v3.1.9

Deployment image

image

Env (please complete the following information):

Additional Logs Add any logs about the problem here.

Issues-translate-bot commented 1 week ago

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

Title: [Question] When querying the mysql database with SSL authentication turned on, there is no result response

dosubot[bot] commented 1 week ago

@liubowyf 你好! 我是Dosu，一个可以帮你解决bug、回答问题并成为贡献者的机器人。我会在等待人类维护者的期间帮助你。

在 Yearning v3.1.9 中，针对开启 SSL 认证的 MySQL 数据库执行查询时无结果响应的问题，目前没有找到相关的已知问题或错误报告。Yearning 处理 MySQL 数据库的 SSL 连接时，需要配置 TLS 设置，包括提供 CA 证书、客户端证书和客户端密钥。如果这些配置正确，应该能够正常建立 SSL 连接 [1]。

建议检查以下几点：

  1. 确保 CA 证书、客户端证书和客户端密钥的路径和内容正确。
  2. 检查 MySQL 服务器的 SSL 配置，确保其允许 SSL 连接。
  3. 查看 Yearning 的日志文件，寻找可能的错误信息或警告。

如果问题仍然存在，可能需要进一步调试 SSL 连接的配置或查看 MySQL 服务器的日志以获取更多信息。

To continue talking to Dosu, mention @dosu.

Issues-translate-bot commented 1 week ago

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

@liubowyf Hello! I'm Dosu, a bot that can help you solve bugs, answer questions and become a contributor. I'll help you while I wait for the human maintainers.

In Yearning v3.1.9, there is currently no known issue or bug report related to the problem of no result response when executing queries on the MySQL database with SSL authentication turned on. When Yearning handles SSL connections to a MySQL database, you need to configure TLS settings, including providing a CA certificate, client certificate, and client key. If these are configured correctly, you should be able to establish an SSL connection [1].

It is recommended to check the following points:

  1. Ensure that the path and content of the CA certificate, client certificate, and client key are correct.
  2. Check the MySQL server's SSL configuration to make sure it allows SSL connections.
  3. Check Yearning's log files for possible error messages or warnings.

If the problem persists, you may need to further debug the configuration of the SSL connection or view the MySQL server's logs for more information.

To continue talking to Dosu, mention @dosu.

cookieY commented 14 hours ago

最新版本已修复

Issues-translate-bot commented 14 hours ago

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

The latest version has been fixed