Heidi for MAC - Tunnel SSH Problem

Hi, When I try to use an SSH tunnel connection I get an error message because it can't find plink.exe... I would also rightly say....how can I configure the connection to use a terminal for tunnels?

Just put in "ssh" on the "SSH tunnel" tab. Should work on macOS.

I suppose you imported the settings file from a Windows version?

Yes, I imported the file from the Windows version.

But the problem is the same even with a new connection.

The only available ssh executable is ssh.exe. But using ssh.exe, a blank field, or typing "ssh" manually, the result is always the same.

Ok, please stick to "ssh" on macOS, not "ssh.exe". That's important, even if you errors now.

The error now is caused by "sshpass" (not "ssh")!

HeidiSQL internally uses sshpass as soon as you are using a SSH password. I don't know if macOS supports sshpass, but you definitely don't have it - that's what the error says.

Solution: use a private key instead of a password for your SSH connection. This is more secure, and does not require sshpass. A private and public key must be created before you can use it - probably you have heard of that?

With the private key and the "ssh" entry, the connection works. I tried installing sshpass via brew, and although it works in the terminal, HeidiSql doesn't see the command, probably due to an internal shell or something similar.

Do you know of a situation where this happens?

So when you use a password, HeidiSQL again displays "no such file or directory" ?

Try in the terminal again, call sshpass without path, as that is what HeidiSQL does. If it can't find the command then a solution would be to add the path to sshpass to the PATH environment.

I suppose you are the very first one trying the whole SSH tunnel in HeidiSQL on macOS. At least I get not much feedback from macOS folks yet.

I've been using HeidiSql with ssh tunnels for at least a decade on Mac via crossover.

I tried sshpass on my terminal without a path and had no problems. Heidi keeps getting "System message: No such file or directory."

Yea that should not happen, probably an issue in HeidiSQL.

Can you please testwise run the whole command from the error message in a terminal: "sshpass -e ssh francesco@..." ?

Would be nice if I could find a general fix for that error.

When I try to use sshpass in my terminal, the first thing that appears is:

sshpass: -e option given but "SSHPASS" environment variable is not set. zsh: segmentation fault sshpass -e ssh francesco@172.16.69.25 -p 22 -o StrictHostKeyChecking=no -N -L When I export the password variable, I get no error message and the connection is established.

I have the same behaviour! 🙏 Looks like the export of the password from heidi does not work?

Please use the fresh app bundle from the download page, I compiled it 2 days ago and it contains a fix for sshpass which is documented in issue #2364

I still get this error:

@crudolf can you please try to SSHPASS=yourpassword and then run the sshpass -e ssh ... command in a terminal, and post your result?

i use a new bundle app 12.14.1.1.

The connection works, when I do export SSHPASS=XX from console!

sshpass -e ssh crudolf@YY -p 22 -o StrictHostKeyChecking=no -N -L 3309:127.0.0.1:3306 Output: Warning: Permanently added 'YY' (ED25519) to the list of known hosts.

If I do not export the SSHPASS is not set and I receive the same error message

Will do some more testing here on my m4 mac mini.

You could please update to the more fresh v12.15 and retry the SSHPASS thing.