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
SSL connection error: Unable to get certificate
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
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.