General Discussion

 View Only

PDI kettle pan.sh reports "Communications link failure" trying to connect to mysql but Spoon runs fine

  • 1.  PDI kettle pan.sh reports "Communications link failure" trying to connect to mysql but Spoon runs fine

    Posted 01-04-2022 21:22
    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
    ------------------------------