MySQL Forums
Forum List  »  MySQL Workbench

SSH Tunneling failure when connecting to MySQL
Posted by: Bright Zhao
Date: April 15, 2017 02:48AM

Hi,

I installed the MySQL Workbench on my macOS Sierra, and trying to connect to the MySQL RDS instance(private subnet) by an public EC2 through SSH tunneling(which named as "Standard TCP/IP over SSH" in workbench tool), but I can't establish the connection, error message as below:

16:41:38 [INF][ SSH tunnel]: Starting tunnel
16:41:38 [INF][ SSH tunnel]: Existing SSH tunnel not found, opening new one
16:41:38 [INF][ SSH tunnel]: Opening SSH tunnel to 54.254.222.199:22
16:41:38 [ERR][sshtunnel.py:notify_exception_error:235]: Traceback (most recent call last):
File "/Applications/MySQLWorkbench.app/Contents/Resources/sshtunnel.py", line 291, in _connect_ssh
self._client.load_host_keys(os.path.expanduser(ssh_known_hosts_file))
File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/paramiko/client.py", line 124, in load_host_keys
self._host_keys.load(filename)
File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/paramiko/hostkeys.py", line 101, in load
e = HostKeyEntry.from_line(line, lineno)
File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/paramiko/hostkeys.py", line 331, in from_line
key = RSAKey(data=decodebytes(key))
File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/paramiko/rsakey.py", line 64, in __init__
if msg.get_text() != 'ssh-rsa':
File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/paramiko/message.py", line 186, in get_text
return u(self.get_bytes(self.get_int()))
File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/paramiko/py3compat.py", line 53, in u
return s.decode(encoding)
File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/encodings/utf_8.py", line 16, in decode
return codecs.utf_8_decode(input, errors, True)
UnicodeDecodeError: 'utf8' codec can't decode byte 0x82 in position 4: invalid start byte

16:41:39 [INF][ SSH tunnel]: TunnelManager.wait_connection authentication error: Authentication error, unhandled exception caught in tunnel manager, please refer to logs for details
16:41:39 [ERR][ SSH tunnel]: Authentication error opening SSH tunnel: Authentication error, unhandled exception caught in tunnel manager, please refer to logs for details




In the mean time, I tried the same connection info on another Mac computer, that is fine, so would like to know what's wrong with my current Mac?

Options: ReplyQuote


Subject
Views
Written By
Posted
SSH Tunneling failure when connecting to MySQL
2049
April 15, 2017 02:48AM


Sorry, you can't reply to this topic. It has been closed.

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.