Rundeck MySQL DB Connectivity

[Anandteerth Mathad]

I have the latest version of Rundeck installed on RHEL 9 (Red Hat Enterprise Linux 9).

We're using MySQL 8.4.0 as the backend database, and Rundeck is configured accordingly. The corresponding MySQL Connector/J (8.4.0) JAR file has been placed in the lib directory of the Rundeck installation.

However, when attempting to start Rundeck after the configuration, I encounter the following error:

[] INFO  rundeckapp.Application - The following 1 profile is active: "production"
[] ERROR pool.ConnectionPool - Unable to create initial connections of pool.
java.sql.SQLTransientConnectionException: Could not connect to address=(host=localhost)(port=3306)(type=master) : Could not connect using SHA256 plugin : Could not connect using SHA256 plugin : Cannot find any provider supporting RSA/ECB/OAEPWithSHA-1AndMGF1Padding
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:79) ~[mariadb-java-client-2.7.0.jar!/:?]
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:192) ~[mariadb-java-client-2.7.0.jar!/:?]
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1385) ~[mariadb-java-client-2.7.0.jar!/:?]

Troubleshooting steps already attempted:

• Tried enabling the mysql_native_password plugin, but MySQL 8.4.0 no longer allows this by default.
• Attempted to add additional Java 11 crypto libraries to support required encryption algorithms.
• Uninstalled and reinstalled MySQL to rule out configuration issues.

 I’m looking for additional suggestions or troubleshooting paths to resolve this connection issue between Rundeck and MySQL 8.4.0 — particularly around the SHA256 plugin and missing RSA/ECB/OAEPWithSHA-1AndMGF1Padding provider error. Any insights would be greatly appreciated.  

Thanks.

[rac...@rundeck.com]

Hi, can you test this way?

Regards.