[BUG] Launch commmand line with SSL

[expired user #9733]'s profile image [expired user #9733] posted 8 years ago in General Permalink

Hi. When leaving some SSL parameters blank, the connection is successful, but the "launch command line" doesn't work, because the command line arguments for the blank parameters are set to empty. These arguments should be left out. Let's say I'm using only the "CA Certificate" field. When launching the command line, HeidiSQL generates this:

C:\Program Files\MySQL\MySQL Server 5.5\bin\mysql.exe --host="xxxx" --ssl --ssl-key="" --ssl-cert="" --ssl-ca="C:\fullpath\ca-cert.pem" --user="user" --password="****" --compress --database="database"

The output is:

SSL error: Unable to get certificate from '' ERROR 2026 (HY000): SSL connection error: Unable to get certificate

Removing these empty parameters solves the issue.

C:\Program Files\MySQL\MySQL Server 5.5\bin\mysql.exe --host="xxxx" --ssl --ssl-ca="C:\fullpath\ca-cert.pem" --user="user" --password="****" --compress --database="database"

ansgar's profile image ansgar posted 8 years ago Permalink

Thanks for the hint. Should be easy to fix.

Code modification/commit from ansgarbecker, 8 years ago, revision 9.3.0.5070
Fill SSL command line parameters only if not empty in HeidiSQL session. See http://www.heidisql.com/forum.php?t=21024
ansgar's profile image ansgar posted 8 years ago Permalink

Ready in r5070 - please update your HeidiSQL to the latest build to get the modification.

[expired user #9733]'s profile image [expired user #9733] posted 8 years ago Permalink

Perfect! Thank you!

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