[keycloak-dev] Error deploying Keycloak over MariaDB

[Bruno Oliveira]

This mailing list is exclusively dedicated to discussions around
Keycloak development.

Please resend your question to keycloak-user mailing list [1] which is a
place for any questions related to installing, setting up, and using
Keycloak.

[1] https://lists.jboss.org/mailman/listinfo/keycloak-user

On 2017-01-30, Tech wrote:
> 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 at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-dev

--

abstractj