ver: PDI community 7.1
pan env: ubuntu18.04 on win10 / java 1.8.0_292
spoon env: win10 / java 1.8.0_151
mysql driver: mysql-connector-java-5.1.49-bin.jar
mysql ver: 5.7
the Spoon UI runs this ktr just fine.
but when it's executed by pan.sh, things fell apart:
2022/01/04 16:59:21 - clean_ahead.0 - Error occurred while trying to connect to the database
2022/01/04 16:59:21 - clean_ahead.0 -
2022/01/04 16:59:21 - clean_ahead.0 - Error connecting to database: (using class org.gjt.mm.mysql.Driver)
2022/01/04 16:59:21 - clean_ahead.0 - Communications link failure
2022/01/04 16:59:21 - clean_ahead.0 -
2022/01/04 16:59:21 - clean_ahead.0 - The last packet successfully received from the server was 44 milliseconds ago. The last packet sent successfully to the server was 36 milliseconds ago.
any ideas?
------------------------------
Jarod Putz
Service Administrator
Oz Ltd.Co
------------------------------