Problem starting openIDM 7.1 after adding MySQL as repository

Tagged: ,

This topic has 0 replies, 1 voice, and was last updated 1 week, 5 days ago by sdklm.

  • Author
    Posts
  • #28567
     sdklm
    Participant

    Hello,
    I want to add MySQL database as openIDM repository
    I added mysql-connector-java-8.0.25.jar in bundle folder
    I added datasource.jdbc-default.json and repo.jdbc.json in conf folder
    I desactivated comment on following keys in boot.properties file and I changed their values
    • openidm.repo.host=localhost
    • openidm.repo.port=3306
    I started openIDM and I am unable to connect to MySQL database

    Executing ./startup.sh…
    /usr/bin/java
    Using OPENIDM_HOME: /home/sylvain/openidm
    Using PROJECT_HOME: /home/sylvain/openidm
    Using OPENIDM_OPTS: -Xmx2048m -Xms2048m
    Using LOGGING_CONFIG: -Djava.util.logging.config.file=/home/sylvain/openidm/conf/logging.properties
    WARNING: An illegal reflective access operation has occurred
    WARNING: Illegal reflective access by org.apache.felix.framework.ext.ClassPathExtenderFactory$DefaultClassLoaderExtender (file:/home/sylvain/openidm/bin/felix.jar) to method java.net.URLClassLoader.addURL(java.net.URL)
    WARNING: Please consider reporting this to the maintainers of org.apache.felix.framework.ext.ClassPathExtenderFactory$DefaultClassLoaderExtender
    WARNING: Use –illegal-access=warn to enable warnings of further illegal reflective access operations
    WARNING: All illegal access operations will be denied in a future release
    -> Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class iscom.mysql.cj.jdbc.Driver’. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
    [18] juin 11, 2021 9:58:09.025 AM com.zaxxer.hikari.util.DriverDataSource <init>
    AVERTISSEMENT: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
    [18] juin 11, 2021 9:58:39.140 AM org.forgerock.openidm.datasource.jdbc.impl.JDBCDataSourceService lambda$initDataSourceService$1
    AVERTISSEMENT: Unable to establish connection: ea344596-838f-44d8-bae2-8760d1379e14 – Connection is not available, request timed out after 30030ms., next attempt at Fri Jun 11 09:58:44 CEST 2021
    [18] juin 11, 2021 9:59:14.147 AM org.forgerock.openidm.datasource.jdbc.impl.JDBCDataSourceService lambda$initDataSourceService$1
    AVERTISSEMENT: Unable to establish connection: ea344596-838f-44d8-bae2-8760d1379e14 – Connection is not available, request timed out after 30003ms., next attempt at Fri Jun 11 09:59:24 CEST 2021
    [18] juin 11, 2021 9:59:54.158 AM org.forgerock.openidm.datasource.jdbc.impl.JDBCDataSourceService lambda$initDataSourceService$1
    AVERTISSEMENT: Unable to establish connection: ea344596-838f-44d8-bae2-8760d1379e14 – Connection is not available, request timed out after 30004ms., next attempt at Fri Jun 11 10:00:09 CEST 2021
    [18] juin 11, 2021 10:00:39.168 AM org.forgerock.openidm.datasource.jdbc.impl.JDBCDataSourceService lambda$initDataSourceService$1
    AVERTISSEMENT: Unable to establish connection: ea344596-838f-44d8-bae2-8760d1379e14 – Connection is not available, request timed out after 30001ms., next attempt at Fri Jun 11 10:00:59 CEST 2021

    Do you have any ideas about how to solve this problem? Thanks for your help

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

©2021 ForgeRock - we provide an identity and access platform to secure every online relationship for the enterprise market, educational sector and even entire countries. Click to view our privacy policy and terms of use.

Log in with your credentials

Forgot your details?