Bug #77893 unable to tunnel connection
Submitted: 30 Jul 2015 21:12 Modified: 31 Jul 2015 0:34
Reporter: Mike Johnson Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S5 (Performance)
Version:6.3.4 OS:MacOS (OS X 10.10.x Yosemite)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[30 Jul 2015 21:12] Mike Johnson
Description:
I am able to connect with the $>ssh -t ssh-2 "ssh -t mysqldevdb mysql -h localhost -u root -p" via command line but not able to do the same in workbench 

----[For better reports, please attach the log file after submitting. You can find it in /Users/johmicd/Library/Application Support/MySQL/Workbench/log/wb.log]

15:37:28 [INF][     SSH tunnel]: Existing SSH tunnel not found, opening new one
15:37:28 [INF][     SSH tunnel]: Opening SSH tunnel to mysqldevdb.its.bethel.edu
15:37:28 [ERR][sshtunnel.py:notify_exception_error:233]: Traceback (most recent call last):
  File "/Applications/MySQLWorkbench.app/Contents/Resources/sshtunnel.py", line 298, in _connect_ssh
    look_for_keys=has_key, allow_agent=has_key)
  File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/paramiko/client.py", line 296, in connect
    sock.connect(addr)
  File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/socket.py", line 224, in meth
    return getattr(self._sock,name)(*args)
error: [Errno 61] Connection refused

15:37:28 [ERR][     SSH tunnel]: TunnelManager.wait_connection got IOError: IO Error: [Errno 61] Connection refused.
 Please refer to logs for details.
15:37:30 [INF][      WBContext]: Connection to dev cancelled by user: IO Error: [Errno 61] Connection refused.
 Please refer to logs for details.

How to repeat:
ssh host:mysqldevdb.its.bethel.edu:22

mysql hostname:localhost
mysql user:root

[remote managment ]
ssh login based managment
host name :ssh-2.its.bethel.edu
username johmicd
check auth enticate useing ssh keys
ssh key path /Users/johmicd/.ssh/id_rsa
[30 Jul 2015 21:16] Mike Johnson
tried puting in paramiko 1.15.1 and ecdsa and this did not change much 

16:14:52 [INF][     SSH tunnel]: Existing SSH tunnel not found, opening new one
16:14:52 [INF][     SSH tunnel]: Opening SSH tunnel to mysqldevdb.its.bethel.edu:22
16:14:52 [ERR][sshtunnel.py:notify_exception_error:233]: Traceback (most recent call last):
  File "/Applications/MySQLWorkbench.app/Contents/Resources/sshtunnel.py", line 298, in _connect_ssh
    look_for_keys=has_key, allow_agent=has_key)
  File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/paramiko/client.py", line 310, in connect
    raise NoValidConnectionsError(errors)
NoValidConnectionsError: [Errno None] Unable to connect to port 22 on  or 140.88.***.***

16:14:52 [ERR][     SSH tunnel]: TunnelManager.wait_connection got IOError: IO Error: [Errno None] Unable to connect to port 22 on  or 140.88.101.114.
 Please refer to logs for details.
16:14:54 [INF][      WBContext]: Connection to dev cancelled by user: IO Error: [Errno None] Unable to connect to port 22 on  or 140.88.101.114.
 Please refer to logs for details.
[31 Jul 2015 0:34] MySQL Verification Team
Thank you for the bug report. Duplicate of http://bugs.mysql.com/bug.php?id=74658.