SSL connection error: Unable to get certificate

[expired user #8712]'s profile image [expired user #8712] posted 9 years ago in General Permalink
Hi! I'm using HeidiSQL for three years now, recently I've reinstalled computer and I'm unable to connect to MySQL using SSL anymore.

HeidiSQL is giving me following message: SSL connection error: Unable to get certificate

I suspect it cannot read my key/certs (which it read a month ago and I haven't changed them since, private key certainly does not require password) as it tries to connect to MySQL if I do not fill certs/keys within SSL section.

Any hints?

Thanks in advance,
Jakub
[expired user #8712]'s profile image [expired user #8712] posted 9 years ago Permalink
Aaaah, solved :-)

Probably some change done to SSL connection section (or may be some translation bogus as I'm using CZECH language).

What happened:

In previous version (8.3 I think), I had to fill SSL details like this:

SSL private key: client-cert.pem
SSL CA certificate: ca-cert.pem
SSL certificate: client-key.pem

Note that I had to swap private key and certificate.

Now it has to be filled correctly:

SSL private key: client-key.pem
SSL CA certificate: ca-cert.pem
SSL certificate: client-cert.pem

Cheers!
Jakub

Please login to leave a reply, or register at first.