Re: [keycloak-user] Keycloak 3.4 and Oracle Timesten

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= testpwd;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.TimesTenXADataSource</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.DefaultInfinispanConnectionPro viderFactory] (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. LiquibaseJpaUpdaterProvider] (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.UndertowDeploymentService$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( ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run( ThreadPoolExecutor.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( ConstructorInjectorImpl.java:162) at org.jboss.resteasy.spi.ResteasyProviderFactory.createProviderInstance( 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(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/keycloak-user