Problem: Installation of multiple keycloak instances not possible

Problem:

Installation of multiple keycloak instances not possible.
You can see the following error messages:
Join.log

ERROR: Container did not come up healthy
/usr/lib/univention-install/50keycloak.inst: FATAL:

univention-app logs keycloak

2024-07-10T12:45:22.463388917Z  2024-07-10 14:45:22,462 ERROR [org.jgroups.protocols.JDBC_PING] (main) JGRP000215: Failed to delete PingData in database
2024-07-10T12:45:22.496446151Z  2024-07-10 14:45:22,496 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: Failed to start server in (production) mode
2024-07-10T12:45:22.496538217Z  2024-07-10 14:45:22,496 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: Failed to obtain JDBC connection
2024-07-10T12:45:22.496713700Z  2024-07-10 14:45:22,496 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: FATAL: kein pg_hba.conf-Eintrag für Host »10.100.0.12«, Benutzer »keycloak«, Datenbank »keycloak«, SSL an

Solution:

On your first/primary keycloak installation add the pg_hba.conf entry for the other keycloak access to the database

ucr set postgres9/pg_hba/config/01="hostssl keycloak keycloak 10.100.0.12/32 md5
systemctl restart postgresql.service

Make shure you are on an updated postgres version. 9.6 is already end of live. We have theses Articles, to migrate your existing database:

1 Like

This topic was automatically closed after 24 hours. New replies are no longer allowed.

Mastodon