[keycloak-user] Database backend issue

[Vlasta Ramik]

Hello Andrew,

we use MariaDB 10.1.x for keycloak, can you try it?

V.

On 3/4/19 9:39 PM, Andrew Meyer wrote:
> Hello,
> I am trying to setup Keycloak on CentOS 7 (latest).  This is a standalone machine.
>
> My remote MariaDB server is running 10.2.x latest.
>
> I was trying to run Keycloak latest with mysql-java-connector-5.1.46 and got the following results:
> Caused by: java.lang.RuntimeException: Failed to connect to database        at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.getConnection(DefaultJpaConnectionProviderFactory.java:381)        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:678)        at org.keycloak.connections.jpa.updater.liquibase.lock.LiquibaseDBLockProvider.waitForLock(LiquibaseDBLockProvider.java:95)        at org.keycloak.services.resources.KeycloakApplication$1.run(KeycloakApplication.java:148)        at org.keycloak.models.utils.KeycloakModelUtils.runJobInTransaction(KeycloakModelUtils.java:227)        at org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:141)        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:154)        ... 31 moreCaused 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:239)        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:374)        ... 43 more
>
> I have tried using newer versions of the connector with the same result.
>
> _______________________________________________
> keycloak-user mailing list
> keycloak-user at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user