Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-1080

maridb Java connector sslMode=verify-ca complaining unable to find trust certificate.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 3.1.2
    • 3.2.0
    • JDBC compatibility
    • None
    • openjdk version "11.0.7" 2020-04-14
      centos 7
      mariadb-java 3.1.2

    Description

      Hi,

      I am having issue after upgrading my DB from 3.2 to 3.6 with jdbc connector. we are using 3.1.2 version client driver to establish communication with db.

      jdbc:mariadb://<<host>:3306/conviction?keyStore=/etc/pki/vault-db-dbadmin/keystore.p12&keyStorePassword=***********************************&trustStore=/etc/pki/vault-db-dbadmin/truststore.jks&trustStorePassword=***********************************&sslMode=verify-ca&enabledSslProtocolSuites=TLSv1.2&dumpQueriesOnException=false&keyStoreType=PKCS12&trustStoreType=JKS) for user '<user>': (conn=120412) Could not connect to <host>:3306 : PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
      -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      Connection id: 118429
      Current database:
      Current user: <masked-user>@<masked-host>
      SSL: Cipher in use is DHE-RSA-AES256-SHA256
      Current pager: stdout
      Using outfile: ''
      Using delimiter: ;
      Server: MariaDB
      Server version: 10.6.12-MariaDB-log MariaDB Server
      Protocol version: 10
      Connection: <db host> via TCP/IP
      Server characterset: utf8mb4
      Db characterset: utf8mb4
      Client characterset: utf8mb4
      Conn. characterset: utf8mb4
      TCP port: 3306
      Uptime: 1 day 5 hours 13 min 1 sec

      Attachments

        Activity

          People

            diego dupin Diego Dupin
            prasadm1983 prasad mavuluru
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.