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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.