OpenIDM – Set up repository with MySQL

[srinath.m]

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..

[Bill Nelson]

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.

[laurent.bristiel]

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/

[srinath.m]

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

[Author]

Posts