Uploaded image for project: 'OpenIDM'
  1. OpenIDM
  2. OPENIDM-2063

Failed to start OpenIDM when MySQL was used as repo with SSL enabled

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • OpenIDM 3.0.0
    • OpenIDM 3.0.0
    • None
    • openidm 3.0 RC1 runs on a CentOS 6.5 with MySQL as repo.
    • Sprint 21

    Description

      The symptom can be reproduced in the following steps:
      1. Follow MySQL doc to enable SSL on MySQL server, start the server with ssl enabled.
      2. setup openidm use MySQL as repo and enable ssl by the following:
      change repo.jdbc.json file to
      "jdbcUrl" : "jdbc:mysql://10.0.32.38:3306/openidm?characterEncoding=utf8&useSSL=true",
      and inport the CA's certificate which signed MySQL server's certificate to openidm trust store(This can be done through a REST PUT command to endpoint
      openidm/security/truststore/certificate
      3. Start openidm
      see the exception:
      SEVERE: Bundle: org.forgerock.openidm.scheduler [134] [org.forgerock.openidm.scheduler] Cannot register Component
      org.apache.felix.log.LogException: java.lang.RuntimeException: org.forgerock.json.resource.InternalServerErrorException: Querying failed: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://10.0.32.38:3306/openidm?characterEncoding=utf8&useSSL=true, username = openidm. Terminating connection pool. Original Exception: ------^M
      java.sql.SQLException: java.lang.NoClassDefFoundError: javax/net/ssl/TrustManager
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
      ...
      Caused by: org.apache.felix.log.LogException: java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://10.0.32.38:3306/openidm?characterEncoding=utf8&useSSL=true, username = openidm. Terminating connection pool. Original Exception: ------^M
      java.sql.SQLException: java.lang.NoClassDefFoundError: javax/net/ssl/TrustManager
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:435)

      Attachments

        Activity

          People

            jason Jason Lemay
            Tinghua.Xu Tinghua Xu [X] (Inactive)
            Tinghua Xu [X] Tinghua Xu [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: