[keycloak-dev] Error deploying Keycloak over MariaDB

Tech tech at psynd.net
Mon Jan 30 06:20:08 EST 2017


I need to deploy keycloak over MariaDB:

I downloaded the latest version of Keycloak, 2.5.1 and I want to connect
to my DB running over MariaDB.

I'm using the same JDBC driver that I also use for other applications:

I start WildFly, I open the console and I go to Deployment.

I load the mariadb-java-client-1.5.5.jar.

The driver is correctly loaded.

I shutdown the server, I edit the standalone.xml and I add:

<datasource jndi-name="java:jboss/MariaDBDS" pool-name="MariaDBDS">

I restart the server and I can see the new datasource.

I open it, I go to "Connection" and I receive the following error when I
try to test the connection:

12:12:51,248 ERROR [org.jboss.as.controller.management-operation]
(management task-7) WFLYCTL0013: Operation ("test-connection-in-pool")
failed - address: ([
    ("subsystem" => "datasources"),
    ("data-source" => "MariaDBDS")
]) - failure description: "WFLYJCA0040: failed to invoke operation:
WFLYJCA0047: Connection is not valid"

Any idea?

More information about the keycloak-dev mailing list