Systemctl status ~]# systemctl status wildfly -l Mysql> GRANT ALL PRIVILEGES ON keycloak.* TO OK, 0 rows affected (0.I cannot start wildfly with "systemctl start wildfly" but I can start it with "/opt/wildfly/bin/launch.sh standalone standalone.xml 192.168.56.200 &" Config file: Query OK, 1 row affected, 2 warnings (0.13 sec) Mysql> CREATE DATABASE keycloak CHARACTER SET utf8 COLLATE utf8_unicode_ci Mysql> CREATE USER IDENTIFIED BY ‘keycloak’ The only issue that you will get here is while starting server for first time, it will take around 10-12 minutes but later on it will work smoothly. Once you do all the above changes keycloak will start working with mysql8. Xa-datasource-class =.jdbc.MysqlXADataSource Password=ADD HERE YOUR DATABASE PASSWORD Īlso you need to add below change in standalone.xmlĪpart from this the other change that i made is Pool-name=“KeycloakDS” enabled=“true” use-java-context=“true”>Ĭonnection-url=jdbc:mysql://localhost:3306/keycloak?useSSL=false&characterEncoding=UTF-8&allowPublicKeyRetrieval=true " datasource jndi-name=“java:jboss/datasources/KeycloakDS” The entry in standalone.xml then will look like this: Under mysql Datasource, you need to add below property as Following changes i have to make in order to make it run I used mysql 8.0.20 with keycloak 10.0.2 along with mysql-connector-java-8.0.20.jar. What I am missing / doing wrong I was able to resolve issue with mysql8. “WFLYCTL0412: Required services that are not installed:” => [ “:jboss/datasources/MySQL is missing ”ġ0:01:31,612 ERROR (Controller Boot Thread) WFLYCTL0013: Operation (“add”) failed - address: ([ “WFLYCTL0180: Services with missing/unavailable dependencies” => [ “WFLYCTL0412: Required services that are not installed:” => , ]) - failure description: “WFLYJCA0114: Failed to load datasource class: .jdbc.Driver”Īnd 10:01:31,559 ERROR (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([ When start via: sh standalone.sh getting: 10:01:17,667 ERROR (ServerService Thread Pool - 32) WFLYCTL0013: Operation ("add") failed - address: ([ With module.xml and mysql-connector-java.8.0.19.jar Based on the documentation created mysql/main folder under Downloaded 9.0.0 version and trying to setup the usage of my local instance of DB.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |