Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
3.2.4
-
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=
;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.