[prev in list] [next in list] [prev in thread] [next in thread]
List: keycloak-user
Subject: [keycloak-user] Keycloak 3.4 and Oracle Timesten
From: upananda.singha () motorolasolutions ! com (Upananda Singha)
Date: 2018-02-05 11:53:02
Message-ID: CAEYbobtHiLzwf1cTmFSUTSb+KbvCRG0n9QjGLRL4TpGrwFG2SQ () mail ! gmail ! com
[Download RAW message or body]
Hi Hynek,
Thanks for the clarification and valuable information regarding Keycloak
and T10 integration.
Thanks & Regds,
*Upananda Singha*
On Fri, Feb 2, 2018 at 1:55 PM, Hynek Mlnarik <hmlnarik at redhat.com> wrote:
> The cause is in "Unknown database: TimesTen" message from Liquibase -
> Liquibase does not recognize the dialect and thus refuses to operate.
> Liquibase is used to create the initial DB schema. You may try implement
> class to support TimesTen similarly to EnterpriseDB [1, 2] since TimesTen
> should be compatible with other Oracle Database products. Feel free to
> raise a RFE though we cannot promise it would be picked anytime soon.
>
> [1] https://github.com/keycloak/keycloak/blob/3.4.3.
> Final/model/jpa/src/main/java/org/keycloak/connections/jpa/
> updater/liquibase/PostgresPlusDatabase.java
> <https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_keycloak_keycloak_b \
> lob_3.4.3.Final_model_jpa_src_main_java_org_keycloak_connections_jpa_updater_liquiba \
> se_PostgresPlusDatabase.java&d=DwMFaQ&c=q3cDpHe1hF8lXU5EFjNM_A&r=fnL-WrNGfASFY7eMCgE \
> WnE1LbeED__ZIPJpCDtbxlttGlAbO8wOPfPe7UlrYdGpD&m=M_NQepw04l8msAF6aZxtD29U3XFiHpK1GGTQR_mP1H4&s=PGg7LoKCoXzSRZzSCzXeYhROwrqIwypOoXTGPqF3aBQ&e=>
> [2] https://github.com/keycloak/keycloak/blob/3.4.3.
> Final/model/jpa/src/main/java/org/keycloak/connections/jpa/
> updater/liquibase/conn/DefaultLiquibaseConnectionProvider.java#L95
> <https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_keycloak_keycloak_b \
> lob_3.4.3.Final_model_jpa_src_main_java_org_keycloak_connections_jpa_updater_liquiba \
> se_conn_DefaultLiquibaseConnectionProvider.java-23L95&d=DwMFaQ&c=q3cDpHe1hF8lXU5EFjN \
> M_A&r=fnL-WrNGfASFY7eMCgEWnE1LbeED__ZIPJpCDtbxlttGlAbO8wOPfPe7UlrYdGpD&m=M_NQepw04l8 \
> msAF6aZxtD29U3XFiHpK1GGTQR_mP1H4&s=nZcR4A_1bzv4Ui6DTb46FCWq9B6JhmRnDp4Vl-J0knE&e=>
> On Thu, Feb 1, 2018 at 7:42 AM, Upananda Singha <upananda.singha@
> motorolasolutions.com> wrote:
>
> > Hi All,
> >
> > Please find the configurations I am having for Timesten...
> >
> >
> > <datasource jndi-name="java:jboss/datasources/KeycloakDS"
> > pool-name="KeycloakDS" enabled="true" use-java-context="true">
> > <connection-url>jdbc:timesten:client:TTC_Server=172.27.9.23;
> > TTC_Server_DSN=DG_010231;TCP_PORT=53389;uid=testuser;pwd=tes
> > tpwd;tcp_timeout=180</connection-url>
> > <driver>TimesTenDriver</driver>
> > <pool><max-pool-size>20</max-pool-size></pool> <security>
> > <user-name>testuser</user-name> <password>testpwd</password> </security>
> > </datasource> <drivers> <driver name="TimesTenDriver"
> > module="com.timesten">
> > <xa-datasource-class>com.timesten.jdbc.xa.TimesTenXADataSour
> > ce</xa-datasource-class>
> > </driver> module.xml configuration ("<Keycloak
> > HOME>/modules/system/layers/keycloak/com/timesten/main/module.xml")
> > ------------------------ <?xml version="1.0" ?> <module
> > xmlns="urn:jboss:module:1.3" name="com.timesten"> <resources>
> > <resource-root path="ttjdbc8.jar"/> </resources> <dependencies> <module
> > name="javax.api"/> <module name="javax.transaction.api"/> </dependencies>
> > </module>
> >
> >
> > My LD_LIBRARY_PATH is havng all the Timesten libraries
> > ------------------------------------------------------ libodbc.so
> > libttclasses.so.gcc410 libttco.so libttJdbc.so libttutilD.so ttjdbc6.jar
> > libttclassesCS.so libttclient.so libttco.so.noplsql libttjmsxla.so
> > libttutil.so ttjdbc7.jar libttclassesCS.so.gcc346 libttclient.so.gcc346
> > libttcrs.so libttorD.so orai18n.jar ttjdbc8.jar libttclassesCS.so.gcc410
> > libttclient.so.gcc410 libttenD.so libttor.so README.TXT ucp.jar
> > libttclasses.so libttcoD.so libtten.so libttplD.so timestenjmsxla.jar
> > libttclasses.so.gcc346 libttcoD.so.noplsql libttJdbcCS.so libttpl.so
> > ttjdbc5.jar
> >
> >
> >
> > I am getting he below error:
> >
> > 11:57:08,980 INFO [org.keycloak.services] (ServerService Thread Pool --
> > 51)
> > KC-SERVICES0001: Loading config from standalone.xml or domain.xml
> > 11:57:09,342 INFO [org.jboss.as.clustering.infinispan] (ServerService
> > Thread Pool -- 51) WFLYCLINF0002: Started realmRevisions cache from
> > keycloak container 11:57:09,352 INFO [org.jboss.as.clustering.infinispan]
> > (ServerService Thread Pool -- 51) WFLYCLINF0002: Started userRevisions
> > cache from keycloak container 11:57:09,359 INFO
> > [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 51)
> > WFLYCLINF0002: Started authorizationRevisions cache from keycloak
> > container
> > 11:57:09,359 INFO
> > [org.keycloak.connections.infinispan.DefaultInfinispanConnec
> > tionProviderFactory]
> > (ServerService Thread Pool -- 51) Node name: proc500_9_23, Site name: null
> > 11:57:09,940 ERROR [stderr] (ServerService Thread Pool -- 51) WARNING
> > 2/1/18 11:57 AM: liquibase: Unknown database: TimesTen 11:57:10,108 WARN
> > [org.keycloak.connections.jpa.updater.liquibase.lock.CustomLockService]
> > (ServerService Thread Pool -- 51) Failed to create lock table. Maybe other
> > transaction created in the meantime. Retrying... 11:57:10,111 ERROR
> > [stderr] (ServerService Thread Pool -- 51) WARNING 2/1/18 11:57 AM:
> > liquibase: Unknown database: TimesTen 11:57:10,136 WARN
> > [org.keycloak.connections.jpa.updater.liquibase.lock.CustomLockService]
> > (ServerService Thread Pool -- 51) Failed to create lock table. Maybe other
> > transaction created in the meantime. Retrying... 11:57:10,138 ERROR
> > [stderr] (ServerService Thread Pool -- 51) WARNING 2/1/18 11:57 AM:
> > liquibase: Unknown database: TimesTen 11:57:10,166 WARN
> > [org.keycloak.connections.jpa.updater.liquibase.lock.CustomLockService]
> > (ServerService Thread Pool -- 51) Failed to create lock table. Maybe other
> > transaction created in the meantime. Retrying... 11:57:10,169 ERROR
> > [stderr] (ServerService Thread Pool -- 51) WARNING 2/1/18 11:57 AM:
> > liquibase: Unknown database: TimesTen 11:57:10,319 ERROR [stderr]
> > (ServerService Thread Pool -- 51) WARNING 2/1/18 11:57 AM: liquibase:
> > Unknown database: TimesTen 11:57:12,220 ERROR [stderr] (ServerService
> > Thread Pool -- 51) WARNING 2/1/18 11:57 AM: liquibase: Unknown database:
> > TimesTen 11:57:12,253 WARN
> > [org.keycloak.connections.jpa.updater.liquibase.lock.CustomLockService]
> > (ServerService Thread Pool -- 51) Failed to create lock table. Maybe other
> > transaction created in the meantime. Retrying... 11:57:12,255 ERROR
> > [stderr] (ServerService Thread Pool -- 51) WARNING 2/1/18 11:57 AM:
> > liquibase: Unknown database: TimesTen 11:57:12,277 WARN
> > [org.keycloak.connections.jpa.updater.liquibase.lock.CustomLockService]
> > (ServerService Thread Pool -- 51) Failed to create lock table. Maybe other
> > transaction created in the meant
> > ...
> > ...
> > ...
> > 11:57:12,767 INFO
> > [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpa
> > UpdaterProvider]
> > (ServerService Thread Pool -- 51) Initializing database schema. Using
> > changelog META-INF/jpa-changelog-master.xml 11:57:12,794 WARN
> > [org.keycloak.connections.jpa.updater.liquibase.lock.CustomLockService]
> > (ServerService Thread Pool -- 51) Attempt to release lock, which is not
> > owned by current transaction 11:57:12,804 WARN
> > [org.keycloak.connections.jpa.updater.liquibase.lock.CustomLockService]
> > (ServerService Thread Pool -- 51) Attempt to release lock, which is not
> > owned by current transaction 11:57:12,807 INFO [org.jboss.as.server]
> > (Thread-2) WFLYSRV0220: Server shutdown has been requested via an OS
> > signal
> > 11:57:12,819 ERROR [org.jboss.msc.service.fail] (ServerService Thread Pool
> > -- 51) 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.UndertowDeployment
> > Service$1.run(UndertowDeploymentService.java:84)
> > 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(ThreadPool
> > Executor.java:1149)
> > at
> > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo
> > lExecutor.java:624)
> > at java.lang.Thread.run(Thread.java:748) 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(Co
> > nstructorInjectorImpl.java:162)
> > at
> > org.jboss.resteasy.spi.ResteasyProviderFactory.createProvide
> > rInstance(ResteasyProviderFactory.java:2298)
> > at
> > org.jboss.resteasy.spi.ResteasyDeployment.createApplication(
> > ResteasyDeployment.j
> >
> >
> >
> > Thanks & Regds,
> >
> > *Upananda*
> >
> >
> >
> >
> > On Thu, Feb 1, 2018 at 10:46 AM, Upananda Singha <upananda.singha@
> > motorolasolutions.com> wrote:
> >
> > > Hi all,
> > >
> > > I have been trying to configure Keycloak with Oracle Timesten but
> > without
> > > any success.
> > >
> > > Anybody ever tried Timesten as backend Database for Keycloak? It would
> > be
> > > of great help if anyone can give some pointer whether Timesten can be at
> > > all
> > > used with Keycloak 3.4.
> > >
> > > Thanks & regds,
> > >
> > > *Upananda *
> > >
> > >
> > >
> > _______________________________________________
> > keycloak-user mailing list
> > keycloak-user at lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/keycloak-user
> > <https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.jboss.org_mailman_list \
> > info_keycloak-2Duser&d=DwMFaQ&c=q3cDpHe1hF8lXU5EFjNM_A&r=fnL-WrNGfASFY7eMCgEWnE1Lb \
> > eED__ZIPJpCDtbxlttGlAbO8wOPfPe7UlrYdGpD&m=M_NQepw04l8msAF6aZxtD29U3XFiHpK1GGTQR_mP1H4&s=EE6tXlD0nPxD39xPOOPUzALd9LbxTicodzmKxqaAC8s&e=>
> >
>
>
>
> --
>
> --Hynek
>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic