Project

General

Profile

Bug #3426

大平台3.1.3版本的jar包在mysql版本更新到8.0.29后,大平台在启动时间表等插件时获取不到数据

Added by zeng bo 6 months ago. Updated 6 months ago.

Status:
New
Priority:
Normal
Assignee:
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:
  1. 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
  2. The error may exist in URL [jar:file:/root/ISCS_java/web-0.0.1-SNAPSHOT.jar!/BOOT-INF/classes!/mapper/GroupMapper.xml]
  3. The error may involve com.qian.web.mapper.primary.GroupMapper.queryGroup
  4. The error occurred while executing a query
  5. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLNonTransientConnectionExcept

经验证,同样的jar包和配置,在debian10的mysql8上可以获取到数据


Files

History

#1

Updated by zeng bo 6 months ago

  • % Done changed from 0 to 100
#2

Updated by zeng bo 6 months ago

  • % Done changed from 100 to 0
#3

Updated by zeng bo 6 months ago

已解决

为mysql5与MySQL8对环境变量的解析方式不同,导致mysql的ssl配置失败,使jar包获取mysql数据时出现报错,后续将会在文档中标注。

#4

Updated by zeng bo 6 months ago

zeng bo wrote:

已解决

为mysql5与MySQL8对环境变量的解析方式不同,导致mysql的ssl配置失败,使jar包获取mysql数据时出现报错,后续将会在文档中标注。

Also available in: Atom PDF