Bug #64153 Workbench TCP/IP over SSH connection fails
Submitted: 28 Jan 2012 18:04 Modified: 1 Apr 2012 14:43
Reporter: Cris Firman Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.2.34+ OS:Windows (Win7 x64)
Assigned to: CPU Architecture:Any
Tags: regression, ssh, workbench

[28 Jan 2012 18:04] Cris Firman
Description:
Connecting to a remote server via SSH tunnel fails.

Output reports the following (domain, user folder and rsa key edited for security):
29275 INFO Connecting to SSH server at www.somedomain.com:22 using key C:\Users\username\Documents\SSH2.ppk...

C:\Program Files (x86)\MySQL\MySQL Workbench 5.2.37 CE/python/site-packages\paramiko\client.py:93: UserWarning: Unknown ssh-rsa host key for www.somedomain.com: 16916aed379749*****8d3ba

  (key.get_name(), hostname, hexlify(key.get_fingerprint())))

29275 ERROR Failed to connect to www.somedomain.com:22: WindowsError(5, 'Access is denied')

How to repeat:
1. Select "Manage Connections"
2. Select "New"
3. Name connection
4. Connection method "Standard TCP/IP over SSH"
5. SSH Hostname = www.somedomain.com or IP address
6. Set username
7. Select SSH-2 RSA private key
8. Set MySQL hostname to 127.0.0.1
9. Set port to 3306
10. Set MySQL username and password
11. Start Putty Agent pagent.exe
12. Load corresponding SSH-2 RSA key into pagent.
13. Click "test connection" in Manage DB Connections Window

This is a known working configuration prior to 5.2.34.
[1 Mar 2012 14:43] Alfredo Kojima
Please try with 5.2.38 and if the same still happens, start it with -log-level=debug3 and then attach the log file (ther's a command to take you to it in the Help menu)
[2 Apr 2012 1:00] Bugs System
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".