Re: SSL Connetion (Host Europe) fails, without SSL works - why?

[Bogdan Degtyariov]

Hi Philipp,

The error "1416F086:SSL routines:tls_process_server_certificate: certificate verify failed" means that the server rejected your certificate. The usual reasons for the rejection could be incorrect, revoked or non-existent certificates.

Please make sure that you created the certificates in the way recommended by MySQL as described on this online manual page:

https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-rsa-files.html

Also, if you specified the full path for SSL CA you don't need to give SSL CA Path. Try removing it from the options.

Another thing that you can try is using mysql command line tool as follows:

mysql --user=... --host=... -p --ssl-key=... --ssl-ca=... --ssl-cert=... --ssl-capath=...

If mysql command line connects with the same SSL options there must be a bug in ODBC driver. You can report bugs here:

https://bugs.mysql.com/report.php

--
Best regards,
Bogdan Degtyariov