heidi + wine + ssh tunnel with passphrase, how?

[expired user #11059]'s profile image [expired user #11059] posted 6 years ago in General Permalink

I understand that to create an ssh tunnel using a key that includes a passphrase, I must use pageant because heidi will not ask for the passphrase. Trouble is, I'm doing this on a Mac, so I'm using wine, and I have no system tray (as far as I know) so I cannot get pageant to ask for a passphrase. Can I?

[expired user #11059]'s profile image [expired user #11059] posted 6 years ago Permalink

Okay, I found that pageant was in my title bar, so I double-clicked it to open it, added the key, it asked for a passphrase, and now it's listed as a loaded key. Fine.

Heidisql gives me this when I open this tunnel connection:

Access denied for user 'root'@'myhost.com' (using password: YES)

This connection works under windows using putty from my work machine. Ssh works from home with this key. Trying to get this tunnel working from a Mac.

[expired user #11059]'s profile image [expired user #11059] posted 6 years ago Permalink

This...

plink.exe -ssh me@myhost.com -P 22 -i "Z:\Users\me.ssh\id_rsa_putty.ppk" -N -L 3307:myhost.com:3306

...seems to connect okay, other than the fixme's

fixme:winsock:set_dont_fragment IP_DONTFRAGMENT for IPv4 not supported in this platform Using username "me". fixme:winsock:set_dont_fragment IP_DONTFRAGMENT for IPv6 not supported in this platform

As you can see, I translated the openssh key for putty.

"me" and "myhost" have been changed to protect the innocent.

[expired user #11059]'s profile image [expired user #11059] posted 6 years ago Permalink

Found it. D'oh! Wrong database user name. It works! Sorry for the noise.

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