Feature request: enable SSL & set SSL-CA via commandline

[expired user #10134]'s profile image [expired user #10134] posted 8 years ago in Feature discussion Permalink

I want to launch HeidiSQL from KeePass in order to store credentials safely; and I've managed to set this up by launching HeidiSQL from command line using hostname, username & password stored in KeePass; however I am not able to pass additional command line parameters to ensure the connection uses SSL (enable SSL & set SSL-CA). Is it possible to add support for SSL command lines and/or is there another way to launch connections in Heidisql using credentials from KeePass?

ansgar's profile image ansgar posted 8 years ago Permalink

Sounds reasonable. What about the other SSL settings (private key, certificate, cipher)?

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

Hey, thanks for the quick response! Personally I don't need those fields for now but I guess others could?

I should mention that I actually managed to work around the lack of these command parameters by having KeePass trigger a session that has all the settings configured (SSL, hostname, username - but no password) + passing the password via KeePass. The drawback with this compared to command-line is that I need to ensure that the same sessions are defined on all computers that I use Heidisql on and that they have the correct settings (so command line would still be nice, but managed to work around it for now :).

For anyone using KeePass, I added the following URL override (named "heidisql"):

cmd://"C:\Program Files\HeidiSQL\heidisql.exe" --description="{BASE:HOST}" --password="{PASSWORD}"

And then in the credential entry, I store the session name as such:

heidisql://Session-name

Which means the "Session-name" is passed into the --description field used by Heidisql.

Code modification/commit b2b5c62 from ansgarbecker, 8 years ago, revision 9.3.0.5123
Accept SSL session settings as command line parameters. See
* http://www.heidisql.com/forum.php?t=22181
* http://www.heidisql.com/help.php#commandline
ansgar's profile image ansgar posted 8 years ago Permalink

r5123 now accepts 5 new command line parameters for SSL settings. Please update HeidiSQL to the latest build and see the help section for command line parameters for details.

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