Bug #61368 TCP over SSH wrong key file

• Submitted: 1 Jun 2011 3:40
• Modified: 1 Jun 2011 17:33
• Reporter: Scott Willett
• Status: Closed
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 5.2.34
• OS: Any
• CPU Architecture: Any
• Tags: key file, TCP over SSH

[1 Jun 2011 3:40] Scott Willett

Description:
The connection manager asks for a ssh public key file when setting up a TCP over SSH connection. The file required is an OpenSSH formatted private key file.

How to repeat:
Create a ssh key pair with puttygen or openssh and select the public key portion (eg: id_dsa.pub or id_rsa.pub on linux or whatever you name it in windows) and try to connect.

Suggested fix:
In puttygen in windows you can load your private key and select "Conversions", "Export OpenSSH Key" to create the file needed. On linux use the id_dsa or id_rsa file in your .ssh directory (probably the same for OSX)

[1 Jun 2011 3:41] Scott Willett

I guess really the fix is just to change the text from "Path to SSH public key file." to "Path to OpenSSH formatted private key file."

[1 Jun 2011 17:33] Alfredo Kojima

Thank you for the problem report. A tooltip has been added to the option to make it clear that the key must be OpenSSH format.