MySQL Bugs: #49307: Continuous prompts for SSH password

Bug #49307	Continuous prompts for SSH password
Submitted:	1 Dec 2009 22:19	Modified:	15 Feb 2010 13:54
Reporter:	Todd Farmer (OCA)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S2 (Serious)
Version:	5.2.10 r4680	OS:	Windows (XP)
Assigned to:	Alfredo Kojima	CPU Architecture:	Any

Description:
Using a TCP/IP connection over SSH to manage a remote server, I start the administration functions.  Despite the fact that I have specified an SSH key file, it prompts me for my SSH password.  Repeatedly.  Again and again.  Over and over.  Every time I choose a new function (Logs, Configuration file, Status, etc.).

I don't know why it is asking me for my password to start with, since I have configured the connection to use my key file.  But even so, it seems like this is something which should be cached once it is entered, so that the user is not repeatedly prompted to enter it.

How to repeat:
Connect using a TCP/IP over SSH connection with SSH key file specified.

Suggested fix:
See above.

The frequent password query is indeed very annoying, but since it works it would be a P4. However since the password is asked for even if a key file is given, this can be raised to a P3. I wonder, though, if the keyfile really works. It surely does for me and it is quite usual that a client asks for a password if the key was not accepted by the server.

I'm not sure exactly what was happening previously, but I entered the path to my key file a few different ways, and got perplexing errors as a result when I test the connection:

"Cannot open SSH Tunnel:  56250 INFO Tunnel now open ('127.0.0.1', 3687) -> (10.128.23.135', 22) -> ('127.0.0.1', 3306)"

"Cannot open SSH Tunnel:  Starting thread..."

"Cannot open SSH Tunnel: cmd, args = eval(request, {}, {})"

I've tried with forward and backward slashes, with and without quotes, and I continue to get a stream of different errors, including many that suggest that it actually succeeded.

Fixed in 5.2

fixed in repository

An entry has been added to the 5.2.16 changelog:

When using an SSH connection to manage a remote server, MySQL Workbench repeatedly prompted the user to enter a password, even though a key file had been specified.