Repository navigation
Certificate based authentication from Keycloak to Postgresql #20760
jameshcovington
started this conversation in
Archive
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
I'm trying to launch the latest keycloak 21.1.1 as a docker container with postgresql 15 as the external database, also part of the same docker-compose project.
I think I've configured postgresql correctly, enabling client ssl authentication through pg_hba.conf and pg_ident.conf
pg_hba.conf:
and pg_ident.conf:
In my database I have a role named application_user, and in my keycloak instance I have a certificate with "CN=keycloak"
However, in all my attempts to configure keycloak with the correct parameters for this connection, the keycloak instance never attempts to send its client certificate. I have gotten the postgresql host certificate validation to succeed, but that's as far as it goes.
Both the keycloak and postgresql certs are signed by the same local root CA.
Here's a snippet of my docker-compose.yml:
Has anyone succeeded with this? Inquiring minds want to know!
All reactions