Mysql数据库连接失败SSLException: Unsupported record version Unknown-0.0问题_Mysql

问题描述

mysql版本：5.7.27
jdk版本：1.8.0_201

tomcat日志中报错，显示连接数据库失败，报错信息如下：

the last packet successfully received from the server was 152 milliseconds ago. the last packet sent successfully to the server was 147 milliseconds ago.
   at sun.reflect.nativeconstructoraccessorimpl.newinstance0(native method)
   at sun.reflect.nativeconstructoraccessorimpl.newinstance(nativeconstructoraccessorimpl.java:62)
   at sun.reflect.delegatingconstructoraccessorimpl.newinstance(delegatingconstructoraccessorimpl.java:45)
   at java.lang.reflect.constructor.newinstance(constructor.java:423)
   at com.mysql.jdbc.util.handlenewinstance(util.java:404)
   at com.mysql.jdbc.sqlerror.createcommunicationsexception(sqlerror.java:981)
   at com.mysql.jdbc.exportcontrolled.transformsockettosslsocket(exportcontrolled.java:164)
... 89 more
caused by: javax.net.ssl.sslexception: unsupported record version unknown-0.0
   at sun.security.ssl.inputrecord.checkrecordversion(inputrecord.java:552)
   at sun.security.ssl.inputrecord.readv3record(inputrecord.java:565)
   at sun.security.ssl.inputrecord.read(inputrecord.java:529)
   at sun.security.ssl.sslsocketimpl.readrecord(sslsocketimpl.java:975)
   at sun.security.ssl.sslsocketimpl.performinitialhandshake(sslsocketimpl.java:1367)
   at sun.security.ssl.sslsocketimpl.starthandshake(sslsocketimpl.java:1395)
   at sun.security.ssl.sslsocketimpl.starthandshake(sslsocketimpl.java:1379)
   at com.mysql.jdbc.exportcontrolled.transformsockettosslsocket(exportcontrolled.java:149)
   ... 89 more
mon dec 09 13:15:02 cst 2019 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.
2019-12-09 13:15:02,494 error [com.alibaba.druid.pool.druiddatasource] - <create connection error, url: jdbc:mysql://127.0.0.1:3306/test?useunicode=true&zerodatetimebehavior=converttonull&characterencoding=utf-8, errorcode 0, state 08s01>
com.mysql.jdbc.exceptions.jdbc4.communicationsexception: communications link failure

解决方法

显示配置数据库连接地址usessl=false，如

jdbc:mysql://127.0.0.1:3306/test?useunicode=true&zerodatetimebehavior=converttonull&characterencoding=utf-8&usessl=false

问题延伸

另一种比较麻烦的问题是geoserver也出现了类似连接mysql异常的问题，

报错信息如下：

error [geoserver.ows] -
java.lang.runtimeexception: error getting featuretype, this should never happen!
   at org.geoserver.wms.map.getmapkvprequestreader.checkstyle(getmapkvprequestreader.java:1218)
   at org.geoserver.wms.map.getmapkvprequestreader.read(getmapkvprequestreader.java:566)
   ... 100 more
caused by: java.io.ioexception
   at org.geoserver.catalog.resourcepool.getdatastore(resourcepool.java:632)
   at org.geoserver.catalog.resourcepool.getcacheablefeaturetype(resourcepool.java:916)
   at org.geoserver.catalog.resourcepool.trygetfeaturetype(resourcepool.java:901)
   at org.geoserver.catalog.resourcepool.getfeaturetype(resourcepool.java:893)
   at org.geoserver.catalog.resourcepool.getfeaturetype(resourcepool.java:878)
   ... 111 more
caused by: java.lang.runtimeexception: unable to obtain connection: cannot create poolableconnectionfactory (communications link failure

the last packet successfully received from the server was 2 milliseconds ago. the last packet sent successfully to the server was 2 milliseconds ago.)
   at org.geotools.jdbc.jdbcdatastore.createconnection(jdbcdatastore.java:2186)
   at org.geotools.jdbc.jdbcdatastore.createtypenames(jdbcdatastore.java:978)
   at org.geotools.data.store.contentdatastore.gettypenames(contentdatastore.java:259)
   at org.vfny.geoserver.util.datastoreutils.getdataaccess(datastoreutils.java:88)
   at org.geoserver.catalog.resourcepool.getdatastore(resourcepool.java:591)
   ... 115 more
caused by: org.apache.commons.dbcp.sqlnestedexception: cannot create poolableconnectionfactory (communications link failure

the last packet successfully received from the server was 2 milliseconds ago. the last packet sent successfully to the server was 2 milliseconds ago.)
   at org.apache.commons.dbcp.basicdatasource.createpoolableconnectionfactory(basicdatasource.java:1549)
   at org.apache.commons.dbcp.basicdatasource.createdatasource(basicdatasource.java:1388)
   at org.apache.commons.dbcp.basicdatasource.getconnection(basicdatasource.java:1044)
   at org.geotools.data.jdbc.datasource.abstractmanageabledatasource.getconnection(abstractmanageabledatasource.java:41)
   at org.geotools.jdbc.jdbcdatastore.createconnection(jdbcdatastore.java:2170)
   ... 119 more
caused by: com.mysql.jdbc.exceptions.jdbc4.communicationsexception: communications link failure

the last packet successfully received from the server was 2 milliseconds ago. the last packet sent successfully to the server was 2 milliseconds ago.
   at sun.reflect.nativeconstructoraccessorimpl.newinstance0(native method)
   at sun.reflect.nativeconstructoraccessorimpl.newinstance(nativeconstructoraccessorimpl.java:62)
   at sun.reflect.delegatingconstructoraccessorimpl.newinstance(delegatingconstructoraccessorimpl.java:45)
   at java.lang.reflect.constructor.newinstance(constructor.java:423)
   at com.mysql.jdbc.util.handlenewinstance(util.java:425)
   at com.mysql.jdbc.sqlerror.createcommunicationsexception(sqlerror.java:990)
   ... 143 more
caused by: javax.net.ssl.sslexception: unsupported record version unknown-0.0
   at sun.security.ssl.inputrecord.checkrecordversion(inputrecord.java:552)
   at sun.security.ssl.inputrecord.readv3record(inputrecord.java:565)
   at sun.security.ssl.inputrecord.read(inputrecord.java:529)
   at sun.security.ssl.sslsocketimpl.readrecord(sslsocketimpl.java:975)
   at sun.security.ssl.sslsocketimpl.performinitialhandshake(sslsocketimpl.java:1367)
   at sun.security.ssl.sslsocketimpl.starthandshake(sslsocketimpl.java:1395)
   at sun.security.ssl.sslsocketimpl.starthandshake(sslsocketimpl.java:1379)
   at com.mysql.jdbc.exportcontrolled.transformsockettosslsocket(exportcontrolled.java:186)
   ... 142 more