Bug #3426
大平台3.1.3版本的jar包在mysql版本更新到8.0.29后，大平台在启动时间表等插件时获取不到数据
Start date:
06/11/2024
Due date:
% Done:
0%
Estimated time:
Description
点击时间表，实时报警，实时事件，历史事件插件时，没有数据显示，查看jar包日志出现一下报错
2024-06-07 17:05:27.534 [http-nio-8012-exec-12] ERROR o.a.c.c.C.[.[.[.[dispatcherServlet] 175 : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
2024-06-07 17:05:27.534 [http-nio-8012-exec-12] ERROR o.a.c.c.C.[.[.[.[dispatcherServlet] 175 : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
- Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed
- The error may exist in URL [jar:file:/root/ISCS_java/web-0.0.1-SNAPSHOT.jar!/BOOT-INF/classes!/mapper/GroupMapper.xml]
- The error may involve com.qian.web.mapper.primary.GroupMapper.queryGroup
- The error occurred while executing a query
- Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLNonTransientConnectionExcept
经验证，同样的jar包和配置，在debian10的mysql8上可以获取到数据
Files
History
Updated by zeng bo 5 months ago
- File mysql5升级mysql8操作手册.docx mysql5升级mysql8操作手册.docx added
zeng bo wrote:
已解决
为mysql5与MySQL8对环境变量的解析方式不同，导致mysql的ssl配置失败，使jar包获取mysql数据时出现报错，后续将会在文档中标注。