[keycloak-dev] Error deploying Keycloak over MariaDB

[Tech]

Hello,

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">
    <connection-url>jdbc:mariadb://localhost:3306/KcTbs</connection-url>
    <driver>mariadb-java-client-1.5.5.jar</driver>
    <driver-class>org.mariadb.jdbc.Driver</driver-class>
    <security>
        <user-name>KcUsr</user-name>
        <password>KcPwd</password>
    </security>
    <validation>
        <valid-connection-checker
class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker"/>
        <validate-on-match>true</validate-on-match>
        <background-validation>false</background-validation>
        <exception-sorter
class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLExceptionSorter"/>
    </validation>
</datasource>


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?