在尝试使用Kettle连接远程MySQL资源库时遇到问题，虽然能成功连接本地MySQL数据库并创建资源库，但远程连接失败。确认了端口、数据库、地址和凭证的准确性，且本地数据库连接工具可以正常连接远程资源库。错误信息提示通信链接失败，可能是由于网络问题或服务器未响应导致。
kettle无法连接远程资源库！1、却可以连接本地自己的mysql数据库去创建资源库2、本地的数据库连接工具可以连接远程资源库(远程资源库是mysq数据库)3、确定连接的端口，库，地址，用...
kettle无法连接远程资源库！
1、却可以连接本地自己的mysql数据库去创建资源库
2、本地的数据库连接工具可以连接远程资源库(远程资源库是mysq数据库)
3、确定连接的端口，库，地址，用户名密码都正确，因为2成立
报错显示如下：
错误连接数据库 [product] : org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database
Error connecting to database: (using class org.gjt.mm.mysql.Driver)
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.
org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database
Error connecting to database: (using class org.gjt.mm.mysql.Driver)
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.pentaho.di.core.database.Database.normalConnect(Database.java:366)
at org.pentaho.di.core.database.Database.connect(Database.java:315)
at org.pentaho.di.core.database.Database.connect(Database.java:277)
at org.pentaho.di.core.database.Database.connect(Database.java:267)
at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:86)
at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2464)
at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:533)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
。。。。。。。。其他报错省略
展开
扫一扫
833
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
