Getting error while trying to connect to Aurora MySQL DB cluster from docker container

[Sagun Tumkar]

Hi There,

I have a keycloak cluster running behind the AWS application load balancer. This cluster has 2 nodes and connecting to Auroro MySQL DB cluster. Currently I configured below env variables for DB setup.

KC_DB_URL_HOST = <Aurora DB cluster URL>

KC_TRANSACTION_XA_ENABLED = false

KC_DB_SCHEMA = keycloak

KC_DB_USERNAME = <DB username>

KC_DB_PASSWORD = <DB password>

 This setup was working till now but started breaking after I upgraded to Keycloak 18. I can see in the logs: "[io.quarkus.agroal.runtime.DataSources] (main) Started datasource <default> connected to jdbc:mysql://<My cluster URL>:3306/keycloak" which made me think the connection was successful. 

But I am getting below error and not able to figure out the reason. Am I missing any configuration? 

2022-05-03 04:12:43,506 DEBUG [io.agroal.pool] (agroal-11) Cause: : java.sql.SQLNonTransientConnectionException: Cannot open file:NONE [NONE (No such file or directory)]
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:70)
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:829)
    at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:449)
    at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:242)
    at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
    at com.mysql.cj.jdbc.MysqlDataSource.getConnection(MysqlDataSource.java:416)
    at com.mysql.cj.jdbc.MysqlDataSource.getConnection(MysqlDataSource.java:128)
    at com.mysql.cj.jdbc.MysqlDataSource.getConnection(MysqlDataSource.java:113)
    at com.mysql.cj.jdbc.MysqlXADataSource.getXAConnection(MysqlXADataSource.java:52)
    at io.agroal.pool.ConnectionFactory.createConnection(ConnectionFactory.java:216)
    at io.agroal.pool.ConnectionPool$CreateConnectionTask.call(ConnectionPool.java:513)
    at io.agroal.pool.ConnectionPool$CreateConnectionTask.call(ConnectionPool.java:494)
    at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
    at io.agroal.pool.util.PriorityScheduledExecutor.beforeExecute(PriorityScheduledExecutor.java:75)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1126)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
    at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: com.mysql.cj.exceptions.SSLParamsException: Cannot open file:NONE [NONE (No such file or directory)]
    at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
    at com.mysql.cj.protocol.ExportControlled.getSSLContext(ExportControlled.java:579)
    at com.mysql.cj.protocol.ExportControlled.performTlsHandshake(ExportControlled.java:333)
    at com.mysql.cj.protocol.StandardSocketFactory.performTlsHandshake(StandardSocketFactory.java:194)
    at com.mysql.cj.protocol.a.NativeSocketConnection.performTlsHandshake(NativeSocketConnection.java:101)
    at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:308)
    at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:204)
    at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1369)
    at com.mysql.cj.NativeSession.connect(NativeSession.java:133)
    at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:949)
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:819)
    ... 15 more
Caused by: java.io.FileNotFoundException: NONE (No such file or directory)
    at java.base/java.io.FileInputStream.open0(Native Method)
    at java.base/java.io.FileInputStream.open(FileInputStream.java:219)
    at java.base/java.io.FileInputStream.<init>(FileInputStream.java:157)
    at java.base/java.io.FileInputStream.<init>(FileInputStream.java:112)
    at java.base/sun.net.www.protocol.file.FileURLConnection.connect(FileURLConnection.java:86)
    at java.base/sun.net.www.protocol.file.FileURLConnection.getInputStream(FileURLConnection.java:184)
    at java.base/java.net.URL.openStream(URL.java:1165)
    at com.mysql.cj.protocol.ExportControlled.getSSLContext(ExportControlled.java:558)
    ... 24 more

Thanks,

Sagun