Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-469

SSLVERIFY=0, still getting The certificate's CN name does not match the passed value on Windows

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 3.2.4
    • 3.2.7
    • General
    • None
    • Windows 2022 Server

    Description

      We have enabled the SSL on MariaDB ODBC DSN by providing the following DSN settings, however connection keep refusing by giving following error:

      _Connection failed: [HY000][ma-3.2.4]TLS/SSL error: Server certificate validation failed. The
      certificate's CN name does not match the passed value. Error
      0x800B010F(CERT_E_CN_NO_MATCH)
      Connection String:
      DRIVER=

      {MariaDB Native ODNC}

      ;OPTIONS=6;TCPIP=1;SERVER=10.**..*;UID=root;PWD=****;
      DATABASE=mystore;PORT=3306;SSLCA=C:F6\certs\ca.pem;NULLISCURRENT=1;PSCACHESIZE=250;MAXCACHKEY=2112;PCALLBACK=1_

      We have unchecked the 'Verify Certificate' option from dialog.. and also validate the registry entry. The SSLVERIFY is set to 0, but still on Windows it is doing the certificate verification. How to connect to mySQL db with SSL without doing the certificate validation.

      Note: We are able to connect on SSL when we provide the FQDN host which is matching the CN name in certificate instead of IP in SERVER.

      Regards.

      Attachments

        Activity

          People

            Lawrin Lawrin Novitsky
            mukeshpbrcm Mukesh Patel
            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.