MySQL Bugs: #70995: MySQL Workbench 6.2 does not recognize pageant

Bug #70995	MySQL Workbench 6.2 does not recognize pageant
Submitted:	25 Nov 2013 7:19	Modified:	1 Oct 2015 14:37
Reporter:	Hidetaka Kimura	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	6.2.3	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
I recently updated MySQL Workbench from 5.2.47 to 6.0.8. I used pageant for ssh tunneling but it stopped working now. It works if I set SSH Key File but I would like to use ssh agent like pageant. It seems a regression.

wb.log: 

12:07:09 [INF][ SSH tunnel]: Starting tunnel 
12:07:09 [INF][ SSH tunnel]: Existing SSH tunnel not found, opening new one 
12:07:16 [INF][ SSH tunnel]: Opening SSH tunnel to xx.xx.xx.xx 
12:07:16 [ERR][ sshtunnel.py]: Traceback (most recent call last): 
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.0 CE\sshtunnel.py", line 231, in _connect_ssh 
look_for_keys=has_key, allow_agent=has_key) 
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.0 CE/python/site-packages\paramiko\client.py", line 332, in connect 
self._auth(username, password, pkey, key_filenames, allow_agent, look_for_keys) 
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.0 CE/python/site-packages\paramiko\client.py", line 493, in _auth 
raise saved_exception 
BadAuthenticationType: Bad authentication type (allowed_types=['publickey'])

How to repeat:
1. Have a MySQL server that needs SSH tunneling.
2. Launch pageant and add your private key to it.
3. Try to connect the server by MySQL Workbench without specifying "SSH Key File" and "SSH Password".

This seems to be working for me with 6.1.7 as long as you put the *PuTTY* private key file in the "SSH Key File" field.

Strangely, it *continues* to work if you later remove the private key filename from that field, as if it "remembers" to check for a running authentication agent after that.

I'll agree that the UI could be more helpful here, and the built-in help documentation doesn't give you *quite* enough to go on.

Please check version 6.2.3. Thanks.

It still does not recognize pageant on 6.2.3. I would like to keep the "SSH Key File" field empty if possible.

Here is the log.

09:27:07 [INF][     SSH tunnel]: Starting tunnel
09:27:07 [DB2][ python context]: About to pyrun 'C:\Program Files\MySQL\MySQL Workbench 6.2 CE\sshtunnel.py'
09:27:07 [INF][     SSH tunnel]: Existing SSH tunnel not found, opening new one
09:27:07 [DB1][ mforms managed]: Looking up password for service: ssh@****:22, account: ****
09:27:07 [DB1][ mforms managed]: Loading password cache
09:27:07 [DB1][ mforms managed]: Get special folder
09:27:07 [DB2][ mforms managed]: Decrypting password data
09:27:07 [DB2][ mforms managed]: Filling password cache
09:27:07 [DB1][ mforms managed]: Unloading password cache
09:27:07 [DB1][ mforms backend]: Looking up password for '****'@'ssh@****:22' has failed
09:27:07 [DB1][ mforms backend]: Creating and showing password dialog
09:27:07 [DB1][ mforms managed]: Hiding the wait message
09:27:07 [DB2][ mforms managed]: Wait message was not visibile, nothing to do
09:27:07 [DB2][ mforms managed]: Returning main form
09:27:11 [INF][     SSH tunnel]: Opening SSH tunnel to ****:22
09:27:11 [DB1][            grt]: Thread started
09:27:11 [DB2][sshtunnel.py:do_run:117]: SSH Tunel 1 thread started
09:27:11 [DB2][sshtunnel.py:notify:228]: tunnel_37074: INFO Connecting to SSH server at ****:22...
09:27:11 [DB1][     SSH tunnel]: Waiting on tunnel to connect...
09:27:11 [DB1][sshtunnel.py:wait_connection:446]: INFO: Connecting to SSH server at ****:22...
09:27:11 [DB2][sshtunnel.py:notify:228]: tunnel_37074: ERROR Bad authentication type, the server is not accepting this type of authentication.
Allowed ones are:
 ['publickey']
09:27:11 [ERR][sshtunnel.py:notify_exception_error:233]: Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\sshtunnel.py", line 265, in _connect_ssh
    look_for_keys=has_key, allow_agent=has_key)
  File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE/python/site-packages\paramiko\client.py", line 332, in connect
    self._auth(username, password, pkey, key_filenames, allow_agent, look_for_keys)
  File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE/python/site-packages\paramiko\client.py", line 493, in _auth
    raise saved_exception
BadAuthenticationType: Bad authentication type (allowed_types=['publickey'])

It still happen on 6.2.

I'm still happen on 6.3.4.0.

Please check for duplicate http://bugs.mysql.com/bug.php?id=76168.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".