Re: [keycloak-dev] Error deploying Keycloak over MariaDB

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? _______________________________________________ keycloak-dev mailing list keycloak-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/keycloak-dev