Logstash配置的错误

mac2025-01-05  15

Java::JavaSql::SQLNonTransientConnectionException: Public Key Retrieval is not allowed

参考:

https://stackoverflow.com/questions/50379839/connection-java-mysql-public-key-retrieval-is-not-allowed

https://community.atlassian.com/t5/Confluence-questions/MySQL-Public-Key-Retrieval-is-not-allowed/qaq-p/778956

修改链接字符串,增加allowPublicKeyRetrieval=true

# 原字符串 jdbc_connection_string => "jdbc:mysql://xxx.xxx.xxx.xxx:3306/mydb?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false&serverTimezone=GMT%2B8" # 修改为 jdbc_connection_string => "jdbc:mysql://xxx.xxx.xxx.xxx:3306/mydb?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=GMT%2B8"

 

最新回复(0)