Re: [keycloak-user] Error with Postgres datasource

Hello, I'm trying to configure Keycloak 3.1 to use Postgres 9.4 using the documentation provided here: https://keycloak.gitbooks.io/documentation/server_installation/topics/dat... However, running in standalone operation mode, I get the following error:   2017-05-08 17:47:49,096 ERROR [org.jboss.msc.service.fail] (ServerService Thread Pool -- 48) MSC000001: Failed to start service jboss.undertow.deployment.default-server.default-host./auth: org.jboss.msc.service.StartException in service jboss.undertow.deployment.default-server.default-host./auth: java.lang.RuntimeException: RESTEASY003325: Failed to construct public org.keycloak.services.resources.KeycloakApplication(javax.servlet.ServletContext,org.jboss.resteasy.core.Dispatcher)     at org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:85)     at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)     at java.util.concurrent.FutureTask.run(FutureTask.java:266)     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)     at java.lang.Thread.run(Thread.java:745)     at org.jboss.threads.JBossThread.run(JBossThread.java:320) Caused by: java.lang.RuntimeException: RESTEASY003325: Failed to construct public org.keycloak.services.resources.KeycloakApplication(javax.servlet.ServletContext,org.jboss.resteasy.core.Dispatcher)     at org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:162)     at org.jboss.resteasy.spi.ResteasyProviderFactory.createProviderInstance(ResteasyProviderFactory.java:2209)     at org.jboss.resteasy.spi.ResteasyDeployment.createApplication(ResteasyDeployment.java:299)     at org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDeployment.java:240)     at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.init(ServletContainerDispatcher.java:113)     at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.init(HttpServletDispatcher.java:36)     at io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:117)     at org.wildfly.extension.undertow.security.RunAsLifecycleInterceptor.init(RunAsLifecycleInterceptor.java:78)     at io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:103)     at io.undertow.servlet.core.ManagedServlet$DefaultInstanceStrategy.start(ManagedServlet.java:231)     at io.undertow.servlet.core.ManagedServlet.createServlet(ManagedServlet.java:132)     at io.undertow.servlet.core.DeploymentManagerImpl.start(DeploymentManagerImpl.java:526)     at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:101)     at org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:82)     ... 6 more Caused by: java.lang.RuntimeException: Failed to connect to database     at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.getConnection(DefaultJpaConnectionProviderFactory.java:373)     at org.keycloak.connections.jpa.updater.liquibase.lock.LiquibaseDBLockProvider.lazyInit(LiquibaseDBLockProvider.java:65)     at org.keycloak.connections.jpa.updater.liquibase.lock.LiquibaseDBLockProvider.lambda$waitForLock$0(LiquibaseDBLockProvider.java:97)     at org.keycloak.models.utils.KeycloakModelUtils.suspendJtaTransaction(KeycloakModelUtils.java:543)     at org.keycloak.connections.jpa.updater.liquibase.lock.LiquibaseDBLockProvider.waitForLock(LiquibaseDBLockProvider.java:95)     at org.keycloak.services.resources.KeycloakApplication$1.run(KeycloakApplication.java:136)     at org.keycloak.models.utils.KeycloakModelUtils.runJobInTransaction(KeycloakModelUtils.java:227)     at org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:129)     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)     at java.lang.reflect.Constructor.newInstance(Constructor.java:423)     at org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:150)     ... 19 more Caused by: javax.naming.NameNotFoundException: datasources/KeycloakDS [Root exception is java.lang.IllegalStateException]     at org.jboss.as.naming.ServiceBasedNamingStore.lookup(ServiceBasedNamingStore.java:153)     at org.jboss.as.naming.ServiceBasedNamingStore.lookup(ServiceBasedNamingStore.java:83)     at org.jboss.as.naming.NamingContext.lookup(NamingContext.java:207)     at org.jboss.as.naming.NamingContext.lookup(NamingContext.java:184)     at org.jboss.as.naming.InitialContext$DefaultInitialContext.lookup(InitialContext.java:237)     at org.jboss.as.naming.NamingContext.lookup(NamingContext.java:193)     at org.jboss.as.naming.NamingContext.lookup(NamingContext.java:189)     at javax.naming.InitialContext.lookup(InitialContext.java:417)     at javax.naming.InitialContext.lookup(InitialContext.java:417)     at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.getConnection(DefaultJpaConnectionProviderFactory.java:366)     ... 31 more Caused by: java.lang.IllegalStateException     at org.jboss.msc.value.InjectedValue.getValue(InjectedValue.java:47)     at org.jboss.as.naming.service.BinderService.getValue(BinderService.java:138)     at org.jboss.as.naming.service.BinderService.getValue(BinderService.java:46)     at org.jboss.msc.service.ServiceControllerImpl.getValue(ServiceControllerImpl.java:1158)     at org.jboss.as.naming.ServiceBasedNamingStore.lookup(ServiceBasedNamingStore.java:131)     ... 40 more And I'm at a stalemate with the configuration, because I have no idea what I'm doing wrong. I've configured the postgres driver module in keycloak-3.1.0.Final\modules\system\layers\keycloak\org\postgres\main as (postgresql-9.4.1210.jar is present as well): https://pastebin.com/pjwn09gX My standalone.xml is as follows: https://pastebin.com/ggDHZFJx Does anyone have any idea what I could be doing wrong? Did I miss anything on my configuration? Thank you very much for your time, My best regards, Silva   _______________________________________________ keycloak-user mailing list keycloak-user(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/keycloak-user