WARN: Establishing SSL connection without server‘s identity verification is not recommended.

爱被打了一巴掌 2023-09-26 20:08 110阅读 0赞

### 文章目录 ###

*  问题描述：
 *  原因分析：
 *  解决方案：
 *  扩展：

--------------------

# 问题描述： #

`提示：这里描述项目中遇到的问题：`  
![在这里插入图片描述][d879a57fc09e452195c19a625969d844.png]

控制台中警告部分代码：  
为方便查看已换行处理

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.

--------------------

# 原因分析： #

> 提示：先去看pom.xml里面的MySQL版本问题

一开始我觉得是`pom.xml`里面MySQL版本不对  
但是经过检查发现是8.0的版本，并不是上面说的MySQL 5.5.45+, 5.6.26+ and 5.7.6+ 版本  
![在这里插入图片描述][d786e6e3669741c3b400a5ed3d868f0e.png]

这时候看到了报错的最后一句话：  
![在这里插入图片描述][53368d41b3804580aeb0cf20ace2566a.png]  
为方便查看报错已换行处理

You need either to explicitly disable SSL by setting useSSL=false, 
    or set useSSL=true and provide truststore for server certificate verification.

--------------------

# 解决方案： #

> 提示：这里填写该问题的具体解决方案：

在`application.yml`文件内的`url`那行最后加上：`&useSSL=false`  
![在这里插入图片描述][0e3014dc93ba48fe864ef317172544da.png]  
使这行变成（已换行处理）：

url: jdbc:mysql://localhost:3306/数据库名字?useUnicode=true
    &characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true
    &useLegacyDatetimeCode=false&serverTimezone=UTC&useSSL=false

再次运行程序就没有警告了，其实警告WARN不用管，并不影响程序运行  
![在这里插入图片描述][c9ef663d59fc426ba5ebfff4f361a246.png]

# 扩展： #

如果没有在`application.yml`文件内的`url`那行最后加上：`&useSSL=false`  
也有可能会导致另一个关闭警告：

closing inbound before receiving peer‘s close_notify

项目在关闭的时候出现的问题，**这其实是个警告，警告不用管**  
![例如：项目场景：示例:通过蓝牙芯片(HC-05)与手机 APP 通信，每隔 5s 传输一批传感器数据(不是很大)][HC-05_ APP _ 5s]  
具体报错信息如下：

javax.net.ssl.SSLException: closing inbound before receiving peer's close_notify
    	at java.base/sun.security.ssl.SSLSocketImpl.shutdownInput(SSLSocketImpl.java:837)
    	at java.base/sun.security.ssl.SSLSocketImpl.shutdownInput(SSLSocketImpl.java:816)
    	at com.mysql.cj.protocol.a.NativeProtocol.quit(NativeProtocol.java:1312)
    	at com.mysql.cj.NativeSession.quit(NativeSession.java:182)
    	at com.mysql.cj.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:1750)
    	at com.mysql.cj.jdbc.ConnectionImpl.close(ConnectionImpl.java:720)
    	at com.zaxxer.hikari.pool.PoolBase.quietlyCloseConnection(PoolBase.java:135)
    	at com.zaxxer.hikari.pool.HikariPool.lambda$closeConnection$1(HikariPool.java:441)
    	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
    	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
    	at java.base/java.lang.Thread.run(Thread.java:833)

在`application.properties`文件里面，在编写URL那行最后加上：`&useSSL=false`  
![在这里插入图片描述][48ba881c9f0c4a9da8d6d987f82b4822.png]

再次运行项目后停止：  
![在这里插入图片描述][d3a35ccdb5c343769c9eabf8ee1f9438.png]

[d879a57fc09e452195c19a625969d844.png]: https://img-blog.csdnimg.cn/d879a57fc09e452195c19a625969d844.png
[d786e6e3669741c3b400a5ed3d868f0e.png]: https://img-blog.csdnimg.cn/d786e6e3669741c3b400a5ed3d868f0e.png
[53368d41b3804580aeb0cf20ace2566a.png]: https://img-blog.csdnimg.cn/53368d41b3804580aeb0cf20ace2566a.png
[0e3014dc93ba48fe864ef317172544da.png]: https://img-blog.csdnimg.cn/0e3014dc93ba48fe864ef317172544da.png
[c9ef663d59fc426ba5ebfff4f361a246.png]: https://img-blog.csdnimg.cn/c9ef663d59fc426ba5ebfff4f361a246.png
[HC-05_ APP _ 5s]: https://img-blog.csdnimg.cn/381a37781c9c4a8daad818e6ff9b992e.png
[48ba881c9f0c4a9da8d6d987f82b4822.png]: https://img-blog.csdnimg.cn/48ba881c9f0c4a9da8d6d987f82b4822.png
[d3a35ccdb5c343769c9eabf8ee1f9438.png]: https://img-blog.csdnimg.cn/d3a35ccdb5c343769c9eabf8ee1f9438.png

WARN: Establishing SSL connection without server‘s identity verification is not recommended.

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Mysql Establishing SSL connection without server's identity verification is not recommended

相关警告:Establishing SSL connection without server's identity verification is not recommended

相关 WARN: Establishing SSL connection without server‘s identity verification is not recommended.

相关 MYSQL:WARN: Establishing SSL connection without server's identity verification is not recommended.

相关 MySQL 警告WARN: Establishing SSL connection without server's identity verification is not recommended.

相关 MySQL 警告WARN: Establishing SSL connection without server's identity verification is not recommended.

相关 MYSQL:WARN: Establishing SSL connection without server's identity verification is not recommended.

相关 Establishing SSL connection without server's identity verification is not recommended.

相关警告 Establishing SSL connection without server's identity verification is not recommended.

相关 [bug记录：]WARN: Establishing SSL connection without server's identity verification is not recommended.