Problem starting openIDM 7.1 after adding MySQL as repository

[sdklm]

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

[Lana]

Good morning,

Have you set up an SSL connection to MySQL. Alternatively does the jdbcUrl property in your
datasource.jdbc-default.json file include &useSSL=false?

(Please see the NOTE in Step 11 of https://backstage.forgerock.com/docs/idm/7.1/install-guide/repository-mysql.html#repository-mysql)

[sdklm]

Hello

[sdklm]

Hello
I added &useSSL=false on jdbcUrl property
I also disabled SSL on MySQL server and it doesn’t work
Do you have any ideas to fix this problem ?
Thanks for your help
Best regards
Sylvain

[Author]

Posts