MySQL Forums :: MySQL Workbench :: SSH Tunneling failure when connecting to MySQL


Advanced Search

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 117 Bright Zhao 04/15/2017 02:48AM
Re: SSH Tunneling failure when connecting to MySQL 71 Bright Zhao 04/15/2017 03:04AM
Re: SSH Tunneling failure when connecting to MySQL 35 Marcin Szalowicz 04/24/2017 01:13AM


Sorry, only registered users may post in this forum.

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.