unable to connect keycloak with external mysql DB #38507

mehransaeed7810 · 2025-03-27T12:10:00Z

mehransaeed7810
Mar 27, 2025

Before reporting an issue

I have read and understood the above terms for submitting issues, and I understand that my issue may be closed without action if I do not follow them.

Area

No response

Describe the bug

Hello
I am trying to connect keycloak to external postgresql database but connection SSL connection error as

unable to obtain isolated JDBC connection [An error occurred while setting up the SSL connection.] [n/a]


Caused by: org.postgresql.util.PSQLException: An error occurred while setting up the SSL connection.
	at org.postgresql.core.v3.ConnectionFactoryImpl.enableSSL(ConnectionFactoryImpl.java:642)
	at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:201)
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:268)
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54)
	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:273)
	at org.postgresql.Driver.makeConnection(Driver.java:446)

I am running keycloak in kubernetes helm chart and relevant config in the values.yaml is

externalDatabase: host: "db-url" port: 3306 user:keycloak database: keycloak password: "dakjfdla" existingSecret: "" existingSecretHostKey: "" existingSecretPortKey: "" existingSecretUserKey: "" existingSecretDatabaseKey: "" existingSecretPasswordKey: "" jdbcParams: "?sslmode=require" annotations: {}

I tried using the parameter " jdbcParams: "?sslmode=disable" but no luck

Is there any work around for this issue

Version

24.4.13

Regression

The issue is a regression

Expected behavior

It should be able to connect with the external postgresql

Actual behavior

But for some reason its throwing the SSL connection error

How to Reproduce?

connect keycloak with the external postgresql db

Anything else?

No response

sschu · 2025-03-27T14:09:56Z

sschu
Mar 27, 2025
Collaborator

This is most likely not a bug in Keycloak but a configuration problem. Converting this into a question.

0 replies

Navigation Menu

Repository navigation

unable to connect keycloak with external mysql DB #38507

Uh oh!

{{title}}

Uh oh!

Replies: 1 comment

Uh oh!

{{title}}

Uh oh!

Select a reply

Uh oh!

unable to connect keycloak with external mysql DB #38507

Uh oh!

mehransaeed7810 Mar 27, 2025

Before reporting an issue

Area

Describe the bug

Version

Regression

Expected behavior

Actual behavior

How to Reproduce?

Anything else?

Replies: 1 comment

Uh oh!

sschu Mar 27, 2025 Collaborator

mehransaeed7810
Mar 27, 2025

sschu
Mar 27, 2025
Collaborator