错误[org.jboss.as.controller.management operation]操作(“添加”)失败地址:([(“子系统”=>“度量”)):java.lang.nullpointerexception

vlf7wbxs  于 2021-08-20  发布在  Java
关注(0)|答案(0)|浏览(224)

我正在尝试使用mysql在本地pc上部署KeyClope
但是,当我尝试运行standalone.sh时,会出现以下错误:

这是我做的数据库配置

  1. <spi name="connectionsJpa">
  2. <provider name="default" enabled="true">
  3. <properties>
  4. <property name="dataSource" value="java:jboss/datasources/KeycloakDS"/>
  5. <!-- <property name="initializeEmpty" value="true"/> -->
  6. <!-- <property name="migrationStrategy" value="update"/> -->
  7. <property name="initializeEmpty" value="false"/>
  8. <property name="migrationStrategy" value="manual"/>
  9. <property name="migrationExport" value="${jboss.home.dir}/keycloak-
  10. database-update.sql"/>
  11. </properties>
  12. </provider>
  13. </spi>

KeyClope数据源更改:-

  1. <datasources>
  2. <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS"
  3. enabled="true" use-java-context="true" statistics-
  4. enabled="${wildfly.datasources.statistics-enabled:${wildfly.statistics-
  5. enabled:false}}">
  6. <connection-
  7. url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE</connection-url>
  8. <driver>h2</driver>
  9. <security>
  10. <user-name>sa</user-name>
  11. <password>sa</password>
  12. </security>
  13. </datasource>
  14. <!--- <datasource jndi-name="java:jboss/datasources/KeycloakDS" pool-
  15. name="KeycloakDS" enabled="true" use-java-context="true" statistics-
  16. enabled="${wildfly.datasources.statistics-enabled:${wildfly.statistics-enabled:false}}">
  17. <connection-
  18. url>jdbc:h2:${jboss.server.data.dir}/keycloak;AUTO_SERVER=TRUE</connection-url>
  19. <driver>h2</driver>
  20. <security>
  21. <user-name>sa</user-name>
  22. <password>sa</password>
  23. </security>
  24. </datasource> -->
  25. <!-- mysql -->
  26. <datasource jndi-name="java:/jboss/datasources/KeycloakDS" pool-name="KeycloakDS"
  27. enabled="true" use-java-context="true" statistics-
  28. enabled="${wildfly.datasources.statistics-enabled:${wildfly.statistics-
  29. enabled:false}}">
  30. <connection-url>jdbc:mysql://localhost:3306/keycloakdata?
  31. useSSL=false&amp;characterEncoding=UTF-8</connection-url>
  32. <driver>mysql</driver>
  33. <pool>
  34. <min-pool-size>5</min-pool-size>
  35. <max-pool-size>15</max-pool-size>
  36. </pool>
  37. <security>
  38. <user-name>user</user-name>
  39. <password>user</password>
  40. </security>
  41. <validation>
  42. <valid-connection-checker class-
  43. name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker"/>
  44. <validate-on-match>true</validate-on-match>
  45. <exception-sorter class-
  46. name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLExceptionSorter"/>
  47. </validation>
  48. </datasource>

声明并加载jdbc驱动程序

  1. <drivers>
  2. <driver name="h2" module="com.h2database.h2">
  3. <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
  4. </driver>
  5. <driver name="mysql" module="com.mysql">
  6. <driver-class>com.mysql.jdbc.Driver</driver-class>
  7. </driver>
  8. </drivers>

我还将模块及其依赖项添加到jboss(jboss cli.sh)

  1. module add --name=com.mysql --resources=/keycloak-
  2. 13.0.1/modules/system/layers/keycloak/com/mysql/main/mysql-connector-java-8.0.23.jar --
  3. dependencies=javax.api,javax.transaction.api

增加keyclaok服务器的超时时间

  1. <local-cache name="actionTokens">
  2. <heap-memory size="-1"/>
  3. <expiration max-idle="-1" interval="900000"/>
  4. </local-cache>
  5. <session-bean>
  6. <stateless>
  7. <bean-instance-pool-ref pool-name="slsb-strict-max-pool"/>
  8. </stateless>
  9. <stateful default-access-timeout="20000" cache-ref="simple" passivation-disabled-
  10. cache-ref="simple"/>
  11. <singleton default-access-timeout="20000"/>
  12. </session-bean>
  13. <pools>
  14. <bean-instance-pools>
  15. <strict-max-pool name="mdb-strict-max-pool" derive-size="from-cpu-count"
  16. instance-acquisition-timeout="20" instance-acquisition-timeout-
  17. unit="MINUTES"/>
  18. <strict-max-pool name="slsb-strict-max-pool" derive-size="from-worker-pools"
  19. instance-acquisition-timeout="20" instance-acquisition-timeout-unit="MINUTES"/>
  20. </bean-instance-pools>
  21. </pools>

我在尝试将mysql服务器连接到KeyClope时参考了以下文章,在《服务器安装和配置指南》中使用mysql数据库和关系数据库设置单独设置KeyClope
完整堆栈跟踪如下所示:


暂无答案!

目前还没有任何答案,快来回答吧!

相关问题