[keycloak-user] Configuring MySQL JDBC Driver with Keycloak-5.0.0

[Aaron Echols]

You need to update your driver class. Had the same issue coming from 4.8.3
> 5.0.0. You'll have to check the MySQL docs for using option jdbc classes.
This might be it, but I'm not sure without further research:

https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-driver-name.html


https://github.com/keycloak/keycloak/pull/5660/commits/fff753d4fd6ca56279e9e873618ba537e55abeaf#diff-39dac83c21cd39ac45302c6213854e23

I user MariaDB Galera and had to use the optional jdbc class.

https://mariadb.com/kb/en/library/about-mariadb-connector-j/#optional-jdbc-classes
--
Aaron Echols

On Thu, Apr 11, 2019 at 10:56 AM Jan Lieskovsky <jlieskov at redhat.com> wrote:

> Hello Karasawa-san,
>
> On Thu, Apr 11, 2019 at 7:08 PM Mizuki Karasawa <kmizuki88 at yahoo.com>
> wrote:
>
> > Hi,
> > Has anyone successfully load MySQL JDBC driver with Keycloak-5.0.0?
> > Following
> >
> https://www.keycloak.org/docs/5.0/server_installation/index.html#_database
> > , it should be straightforward, but I'm getting error when Keycloak
> starts:
> >
> > 2019-04-10 14:08:12,055 ERROR
> > [org.jboss.as.controller.management-operation] (ServerService Thread Pool
> > -- 28) WFLYCTL0013: Operation ("add") failed - address: ([
> >     ("subsystem" => "datasources"),
> >     ("jdbc-driver" => "mysql")
> > ]) - failure description: "WFLYJCA0041: Failed to load module for driver
> > [org.mysql]"
> > This can be reproduced after driver is configured, before configuring
> > datasource 'KeycloakDS' to user the JDBC driver, following are the steps
> > that i followed:
> >
> > 1. yum install mysql-connector-java
> >
> > 2. mkdir -p /opt/keycloak/modules/system/layers/keycloak/org/mysql/main/
> >
> > 3. cd /opt/keycloak/modules/system/layers/keycloak/org/mysql/main/
> >
> > 4. ln -s /usr/share/java/mysql-connector-java.jar ./
> >
> > 5. cat << EOF > module.xml<?xml version="1.0" encoding="UTF-8"?>
> > <module xmlns="urn:jboss:module:1.3" name="org.mysql">
> >   <resources>
> >     <resource-root path="mysql-connector-jav.jar" />
> >
>
> I think you have a typo here -- missing the 'a' character before the .jar
> suffix:
>
> # rpm -ql mysql-connector-java | grep jar
> /usr/share/java/mysql-connector-java.jar
>
>
> >   </resource>
> >   <dependencies>
> >     <module name="javax.api"/>
> >     <module name="javax.transaction.api"/>
> >   </dependencies>
> > </module>
> > EOF
> >
> > 6. Declare the driver in
> > /opt/keycloak/standalone/configuration/standalone.xml , add the driver to
> > the <drivers> section:
> > <drivers>   ....
> >    <driver name="mysql" module="org.mysql">
> >       <driver-class>org.mysql.jdbc.Driver</driver-class>
> >    </driver></drivers>
> > 7. restart Keycloak
> >
> > Note that changing to various JDBC drivers doesn't make a difference,
> just
> > to test the driver itself is fine, I connect to localhost console via
> > http://localhost:9990, and loaded the driver as the new deployment, and
> > configured the datasource to use the driver seems to be working fine.
> > Does anyone have suggestions what is possibly going on?
> >
>
> HTH
>
>
> >
> > Thanks a lot!
> > Mizuki
> >
>
> Jan
>
>
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > <?xml version="1.0" encoding="UTF-8"?><module
> xmlns="urn:jboss:module:1.3"
> > name="org.mysql">  <resources>    <resource-root
> > path="mysql-connector-java-bin.jar" />  </resource>  <dependencies>
> > <module name="javax.api"/>    <module name="javax.transaction.api"/>
> > </dependencies></module>EOF
> >
> > - Add JDBC driver type to
> > '/opt/keycloak/standalone/configuration/standalone.xml' in <datasources>
> > block as followng:
> >                 <drivers>                    <driver name="h2"
> > module="com.h2database.h2">
> > <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
> >               </driver>                    <driver name="mysql"
> > module="org.mysql">
> > <driver-class>org.mysql.jdbc.Driver</driver-class>
> > </driver>                </drivers>
> > Before I change actual 'KeyclockDS' datasource to use MySQL, I restart
> the
> > service to confirm the JDBC driver is successfully load, but I got
> > following error:
> > 2019-04-10 14:08:12,055 ERROR
> > [org.jboss.as.controller.management-operation] (ServerService Thread Pool
> > -- 28) WFLYCTL0013: Operation ("add") failed - address: ([
> ("subsystem"
> > => "datasources"),    ("jdbc-driver" => "mysql")]) - failure description:
> > "WFLYJCA0041: Failed to load module for driver [org.mysql]"
> > _______________________________________________
> > keycloak-user mailing list
> > keycloak-user at lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/keycloak-user
> _______________________________________________
> keycloak-user mailing list
> keycloak-user at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user
>