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

[Mizuki Karasawa]

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" />
  </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?

Thanks a lot!
Mizuki












































































































































































































































































<?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]"