MySQL Forums
Forum List  »  Quality Assurance

Connection TCP/IP over SSH fails in Workbench 6.2.4 on Windows 7 64 bit
Posted by: Sudha Nagrath
Date: December 19, 2014 04:00AM

I have been trying to connect to MySQL remote server from my Windows 7, 64-bit machine and it fails with authentication error.

The installed version is 3.2.4

Error extracts from the wb.log files:
MySQL Workbench Community (GPL) for Windows version 6.2.4 revision 12437 build 2426 (64 bit)
Configuration Directory: C:\Users\snagrath\AppData\Roaming\MySQL\Workbench
Data Directory: C:\mysql\MySQL Workbench 6.2.4 CE (winx64)
Cairo Version: 1.10.2
OS: Microsoft Windows 7 Professional Service Pack 1
CPU: 2x Intel(R) Core(TM) i7-4870HQ CPU @ 2.50GHz, 2.0 GiB RAM
Active video adapter VMware SVGA 3D
Installed video RAM: 128 MB
Current video mode: 1920 x 1080 x 4294967296 colors
Used bit depth: 32
Driver version: 7.14.1.1211
Installed display drivers: vm3dum64.dll,vm3dum,vm3dgl64.dll,vm3dgl
Current user language: English (United Kingdom)

09:18:28 [DB1][ grt]: MySQL Generic Runtime Environment 4.1.0
09:18:28 [DB1][ grt]:
Type '?' for help.
09:18:28 [DB1][ grt]: Python Shell initialized. (Use Preferences -> General to set language)
09:18:28 [DB1][ grt]: Ready.
09:18:28 [DB1][ grt]:
09:18:29 [INF][ Workbench]: UI is up
09:18:29 [DB2][WBContext managed]: Activating appview avid2
09:18:29 [DB1][ WBContext]: Saved connection list (MySQL: 4)
09:18:29 [DB1][ WBContext]: Calling SQLIDEUtils.initialize0()...
09:18:29 [INF][ Workbench]: Running the application
09:18:35 [INF][ SSH tunnel]: Starting tunnel
09:18:35 [DB2][ python context]: About to pyrun 'C:\mysql\MySQL Workbench 6.2.4 CE (winx64)\sshtunnel.py'
09:18:35 [DB1][ grt]: Traceback (most recent call last):
09:18:35 [DB1][ grt]: File "C:\mysql\MySQL Workbench 6.2.4 CE (winx64)\sshtunnel.py", line 32, in <module>
09:18:35 [DB1][ grt]: import paramiko
09:18:35 [DB1][ grt]: File "C:\mysql\MySQL Workbench 6.2.4 CE (winx64)\python\paramiko\__init__.py", line 30, in <module>
09:18:35 [DB1][ grt]: from paramiko.transport import SecurityOptions, Transport
09:18:35 [DB1][ grt]: File "C:\mysql\MySQL Workbench 6.2.4 CE (winx64)\python\paramiko\transport.py", line 32, in <module>
09:18:35 [DB1][ grt]: from paramiko import util
09:18:35 [DB1][ grt]: ImportError: cannot import name util
09:18:35 [ERR][ python]: Error running file C:\mysql\MySQL Workbench 6.2.4 CE (winx64)\sshtunnel.py
09:18:35 [WRN][ ]: Tunnel manager could not be executed
09:18:35 [ERR][ SqlEditor]: SQL editor could not be connected: Cannot start SSH tunnel manager
09:18:35 [ERR][ SqlEditor]: Your connection attempt failed for user 'agi' from your host to server at 127.0.0.1:3306:
Cannot start SSH tunnel manager

Please:
1 Check that mysql is running on server 127.0.0.1
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the agi has rights to connect to 127.0.0.1 from your address (mysql rights define what clients can connect to the server and from which machines)
4 Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting from
09:18:35 [DB1][ mforms managed]: Showing an error to the user
09:18:35 [DB1][ mforms managed]: Hiding the wait message
09:18:35 [DB2][ mforms managed]: Wait message was not visibile, nothing to do
09:18:35 [DB1][ mforms managed]: About to show a custom message box
09:18:35 [DB1][ mforms managed]: Creating and showing custom message box
09:18:35 [DB1][ mforms managed]: Running custom message box
09:18:56 [DB1][ mforms managed]: Custom message box closed
09:24:20 [INF][ SSH tunnel]: Starting tunnel
09:24:20 [DB2][ python context]: About to pyrun 'C:\mysql\MySQL Workbench 6.2.4 CE (winx64)\sshtunnel.py'
09:24:20 [DB1][ grt]: Traceback (most recent call last):
09:24:20 [DB1][ grt]: File "C:\mysql\MySQL Workbench 6.2.4 CE (winx64)\sshtunnel.py", line 32, in <module>
09:24:20 [DB1][ grt]: import paramiko
09:24:20 [DB1][ grt]: File "C:\mysql\MySQL Workbench 6.2.4 CE (winx64)\python\paramiko\__init__.py", line 69, in <module>
09:24:20 [DB1][ grt]: from transport import SecurityOptions, Transport
09:24:20 [DB1][ grt]: File "C:\mysql\MySQL Workbench 6.2.4 CE (winx64)\python\paramiko\transport.py", line 32, in <module>
09:24:20 [DB1][ grt]: from paramiko import util
09:24:20 [DB1][ grt]: ImportError: cannot import name util
09:24:20 [ERR][ python]: Error running file C:\mysql\MySQL Workbench 6.2.4 CE (winx64)\sshtunnel.py
09:24:20 [WRN][ ]: Tunnel manager could not be executed
09:24:20 [ERR][ SqlEditor]: SQL editor could not be connected: Cannot start SSH tunnel manager
09:24:20 [ERR][ SqlEditor]: Your connection attempt failed for user 'agi' from your host to server at 127.0.0.1:3306:
Cannot start SSH tunnel manager

Options: ReplyQuote


Subject
Views
Written By
Posted
Connection TCP/IP over SSH fails in Workbench 6.2.4 on Windows 7 64 bit
4197
December 19, 2014 04:00AM


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.