Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Error connecting to database: (us

linux安装kettle，连接mysql数据库报错

Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 
Error connecting to database: (using class org.gjt.mm.mysql.Driver)
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.pentaho.di.core.database.Database.connectUsingClass(Database.java:601)
	at org.pentaho.di.core.database.Database.normalConnect(Database.java:477)
	... 70 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.

---

报错背景

1、docker安装的kettle的web版本  hiromuhota/webspoon

2、把mysql的jar包放入

jar放在docker cp /home/kettle_job/mysql-connector-java-8.0.17.jar 148ecaf4b16d:/usr/local/tomcat/webapps/spoon/WEB-INF/lib

---

解决方案

1、jar放置的位置不对

 docker cp /home/kettle_job/mysql-connector-java-*版本.jar 148ecaf4b16d:/usr/local/tomcat/lib

2、没有修改jar用户组

chown tomcat:tomcat mysql-connector-java-5.1.48.jar 

3、版本不对，版本要求极为严格

mysql-connector-java-5.1.47.jar 

mysql-connector-java-5.1.48.jar 

mysql-connector-java-5.1.49.jar 

这三种都可以！！！！

---