distal-attribute
distal-attribute
distal-attribute
distal-attribute

SSL connection with just SSL-CA certificate

User, date Message
Written by MarkP
3 years ago
Category: Feature discussion
1 posts since Sat, 09 Apr 11
At the moment HeidiSQL requires three things to connect via SSL: private key, CA certificate and SSL certificate. Using only the SSL-CA certificate of the server should also be an option. According to the MySQL reference manual (5.5, chapter 5.5.8.2-4), it can can be done if the account has no special SSL requirements. It would be really great if HeidiSQL could do this as well.

Thanks in advance,
Mark
Written by ansgar
3 years ago
5023 posts since Fri, 07 Apr 06
I already did that in r3722, to solve issue #2336. Please update your HeidiSQL build so you can try that.
Written by MaxB
3 years ago
4 posts since Thu, 07 Apr 11
But, sorry, it does not work... unhappy

See my post here. FYI, I've tested the SSL connection well also with the command line tool:

mysql --ssl-ca=/etc/ssl/certs/mycacert.pem -u ssluser -p sslpassword -h mysqldb.myhost.com

Written by MaxB
3 years ago
4 posts since Thu, 07 Apr 11
Hi anse,
here's my feedback to you:

The latest nightly build r3768 now connect fine to our ssl database server (with a ca cert parameter only).
Many thanks! smile
 

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