ssh连接mysql遇到的一些问题

最新推荐文章于 2024-05-15 22:03:21 发布
最新推荐文章于 2024-05-15 22:03:21 发布
阅读量6.3k 收藏 2
点赞数 2
分类专栏： ssh 文章标签： ssh mysql intellij linux
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_35182091/article/details/80914684
版权 
 

问题1：连接高版本的MySQL的会要求建立SSL连接

警告: Error while extracting database product name - falling back to empty error codes
org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The server time zone value 'DST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.)
	......
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The server time zone value 'DST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
	at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:280)
	... 84 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The server time zone value 'DST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
	... 85 more
Caused by: java.sql.SQLException: The server time zone value 'DST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
	......
	... 88 more
Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'DST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
	......
	... 95 more	......
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The server time zone value 'DST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
	at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:280)
	... 84 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The server time zone value 'DST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
	... 85 more
Caused by: java.sql.SQLException: The server time zone value 'DST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
	......
	... 88 more
Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'DST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
	......
	... 95 more

 

解决方法：在连接字符串后面添加 ?useSSL=true

 

添加后：

jdbc:mysql://localhost:3306/telebillsystem?useSSL=true

这个问题是解决了但是又出现了新的问题

 

问题2：证书不信任

警告: Error while extracting database product name - falling back to empty error codes
org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure


The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
	......
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure


The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
	at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:280)
	... 84 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure


The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
	... 85 more
Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure


The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
	.......
	... 88 more
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure


The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
	.......
	... 95 more
Caused by: javax.net.ssl.SSLHandshakeException: java.security.cert.CertificateException: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
	.......
	... 102 more
Caused by: java.security.cert.CertificateException: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
	at com.mysql.cj.protocol.ExportControlled$X509TrustManagerWrapper.checkServerTrusted(ExportControlled.java:280)
	at sun.security.ssl.AbstractTrustManagerWrapper.checkServerTrusted(SSLContextImpl.java:984)
	at sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1496)
	... 113 more
Caused by: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
	.......
	... 115 more	......
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure


The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
	at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:280)
	... 84 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure


The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
	... 85 more
Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure


The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
	.......
	... 88 more
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure


The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
	.......
	... 95 more
Caused by: javax.net.ssl.SSLHandshakeException: java.security.cert.CertificateException: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
	.......
	... 102 more
Caused by: java.security.cert.CertificateException: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
	at com.mysql.cj.protocol.ExportControlled$X509TrustManagerWrapper.checkServerTrusted(ExportControlled.java:280)
	at sun.security.ssl.AbstractTrustManagerWrapper.checkServerTrusted(SSLContextImpl.java:984)
	at sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1496)
	... 113 more
Caused by: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
	.......
	... 115 more

解决方法：继续在连接字符串后面添加  ＆amp;verifyServerCertificate=false

参考地址：https：//my.oschina.net/u/2362245/blog/1799475

添加后：

jdbc:mysql://localhost:3306/telebillsystem?useSSL=true&verifyServerCertificate=false

本想着应该好了吧，但是并没有那么幸运，问题又来了

 

问题3：windows和linux时区不同问题

警告: Error while extracting database product name - falling back to empty error codes
org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The server time zone value 'DST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.)
	......
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The server time zone value 'DST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
	at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:280)
	... 84 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The server time zone value 'DST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
	... 85 more
Caused by: java.sql.SQLException: The server time zone value 'DST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
	......
	... 88 more
Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'DST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
	......
	... 95 more
	......
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The server time zone value 'DST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
	at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:280)
	... 84 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The server time zone value 'DST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
	... 85 more
Caused by: java.sql.SQLException: The server time zone value 'DST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
	......
	... 88 more
Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'DST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
	......
	... 95 more

解决方法：在连接字符串后面继续添加   

&amp:serverTimezone=GMT％2B8

参考地址：https：//blog.csdn.net/u010725245/article/details/71195016

 

添加后效果：

 

jdbc:mysql://localhost:3306/telebillsystem?useSSL=true&verifyServerCertificate=false&serverTimezone=GMT％2B8

 

HKMV
关注
  • 2
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 6
    评论
专栏目录
通过ssh连接mysql
Arithmetic-logic
09-24 2478
一.更新yum源 1.备份并替换系统的repo文件 方法1.自动下载repo文件： wget http://mirrors.163.com/.help/CentOS6-Base-163.repo 切换到这个目录 cd /etc/yum.repos.d/ 把这个文件先备份，然后用mv命令把下载好的repo文件移动到这个目录下 mv CentOS-Base.repo CentOS-Base.re...
python 使用ssh 连接mysql 数据库
WIFI下的365
03-24 2022
python 使用ssh 连接mysql 数据库 ssh_host = "x.xxx.xxx.x" # 堡垒机ip地址或主机名 ssh_port = 22 # 堡垒机连接mysql服务器的端口号，一般都是22，必须是数字 ssh_user = "xxxxx" # 这是你在堡垒机上的用户名 ssh_password = "xxxxxxxxxx" # 这是你在堡垒机上的用户密码 mysql_host = "127.0.0.1" # 这是你mysql服务器的主机名或ip地址 mysql_port = 3306 #
Could not get Connection for extracting meta-data; nested exception is org.springframework.jdbc.Cann
weixin_40847029的博客
05-06 8184
Could not get Connection for extracting meta-data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLExce...
java.net.SocketException: Socket closed
whisky_s的博客
12-07 3385
这里写自定义目录标题Error while extracting database name - falling back to empty error codes功能快捷键合理的创建标题，有助于目录的生成如何改变文本的样式插入链接与图片如何插入一段漂亮的代码片生成一个适合你的列表创建一个表格设定内容居中、居左、居右SmartyPants创建一个自定义列表如何创建一个注脚注释也是必不可少的KaTeX数学公式新的甘特图功能，丰富你的文章UML 图表FLowchart流程图导出与导入导出导入 Error whi
如何用代码实现通过SSH连接MySQL数据库
最新发布
懒眉
05-15 109
【代码】如何用代码实现通过SSH连接MySQL数据库。
警告: Error while extracting database product name - falling back to empty error codes
热门推荐
running_snail_的专栏
12-16 1万+
2011-12-16 10:14:24 org.springframework.jdbc.support.SQLErrorCodesFactory getErrorCodes 警告: Error while extracting database product name - falling back to empty error codes org.springframework.jdbc.
项目中mysql数据库连接问题：这里用的是jdbc，c3p0
小冷
10-16 1639
出现这种错： org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta-data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Fail...
org.springframework.jdbc.CannotGetJdbcConnectionException,Could not get JDBC Connection；
weixin_50908797的博客
01-03 194
ssm整合，报错sqlException
利用ssh tunnel链接mysql服务器的方法
09-09
SSH Tunnel（SSH隧道）...通过本文的讲解，你应该掌握了如何设置和使用SSH Tunnel来连接MySQL服务器，以及如何管理和关闭建立的隧道。希望这些信息能对你在学习和工作中有所帮助，如果在实践中遇到问题，欢迎留言讨论。
CI框架出现mysql数据库连接资源无法释放的解决方法
10-22
然而，在使用过程中，可能会遇到一些问题，如数据库连接资源无法释放，导致“Too many connections”错误。本文将深入探讨这个问题的原因以及解决方案。 当CI框架在处理大量并发请求时，如果每个请求都创建一个新的...
mysql图形化界面连接工具（小海豚）
12-17
在安全性方面，小海豚支持多种身份验证机制，包括MySQL原生的认证方式，以及SSH隧道连接，确保数据传输的安全性。用户还可以设置访问权限，控制不同用户对数据库的操作范围。 对于团队协作，小海豚有版本控制和同步...
Struts2+Hibernate+Spring整合报价管理系统(ssh+mysql)
07-02
如果遇到问题，可以通过留言寻求帮助，社区通常会有丰富的资源和经验可供参考。 总之，SSH+MySQL的组合为开发高效稳定的报价管理系统提供了坚实的基础，通过合理的设计和编码实践，可以构建出满足各种业务需求的...
ssh在线考试系统
06-17
在压缩包中，"说明.txt"和"项目安装说明.txt"通常包含了系统部署和运行的详细步骤，可能包括如何配置开发环境（如安装Eclipse、设置JDK、导入SSH项目）、如何创建和连接MySQL数据库、如何启动和运行项目等。...
用SQL语句解决mysql导入大数据文件的问题
09-11
然而，这种方法需要服务器支持SSH连接，不是所有主机提供商都提供这项服务。此外，如果你不具备SSH访问权限或者不熟悉Linux命令行操作，这种方法可能并不适用。在这种情况下，可以考虑以下替代方案： 1. **自定义...
java ssh+mysql大学信息管理系统源码+数据库
09-09
源码的完整性和可用性已经得到验证，但在使用过程中遇到问题时，建议首先检查配置是否正确。 SSH框架详解： 1. Spring：作为核心的依赖注入（DI）和面向切面编程（AOP）框架，Spring提供了管理应用对象生命周期和...
多数据源 mysql8小时断线 No operations allowed after connection closed
lizhongde112的博客
10-30 1331
org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operatio...
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection原因
christian0110的博客
01-02 1019
先检查properties中是否有空格； org.springframework.core.env.PropertySourcesPropertyResolver，这个类会去加载properties中各项属性，但是他先会到环境属性去寻找，再去系统属性去寻找，然后再去系统环境去寻找，如果这期间找到了与property 标签里的name相匹配的key则不继续寻找直接return，否则 retu...
解决：“org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection；”这类问题
dagaizaimengli的博客
03-27 2327
如果检查上面页面，没有错误，就是数据库连接jar包版本太低，可以更换高版本的数据库连接jar。
python ssh mysql_python使用sshtunnel无法连接到mysql
05-18
如果你使用sshtunnel连接MySQL时遇到问题，可能是由于以下原因之一： 1. 确保SSH连接正常：在使用sshtunnel之前，你需要先通过SSH连接到远程服务器。在本地终端上测试SSH连接是否正常，可以使用以下命令： ``` ssh...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 6
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值