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

5.0.0. You'll have to check the MySQL docs for using option jdbc classes.

Hello Karasawa-san, On Thu, Apr 11, 2019 at 7:08 PM Mizuki Karasawa <kmizuki88(a)yahoo.com&gt; 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(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/keycloak-user _______________________________________________ keycloak-user mailing list keycloak-user(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/keycloak-user