ssh连接mysql遇到的一些问题

最新推荐文章于 2024-08-16 11:00:59 发布
最新推荐文章于 2024-08-16 11:00:59 发布
阅读量6.5k 收藏 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
关注
专栏目录
ssh 连接 mysql_通过SSH通道来访问MySQL
weixin_29230773的博客
01-18 2562
许多时候当要使用Mysql时，会遇到如下情况：1. 信息比较重要，希望通信被加密。2. 一些端口，比如3306端口，被路由器禁用。对第一个问题的一个比较直接的解决办法就是更改mysql的代码，或者是使用一些证书，不过这种办法显然不是很简单。这里要介绍另外一种方法，就是利用SSH通道来连接远程的Mysql，方法相当简单。一 建立SSH通道只需要在本地键入如下命令：ssh -fNg -L 3307:1...
使用SSH连接mysql数据库
potvcing的博客
05-15 8635
在项目中遇见了使用ssh连接数据库的问题，在网上查过资料后写了如下的测试代码    1.测试ssh连接数据库
解决Ubuntu16.04下MySQL Workbench无法通过SSH隧道转发连接数据库异常
Eric的专栏
02-18 3163
问题出现的环境： 系统及版本：Ubuntu 16.04LTS MySQL Workbench版本：V6.3.8及以上版本 错误信息： Could not connect the SSH Tunnel  Authentication error, unhandled exception caught in in  tunnel manager, please refer to log
mysql连接ssh网络错误 连接超时,使用SSH软件时，无法通过套接字错误连接到本地MySQL服务器...
weixin_42503069的博客
02-08 276
I am trying to use dplyr to connect to a remote database, that I usually query through a ssh tunnel.I first set up a ssh tunnel like the following:alias tunnel_ncg='ssh -fNg -L 3307:127.0.0.1:3306 mys...
SSH 隧道方式连接 MySQL 服务器
最新发布
Sally_xy的博客
08-16 759
本文介绍通过 Navictat 或 MySQL Workbench 工具以 SSH 隧道方式连接MySQL 服务器的方法。
ssh 隧道 mysql_通过SSH隧道进行MySQL连接
weixin_29446109的博客
01-18 509
这里有三个问题。1 – 现在忘记SSH隧道您不能将MySQL绑定到多个特定IP。第一个bind-address子句被第二个覆盖(因此被忽略)。您的服务器仅侦听99.99.99.99。您可以使用-h localhost连接但不与-h 127.0.0.1连接的原因是在第一种形式中，实际上并不是通过TCP / IP连接，而是通过本地套接字连接。在你的my.cnf中查找一个socket子句。删除一个冗余的...
(已解决)org.springframework.jdbc.CannotGetJdbcConnectionException:Could not get JDBC Connection；nest
热门推荐
qq_50765135的博客
05-12 2万+
记录一个让人气死的错误 ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'lo
SQL中文java报错误_Spring连接MS SQL Server中出现的错误
weixin_30227789的博客
02-25 510
采用Spring中配置Hibernate数据库连接，但边不上SQL Server2000，配置如下：class="org.apache.commons.dbcp.BasicDataSource">com.microsoft.jdbc.sqlserver.SQLServerDriverjdbc:microsoft:sqlserver://cyc:1433;DatabaseName=office...
linux使用ssh连接mysql数据库_通过SSH通道来访问MySQL
weixin_42588877的博客
01-18 1683
许多时候当要使用MySQL时，会遇到如下情况：1. 信息比较重要，希望通信被加密。2. 一些端口，比如3306端口，被路由器禁用。对第一个问题的一个比较直接的解决办法就是更改mysql的代码，或者是使用一些证书，不过这种办法显然不是很简单。这里要介绍另外一种方法，就是利用SSH通道来连接远程的Mysql，方法相当简单。一 建立SSH通道只需要在本地键入如下命令：ssh -fNg -L 3307:1...
利用ssh tunnel链接mysql服务器的方法
09-09
SSH Tunnel（SSH隧道）...通过本文的讲解，你应该掌握了如何设置和使用SSH Tunnel来连接MySQL服务器，以及如何管理和关闭建立的隧道。希望这些信息能对你在学习和工作中有所帮助，如果在实践中遇到问题，欢迎留言讨论。
MySQL连接抛出Authentication Failed错误的分析与解决思路
09-09
在使用MySQL数据库时，可能会遇到“Authentication Failed”错误，这通常意味着客户端在尝试连接数据库时认证失败。错误信息显示“Reading from the stream has failed”，表明在数据传输过程中存在问题。本篇文章将...
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection 问题处理
csdn565973850的博客
07-02 4157
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection问题处理报错信息问题分析 报错信息 2021-07-02 11:08:56,465 INFO [org.jasig.cas.web.flow.InitialFlowSetupAction] - <Setting path for cookies to: /cas/> 2021-07-02 11:09:09,933 ERRO
解决失误导致grails连接mysql错误
_简单_
01-22 273
"D:\Program Files\Java\jdk1.6.0_14\bin\java" -Xmx256M "-Dgrails.home=D:\Program Files\grails-1.2.0" -Dbase.dir=E:\Progect\java\Intellij\ScheduledTasks "-Dtools.jar=D:\Program Files\Java\jdk1.6.0_14\li...
java常见错误以及可能原因集锦
cykxwx
12-10 2166
0、 需要标识符 a) 不在函数内 1、 非法表达式开始 b) 可能:丢失括号 . 2. no data found a) 可能:setInt(1,100)中,没有100这个值 3. 找不到符号 a) 可能:没导入包 4. 指定了无效URL a) 可能:数据库名或IP错误,即连接出错 5. 类路径没有找到 a) 可能: ClassNotFoundExce...
python ssh mysql_python使用sshtunnel无法连接到mysql
05-18
如果你使用sshtunnel连接MySQL时遇到问题，可能是由于以下原因之一： 1. 确保SSH连接正常：在使用sshtunnel之前，你需要先通过SSH连接到远程服务器。在本地终端上测试SSH连接是否正常，可以使用以下命令： ``` ssh username@server_ip ``` 如果SSH连接无法正常工作，则需要解决SSH连接问题。 2. 确保MySQL服务器正在运行：在尝试连接到MySQL服务器之前，确保MySQL服务器正在运行。在远程服务器上使用以下命令检查MySQL服务器是否正在运行： ``` systemctl status mysql ``` 如果MySQL服务器没有运行，则需要启动MySQL服务器。 3. 确认MySQL数据库可以从远程访问：默认情况下，MySQL数据库只允许本地访问。如果你想从远程访问MySQL数据库，则需要修改MySQL配置文件以允许远程访问。在MySQL服务器上，编辑MySQL配置文件（通常位于/ etc / mysql / my.cnf）并添加以下行： ``` bind-address = 0.0.0.0 ``` 然后重新启动MySQL服务器以使更改生效。 4. 确认MySQL用户有足够的权限：在尝试连接到MySQL服务器之前，确保你使用的MySQL用户具有足够的权限来访问所需的数据库。在MySQL服务器上，使用以下命令检查您的MySQL用户权限： ``` SHOW GRANTS FOR 'username'@'localhost'; SHOW GRANTS FOR 'username'@'%'; ``` 如果你的MySQL用户没有足够的权限，则需要更新MySQL用户权限。 5. 检查sshtunnel配置：最后，确保你的sshtunnel配置正确。检查本地和远程端口以及SSH主机和MySQL主机是否正确设置。 如果你仍然无法连接到MySQL，请检查以上步骤并尝试解决任何问题。
评论 6
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值