Geek Answers Handbook

SSH database connection cannot be established from Workbench

I cannot establish a database connection from MySQL Workbench via SSH. If I click Test Connection, I get an error: ERROR local variable 'chan' referenced before assignmentin the first step.
However, I managed to connect from the MySQL server via the command line via SSH. I was also able to connect to my local database using Workbench. I am using Ubuntu with KDE 14.10 and the problem started with the update, so I think this is due to this, but I do not know how to do it. Please let me know if you would like more information. Thanks in advance,

PS I saw a similar problem without a solution here .

+4
source share
2 answers

Here you can solve this problem in Debian / Ubuntu:

1 Close the Mysql Workbench first!

2 Apply Patch:

sudo cd /usr/lib/mysql-workbench/
sudo wget https://launchpadlibrarian.net/189450207/paramiko.patch
sudo patch -p1 < paramiko.patch

3 Launch the Mysql Workbench, it works now!

+10
source

If you are using python 2.x, try using python3?

This error is probably related: http://bugs.mysql.com/bug.php?id=74960

Edit: confirmed, I tried with python 2.x and have this error in mysql / workbench / log / wb.log:

5:35:38 [INF] [wb_admin_control.py:query_server_installation_info:767]: Currently connected to MySQL server version 'unknown', conn status = None, active plugins = []
15:35:38 [ERR][sshtunnel.py:notify_exception_error:233]: Traceback (most recent call last):
  File "/usr/share/mysql-workbench/sshtunnel.py", line 315, in accept_client
    sshchan = transport.open_channel('direct-tcpip', self._target, local_sock.getpeername())
  File "/usr/lib/mysql-workbench/modules/wb_admin_ssh.py", line 116, in wba_open_channel
    raise e
EOFError

15:35:38 [ERR][wb_admin_control.py:server_polling_thread:492]: Error creating SQL connection for monitoring: MySQLError("Lost connection to MySQL server at 'reading initial communication packet', system error: 0 (code 2013)",)
15:35:56 [INF][   base library]: Notification GNFocusChanged is not registered
0

More articles:


All Articles