admin管理员组

文章数量:1393116

After updating the database to a new version of Aurora MySQL on AWS, one of the steps no longer executes, and the log displays the following message:

Connection failed. Verify all connection parameters and confirm that the appropriate driver is installed.

The strange thing is that I have the PDI replicated in my local environment, and it connects correctly using the same drivers as on the remote server (mysql-connector-j-8.4.0.jar). I have also tried connecting from PHPStorm, and I can connect without any issues.

As a quick resume this is only happening on the AWS instance where I have the process running twice a day (cron job).

Has anyone encountered the same issue?

I try connecting from my local and instance using same drivers and only fails in aws instance.

I use this drivers:

  • mysql-connector-j-8.0.32.jar
  • mysql-connector-j-8.0.33.jar
  • mysql-connector-j-8.4.0.jar

Also I set useSSL = false and allowPublicKeyRetrieval = true just I read in another solution.

本文标签: Pentaho PDI 93 Can39t connect after upgrade aws aurora mysqlStack Overflow