MySQL Bugs: #118387: ssh tunnel connection fails: "Error setting remote host in ssh session option:"

Bug #118387	ssh tunnel connection fails: "Error setting remote host in ssh session option:"
Submitted:	6 Jun 16:36	Modified:	10 Jun 13:36
Reporter:	First Last	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	8.0.42	OS:	Windows (win11 24h2)
Assigned to:		CPU Architecture:	x86 (x64)

Description:
The configured "SSH Hostname" is sshable using the win11 ssh client and putty.

When trying to connect workbench pops up a dialog: "Could not connect the SSH Tunnel"

The following is logged:

12:29:10 [INF][     SSH tunnel]: Opening SSH tunnel to not.a.real.host:22
12:29:10 [ERR][     SSHSession]: Error setting remote host in ssh session option: 
12:29:10 [ERR][     SSH tunnel]: Authentication error opening SSH tunnel: 

How to repeat:
install workbench 8.0.42 on win11 24h2
add an workbench SSH connection to a host that is sshable from the machine
test it

Hello!

Thank you for the bug report.
To investigate further this issue at our end, may I kindly request you to launch workbench under debug mode (--log-level=debug3) and provide unaltered workbench log file(more details about log are explained here - https://dev.mysql.com/doc/workbench/en/workbench-reporting-bugs.html)?

Regards,
Ashwini Patil

More logging does not appear to help:

10:11:53 [INF][SSHTunnelManager]: Wakeup socket port created: 65038
10:11:53 [INF][     SSH tunnel]: Starting tunnel
10:11:53 [INF][     SSH tunnel]: Existing SSH tunnel not found, opening new one
10:11:53 [INF][     SSH tunnel]: Opening SSH tunnel to not.a.real.hostm:22
10:11:53 [ERR][     SSHSession]: Error setting remote host in ssh session option: 
10:11:53 [ERR][     SSH tunnel]: Authentication error opening SSH tunnel:

Hello!

Thank you for the details.
Looking at the log information "Authentication error opening SSH tunnel", it looks like you have misconfigured SSH keys or incorrect server configurations, or firewall issues preventing the tunnel from establishing.
The error can be resolved by ensuring the correct SSH key is being used, the server is configured for TCP forwarding, and that the firewall allows connections through the SSH port.

Regards,
Ashwini Patil

I have one password unprotected private key (%USERPROFILE%\.ssh\id_rsa) in "-----BEGIN RSA PRIVATE KEY-----" format. This is what the win11 ssh client is using and is connecting successfully. This is also what's in the workbench "SSH Key File" connection field.

What is incorrect about this?

Also the more specific error logged is "Error setting remote host in ssh session option:".