This topic has 4 replies, 2 voices, and was last updated 12 months ago by sdklm.
-
AuthorPosts
-
June 11, 2021 at 10:34 am #28567
sdklm
ParticipantHello,
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 databaseExecuting ./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 classcom.mysql.jdbc.Driver'. This is deprecated. The new driver class is
com.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 2021Do you have any ideas about how to solve this problem? Thanks for your help
June 30, 2021 at 9:59 am #28607Lana
ParticipantGood 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)
July 1, 2021 at 9:37 am #28612sdklm
ParticipantHello
July 1, 2021 at 9:39 am #28613sdklm
ParticipantHello
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 -
AuthorPosts
You must be logged in to reply to this topic.