OpenIDM – Set up repository with MySQL

Tagged: ,

This topic has 3 replies, 3 voices, and was last updated 4 years, 4 months ago by srinath.m.

  • Author
    Posts
  • #21231
     srinath.m
    Participant

    Hi,
    I have followed the repository setup with Mysql as mentioned here (https://backstage.forgerock.com/docs/idm/5/install-guide/). I have placed the mysql jar file in bundle folder and imported all the necessary sql’s.

    Issue:
    OpenIDM server is not started and keep on displaying the “WARNING: Unable to get DataSource connection. Next attempt at Mon Mar 19 15:37:18 IST 2018”.

    Below are my logs:

    Mar 19, 2018 3:37:11 PM org.forgerock.openidm.core.FilePropertyAccessor loadProps
    INFO: Using properties at D:\XXXX\ForgeRock\IDM-eval-5.5.0\openidm\conf\boot\boot.properties
    Mar 19, 2018 3:37:11 PM org.forgerock.openidm.core.FilePropertyAccessor loadProps
    INFO: Using properties at D:\XXXX\ForgeRock\IDM-eval-5.5.0\openidm\conf\boot\boot.properties
    Mar 19, 2018 3:37:11 PM org.forgerock.openidm.config.crypto.ConfigCrypto <init>
    INFO: Using keystore alias openidm-sym-default to handle config encryption
    Mar 19, 2018 3:37:12 PM org.forgerock.openidm.config.persistence.Activator start
    INFO: OpenIDM is starting from D:\XXXX\ForgeRock\IDM-eval-5.5.0\openidm
    Mar 19, 2018 3:37:13 PM org.forgerock.openidm.config.persistence.ConfigBootstrapHelper getBootConfig
    INFO: Bootstrapping with settings from configuration file D:\XXXX\ForgeRock\IDM-eval-5.5.0\openidm\conf\repo.jdbc.json
    Mar 19, 2018 3:37:13 PM org.forgerock.openidm.config.persistence.ConfigBootstrapHelper getBootConfig
    INFO: Bootstrapping with settings from configuration file D:\XXXX\ForgeRock\IDM-eval-5.5.0\openidm\conf\datasource.jdbc-default.json
    Mar 19, 2018 3:37:13 PM org.forgerock.openidm.repo.jdbc.impl.Activator start
    INFO: Bootstrapping JDBC repository
    Mar 19, 2018 3:37:13 PM org.forgerock.openidm.datasource.jdbc.impl.NonPoolingDataSourceFactory newInstance
    INFO: Using DB connection configured via Driver Manager with Driver com.mysql.jdbc.Driver and URL jdbc:mysql://localhost:3306/openidm?allowMultiQueries=true&characterEncoding=utf8
    Mar 19, 2018 3:37:13 PM org.forgerock.openidm.datasource.jdbc.impl.JDBCDataSourceService testConnection
    WARNING: Unable to get DataSource connection. Next attempt at Mon Mar 19 15:37:18 IST 2018

    Env : IDM-eval-5.5.0, Windows 7

    Any help would be appreciated.
    Thanks in advance..

    #21232
     Bill Nelson
    Participant

    The error comes right after the server attempts to connect to the database with the jdbc url configured and is unable to do so.

    Is your password configured in the datasource.jdbc-default.json file correct?
    Is your Windows firewall turned on by any chance, thus blocking connectivity?
    Is MySQL running? (Sorry, I had to ask)

    If the answer to those questions is yes, then please post your datasource.jdbc-default.json file so we can look for possible misconfigurations.

    #21233
     laurent.bristiel
    Participant

    If you are using version 5.5 of IDM, you should use the version 5.5 of the doc: https://backstage.forgerock.com/docs/idm/5.5/install-guide/

    #21234
     srinath.m
    Participant

    I forgot to modify the mysql password in datasource.jdbc-default.json file.
    Thanks Bill Nelson.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.

©2022 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?