当前位置: 首页 > news >正文

mysql驱动包引起的告警问题using SSL the verifyServerCertificate property is set to ‘false‘

tomcat启动时报以下ssl的连接错误,mysql版本为5.7.17,虽然系统可以使用,但是日志量太大,还是处理下,只需要修改mysql的连接格式:
url.db= “jdbc:mysql://localhost:3306/disis3?user=root&password=XXXXX&useUnicode=true&characterEncoding=utf-8”
改为:
url.db=“jdbc:mysql://localhost:3306/disis3?user=root&password=XXXXX&useUnicode=true&characterEncoding=utf-8&useSSL=false”
对比原来增加了: &useSSL=false

修改上述连接方式后,替换了mysql8.0的驱动,从mysql官网介绍,mysql8.0的驱动是兼容支持MySQL 5.5, 5.6, 5.7,8.0。

做了以上两个修改之后,重新启动tomcat,tomcat日志打印不再提示以下错误信息
Fri Nov 03 02:16:19 EDT 2023 WARN: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Fri Nov 03 02:16:19 EDT 2023 WARN: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Fri Nov 03 02:22:39 EDT 2023 WARN: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Fri Nov 03 02:22:39 EDT 2023 WARN: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Fri Nov 03 02:22:39 EDT 2023 WARN: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

http://www.lryc.cn/news/221727.html

相关文章:

  • draw.io与项目管理——如何利用流程图工具提高项目管理效率
  • LoRaWAN物联网架构
  • 数据结构(五):哈希表及面试常考的算法
  • 水利部加快推进小型水库除险加固,大坝安全监测是重点
  • 实施电子采购的6个有效步骤
  • 【Shell脚本6】Shell 运算符
  • 设计模式之保护性暂停
  • UE5、CesiumForUnreal实现加载GeoJson绘制单面(Polygon)功能(StaticMesh方式)
  • Linux 下以其他用户运行程序
  • Centos7下安装使用K3S
  • 易云维®工厂能耗管理平台系统方案,保证运营质量,推动广东制造企业节能减排
  • Qwt QwtWheel绘制滚动轮
  • 【C++语法讲解】 | 运算符重构 | 三种运算符的重构方式 |代码演示
  • [100天算法】-寻找峰值(day 63)
  • Go语言开发环境安装,hello world!
  • 记CVE-2022-39227-Python-JWT漏洞
  • 软件测试/测试开发丨如何利用ChatGPT自动生成测试用例思维导图
  • 【编程语言发展史】Unity开发语言的历史发展
  • springboot http添加请求头 添加请求证书
  • 【Qt之数据库操作】
  • 数据结构(c语言版) 队列
  • kimera论文阅读
  • golang gorm通过泛型实现通用单表增删改
  • 十、K8S之ConfigMap
  • python飞书群机器人通过webhook发送消息
  • 埃隆·马斯克的 AI 聊天机器人 Grok 已经上线
  • 【代码随想录】算法训练营 第十五天 第六章 二叉树 Part 2
  • 使用ssl_certificate_by_lua指令动态加载证书
  • Qt中Opencv转Qimage出现重影或者颜色不对
  • upload-labs-1