[Bug]: Keyclock with postgress service defauth auth error

[isbool]

Error Message and Logs

2025-03-07T13:21:27.760613349Z Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "YHrcNFQhf8EV7Ytm"
2025-03-07T13:21:27.760622815Z at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:711)
2025-03-07T13:21:27.760631962Z at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:213)
2025-03-07T13:21:27.760641220Z at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:268)
2025-03-07T13:21:27.760652996Z at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54)
2025-03-07T13:21:27.760671772Z at org.postgresql.jdbc.PgConnection.(PgConnection.java:273)
2025-03-07T13:21:27.760692402Z at org.postgresql.Driver.makeConnection(Driver.java:446)
2025-03-07T13:21:27.760707937Z at org.postgresql.Driver.connect(Driver.java:298)
2025-03-07T13:21:27.760716866Z at io.agroal.pool.ConnectionFactory.createConnection(ConnectionFactory.java:225)
2025-03-07T13:21:27.760725733Z at io.agroal.pool.ConnectionPool$CreateConnectionTask.call(ConnectionPool.java:580)
2025-03-07T13:21:27.760735008Z at io.agroal.pool.ConnectionPool$CreateConnectionTask.call(ConnectionPool.java:561)
2025-03-07T13:21:27.760743910Z at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
2025-03-07T13:21:27.760754887Z at io.agroal.pool.util.PriorityScheduledExecutor.beforeExecute(PriorityScheduledExecutor.java:75)
2025-03-07T13:21:27.760772909Z at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
2025-03-07T13:21:27.760790445Z at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
2025-03-07T13:21:27.760809258Z ... 1 more
2025-03-07T13:21:27.760825443Z
2025-03-07T13:21:28.202884380Z 2025-03-07 15:21:28,202 INFO [org.infinispan.CONTAINER] (ForkJoinPool.commonPool-worker-1) ISPN000556: Starting user marshaller 'org.infinispan.commons.marshall.ImmutableProtoStreamMarshaller'
2025-03-07T13:21:28.956318174Z 2025-03-07 15:21:28,954 WARN [org.jgroups.stack.Configurator] (ForkJoinPool.commonPool-worker-1) JGRP000014: ThreadPool.thread_dumps_threshold has been deprecated: ignored
2025-03-07T13:21:28.998766723Z 2025-03-07 15:21:28,997 INFO [org.infinispan.CLUSTER] (ForkJoinPool.commonPool-worker-1) ISPN000078: Starting JGroups channel ISPN with stack udp
2025-03-07T13:21:29.015429439Z 2025-03-07 15:21:29,015 INFO [org.jgroups.JChannel] (ForkJoinPool.commonPool-worker-1) local_addr: dbee9547-7389-4519-8763-bf94ad4ff97e, name: 77e5fcd96564-64676
2025-03-07T13:21:29.028127471Z 2025-03-07 15:21:29,027 WARN [org.jgroups.protocols.UDP] (ForkJoinPool.commonPool-worker-1) JGRP000015: the send buffer of socket MulticastSocket was set to 1MB, but the OS only allocated 212.99KB
2025-03-07T13:21:29.028646117Z 2025-03-07 15:21:29,028 WARN [org.jgroups.protocols.UDP] (ForkJoinPool.commonPool-worker-1) JGRP000015: the receive buffer of socket MulticastSocket was set to 20MB, but the OS only allocated 212.99KB
2025-03-07T13:21:29.029080286Z 2025-03-07 15:21:29,028 WARN [org.jgroups.protocols.UDP] (ForkJoinPool.commonPool-worker-1) JGRP000015: the send buffer of socket MulticastSocket was set to 1MB, but the OS only allocated 212.99KB
2025-03-07T13:21:29.029529511Z 2025-03-07 15:21:29,029 WARN [org.jgroups.protocols.UDP] (ForkJoinPool.commonPool-worker-1) JGRP000015: the receive buffer of socket MulticastSocket was set to 25MB, but the OS only allocated 212.99KB
2025-03-07T13:21:29.083625734Z 2025-03-07 15:21:29,083 INFO [org.jgroups.protocols.FD_SOCK2] (ForkJoinPool.commonPool-worker-1) server listening on *.40053
2025-03-07T13:21:29.334757876Z 2025-03-07 15:21:29,334 WARN [io.quarkus.hibernate.orm.runtime.service.QuarkusRuntimeInitDialectFactory] (JPA Startup Thread) Persistence unit keycloak-default: Could not retrieve the database version to check it is at least 12.0.0
2025-03-07T13:21:29.417532233Z 2025-03-07 15:21:29,413 WARN [io.agroal.pool] (agroal-11) Datasource '': FATAL: password authentication failed for user "YHrcNFQhf8EV7Ytm"
2025-03-07T13:21:29.417559621Z 2025-03-07 15:21:29,415 INFO [com.arjuna.ats.jbossatx] (main) ARJUNA032014: Stopping transaction recovery manager
2025-03-07T13:21:29.476086827Z 2025-03-07 15:21:29,475 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: Failed to start server in (production) mode
2025-03-07T13:21:29.476257639Z 2025-03-07 15:21:29,475 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: Failed to obtain JDBC connection
2025-03-07T13:21:29.476564886Z 2025-03-07 15:21:29,476 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: FATAL: password authentication failed for user "YHrcNFQhf8EV7Ytm"
2025-03-07T13:21:29.476823998Z 2025-03-07 15:21:29,476 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) For more details run the same command passing the '--verbose' option. Also you can use '--help' to see the details about the usage of the particular command.
2025-03-07T13:21:45.729222941Z 2025-03-07 15:21:45,726 INFO [org.keycloak.quarkus.runtime.storage.infinispan.CacheManagerFactory] (main) Starting Infinispan embedded cache manager
2025-03-07T13:21:46.788957508Z 2025-03-07 15:21:46,787 WARN [io.agroal.pool] (agroal-11) Datasource '': FATAL: password authentication failed for user "YHrcNFQhf8EV7Ytm"
2025-03-07T13:21:46.790929056Z 2025-03-07 15:21:46,790 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (JPA Startup Thread) SQL Error: 0, SQLState: 28P01
2025-03-07T13:21:46.791139547Z 2025-03-07 15:21:46,790 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (JPA Startup Thread) FATAL: password authentication failed for user "YHrcNFQhf8EV7Ytm"
2025-03-07T13:21:46.796277637Z 2025-03-07 15:21:46,792 WARN [org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator] (JPA Startup Thread) HHH000342: Could not obtain connection to query metadata: org.hibernate.exception.GenericJDBCException: unable to obtain isolated JDBC connection [FATAL: password authentication failed for user "YHrcNFQhf8EV7Ytm"] [n/a]
2025-03-07T13:21:46.796303949Z at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:63)
2025-03-07T13:21:46.796314452Z at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:108)
2025-03-07T13:21:46.796323165Z at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:94)
2025-03-07T13:21:46.796331415Z at org.hibernate.resource.transaction.backend.jta.internal.JtaIsolationDelegate.doTheWork(JtaIsolationDelegate.java:202)
2025-03-07T13:21:46.796340153Z at org.hibernate.resource.transaction.backend.jta.internal.JtaIsolationDelegate.lambda$delegateWork$3(JtaIsolationDelegate.java:91)
2025-03-07T13:21:46.796348750Z at org.hibernate.resource.transaction.backend.jta.internal.JtaIsolationDelegate.doInSuspendedTransaction(JtaIsolationDelegate.java:123)
2025-03-07T13:21:46.796357421Z at org.hibernate.resource.transaction.backend.jta.internal.JtaIsolationDelegate.delegateWork(JtaIsolationDelegate.java:88)
2025-03-07T13:21:46.796365794Z at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.getJdbcEnvironmentUsingJdbcMetadata(JdbcEnvironmentInitiator.java:321)
2025-03-07T13:21:46.796374470Z at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:130)
2025-03-07T13:21:46.796383070Z at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:82)
2025-03-07T13:21:46.796391640Z at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:130)
2025-03-07T13:21:46.796400252Z at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263)
2025-03-07T13:21:46.796408994Z at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:238)
2025-03-07T13:21:46.796417704Z at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:215)
2025-03-07T13:21:46.796427737Z at org.hibernate.service.ServiceRegistry.requireService(ServiceRegistry.java:68)
2025-03-07T13:21:46.796436955Z at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:52)
2025-03-07T13:21:46.796445424Z at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:136)
2025-03-07T13:21:46.796466313Z at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:247)
2025-03-07T13:21:46.796476581Z at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:215)
2025-03-07T13:21:46.796485197Z at org.hibernate.service.ServiceRegistry.requireService(ServiceRegistry.java:68)
2025-03-07T13:21:46.796493616Z at org.hibernate.boot.internal.SessionFactoryOptionsBuilder.(SessionFactoryOptionsBuilder.java:290)
2025-03-07T13:21:46.796502495Z at io.quarkus.hibernate.orm.runtime.recording.PrevalidatedQuarkusMetadata.buildSessionFactoryOptionsBuilder(PrevalidatedQuarkusMetadata.java:72)
2025-03-07T13:21:46.796511277Z at io.quarkus.hibernate.orm.runtime.boot.FastBootEntityManagerFactoryBuilder.build(FastBootEntityManagerFactoryBuilder.java:84)
2025-03-07T13:21:46.796519880Z at io.quarkus.hibernate.orm.runtime.FastBootHibernatePersistenceProvider.createEntityManagerFactory(FastBootHibernatePersistenceProvider.java:73)
2025-03-07T13:21:46.796528699Z at jakarta.persistence.Persistence.createEntityManagerFactory(Persistence.java:80)
2025-03-07T13:21:46.796537237Z at jakarta.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)
2025-03-07T13:21:46.796545793Z at io.quarkus.hibernate.orm.runtime.JPAConfig$LazyPersistenceUnit.get(JPAConfig.java:154)
2025-03-07T13:21:46.796554252Z at io.quarkus.hibernate.orm.runtime.JPAConfig$1.run(JPAConfig.java:61)
2025-03-07T13:21:46.796562856Z at java.base/java.lang.Thread.run(Thread.java:1583)
2025-03-07T13:21:46.796571106Z Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "YHrcNFQhf8EV7Ytm"
2025-03-07T13:21:46.796579872Z at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:711)
2025-03-07T13:21:46.796588318Z at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:213)
2025-03-07T13:21:46.796596950Z at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:268)
2025-03-07T13:21:46.796605421Z at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54)
2025-03-07T13:21:46.796614046Z at org.postgresql.jdbc.PgConnection.(PgConnection.java:273)
2025-03-07T13:21:46.796627079Z at org.postgresql.Driver.makeConnection(Driver.java:446)
2025-03-07T13:21:46.796642668Z at org.postgresql.Driver.connect(Driver.java:298)
2025-03-07T13:21:46.796655513Z at io.agroal.pool.ConnectionFactory.createConnection(ConnectionFactory.java:225)
2025-03-07T13:21:46.796664010Z at io.agroal.pool.ConnectionPool$CreateConnectionTask.call(ConnectionPool.java:580)
2025-03-07T13:21:46.796672572Z at io.agroal.pool.ConnectionPool$CreateConnectionTask.call(ConnectionPool.java:561)
2025-03-07T13:21:46.796681029Z at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
2025-03-07T13:21:46.796689482Z at io.agroal.pool.util.PriorityScheduledExecutor.beforeExecute(PriorityScheduledExecutor.java:75)
2025-03-07T13:21:46.796706253Z at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
2025-03-07T13:21:46.796715918Z at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
2025-03-07T13:21:46.796724412Z ... 1 more
2025-03-07T13:21:46.796732552Z
2025-03-07T13:21:47.230993996Z 2025-03-07 15:21:47,230 INFO [org.infinispan.CONTAINER] (ForkJoinPool.commonPool-worker-1) ISPN000556: Starting user marshaller 'org.infinispan.commons.marshall.ImmutableProtoStreamMarshaller'
2025-03-07T13:21:47.696869958Z 2025-03-07 15:21:47,696 WARN [org.jgroups.stack.Configurator] (ForkJoinPool.commonPool-worker-1) JGRP000014: ThreadPool.thread_dumps_threshold has been deprecated: ignored
2025-03-07T13:21:47.710955630Z 2025-03-07 15:21:47,708 INFO [org.infinispan.CLUSTER] (ForkJoinPool.commonPool-worker-1) ISPN000078: Starting JGroups channel ISPN with stack udp
2025-03-07T13:21:47.711012548Z 2025-03-07 15:21:47,710 INFO [org.jgroups.JChannel] (ForkJoinPool.commonPool-worker-1) local_addr: 6cabe8d2-d038-4cec-aeea-be15e37b6032, name: 77e5fcd96564-9305
2025-03-07T13:21:47.718327893Z 2025-03-07 15:21:47,718 WARN [org.jgroups.protocols.UDP] (ForkJoinPool.commonPool-worker-1) JGRP000015: the send buffer of socket MulticastSocket was set to 1MB, but the OS only allocated 212.99KB
2025-03-07T13:21:47.718636295Z 2025-03-07 15:21:47,718 WARN [org.jgroups.protocols.UDP] (ForkJoinPool.commonPool-worker-1) JGRP000015: the receive buffer of socket MulticastSocket was set to 20MB, but the OS only allocated 212.99KB
2025-03-07T13:21:47.718980046Z 2025-03-07 15:21:47,718 WARN [org.jgroups.protocols.UDP] (ForkJoinPool.commonPool-worker-1) JGRP000015: the send buffer of socket MulticastSocket was set to 1MB, but the OS only allocated 212.99KB
2025-03-07T13:21:47.719268507Z 2025-03-07 15:21:47,719 WARN [org.jgroups.protocols.UDP] (ForkJoinPool.commonPool-worker-1) JGRP000015: the receive buffer of socket MulticastSocket was set to 25MB, but the OS only allocated 212.99KB
2025-03-07T13:21:47.735999260Z 2025-03-07 15:21:47,733 INFO [org.jgroups.protocols.FD_SOCK2] (ForkJoinPool.commonPool-worker-1) server listening on *.21265
2025-03-07T13:21:48.619089384Z 2025-03-07 15:21:48,617 WARN [io.quarkus.hibernate.orm.runtime.service.QuarkusRuntimeInitDialectFactory] (JPA Startup Thread) Persistence unit keycloak-default: Could not retrieve the database version to check it is at least 12.0.0
2025-03-07T13:21:48.766453249Z 2025-03-07 15:21:48,765 WARN [io.agroal.pool] (agroal-11) Datasource '': FATAL: password authentication failed for user "YHrcNFQhf8EV7Ytm"
2025-03-07T13:21:48.771861205Z 2025-03-07 15:21:48,771 INFO [com.arjuna.ats.jbossatx] (main) ARJUNA032014: Stopping transaction recovery manager
2025-03-07T13:21:48.871459467Z 2025-03-07 15:21:48,870 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: Failed to start server in (production) mode
2025-03-07T13:21:48.871947461Z 2025-03-07 15:21:48,871 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: Failed to obtain JDBC connection
2025-03-07T13:21:48.872335786Z 2025-03-07 15:21:48,871 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: FATAL: password authentication failed for user "YHrcNFQhf8EV7Ytm"
2025-03-07T13:21:48.872589288Z 2025-03-07 15:21:48,872 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) For more details run the same command passing the '--verbose' option. Also you can use '--help' to see the details about the usage of the particular command.
Postgres
Only Show Number of Lines
*
100
Refresh
Stream Logs
Include Timestamps

Refresh to get the logs...

Steps to Reproduce

1.Create a new keyclock with postgress service
2.Click deploy
3.See logs

It fails with default auth for some reason

Example Repository URL

No response

Coolify Version

v4.0.0-beta.398

Are you using Coolify Cloud?

No (self-hosted)

Operating System and Version (self-hosted)

Debian 12

Additional Information

No response