[keycloak-user] Error with Postgres datasource

Wed May 10 10:48:45 EDT 2017

No problem, I glad that it worked.

On Wed, May 10, 2017 at 11:46 AM <sesnor.silva at sapo.pt> wrote:

> Hello,
>
> Well this is embarrassing. I was naming my postgres' module directly
> incorrectly:
>
> I had: modules\system\layers\keycloak\org\postgres
> Instead of: modules\system\layers\keycloak\org\postgresql
>
> Can't believe I missed that, it works perfectly now.
>
> Thank you so much for your time.
>
> Best regards,
> Silva
>
>
> Citando Bruno Oliveira <bruno at abstractj.org>:
>
> Can you connect to the database with the same user provided at
> standalone.xml? Using pgAdmin for example? To me, still seems like a
> database misconfiguration. Although, I don't have Windows to try.
>
> On 2017-05-09, sesnor.silva at sapo.pt wrote:
>
> Hello,
>
> Thank you for your reply,
>
> Sadly it doesn't seem to budge. Even by copy-pasting your exact
> configuration (changing the username/password for postgres of course).
>
> What I find especially strange is the following part of the error: "Caused
> by: javax.naming.NameNotFoundException: datasources/KeycloakDS [Root
> exception is java.lang.IllegalStateException]"
>
> Also, I'm running on Windows 8.1 64-bit currently.
>
> What else could I try?
>
> My best regards,
> Silva
>
>
> Citando Bruno Oliveira <bruno at abstractj.org>:
>
> I just ran the entire DB setup from scratch with KC 3.1.0 and got
> postgresql working with no issues.
>
> Looking at your config, you do not specify PostgreSQL TCP port, plus
> make sure you have the proper permissions into pg_hba.conf and of
> course, the database.
> I'm sending gist[1] with my configuration, to get you started. I hope it
> helps.
>
> [1] - https://gist.github.com/abstractj/a154e452ed63c9ccab9578a713955670
>
> On 2017-05-08, sesnor.silva at sapo.pt wrote:
> > 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/database.html
> >
> > 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 at lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/keycloak-user
>
> --
> abstractj
>
>
>
> --
> abstractj
>
>
>
>