Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Database SSH connection cannot be established from Workbench

I can't establish a database connection from MySQL client Workbench through SSH. If I click Test Connection I get the error: ERROR local variable 'chan' referenced before assignment in the first step.
However I was able to connect from MySQL server through the command line, via SSH. I was also able to connect to my local database with Workbench. I am using Ubuntu with KDE 14.10 and the problem started with the update, so I guess it has to do with that, but I don't know how. Please let me know if you'd like further information. Thank you in advance,

PS I saw a similar problem without a solution here.

like image 697
Diego-MX Avatar asked Dec 26 '22 01:12

Diego-MX


1 Answers

Here a solution to fix this issue under Debian/Ubuntu:

1 First, close Mysql Workbench!

2 Apply the patch:

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

3 Start Mysql Workbench, it's now working!

like image 169
David DIVERRES Avatar answered Dec 28 '22 19:12

David DIVERRES