MySQL Bugs: #52318: "Tunnel Manager: Cannot start SSH tunnel manager"

Bug #52318	"Tunnel Manager: Cannot start SSH tunnel manager"
Submitted:	24 Mar 2010 2:43	Modified:	1 May 2010 2:16
Reporter:	Brian Vaughan	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.2.16	OS:	Linux (Ubuntu 10.04)
Assigned to:		CPU Architecture:	Any

Description:
I am using mysql server and client version 5.1.41. This error message began appearing after I upgraded from Ubuntu 9.10 to Ubuntu 10.04.

When I launch MySQL Workbench, a popup appears:
Error
Tunnel Manager
Cannot start SSH tunnel manager

As far as I know, I'm not using such a feature -- I only use mysql on localhost. After closing the error message, I have no trouble using Workbench.

How to repeat:
Always appears immediately upon launching Workbench.

looks like there are some changes to the according packages from 9.10->10.04
we will look into that when we are about to switch to 10.04.

ssh error

Attachment: ssh_error.png (image/png, text), 325.47 KiB.

Thank you for the bug report.

Console output from WB 5.2b7 under Ubuntu 10.4 32-bit

Attachment: wboutput.txt (text/plain), 9.83 KiB.

Hi,

can you confirm whether the error persists with Ubuntu 10.04 final (NOT beta)?

With the release version of Ubuntu 10.04, I'm no longer getting the error message. As it wasn't interfering with my use of Workbench, I don't know what other effects there may have been, but as far as I know, there is no longer a bug.

Thank you for the response.

I've seen reports of similar errors (from other programs) in google. Considering
the error is gone with 10.04 Final, I assume this was a bug in Ubuntu 10.04 beta
not in Workbench.

Unfortunatly, I have this bug in 10.04 final

I have installed Ubuntu 10.04 final and from this point onvard I am getting this message.

I've just upgraded from Ubuntu 9.10 -> 10.04 (Final) and have the same error.

I'm having this same problem after upgrading to Ubuntu 10.04 final.

I'd like to comment that to me the severity of 'non-critical' is incorrect, as this error means I am unable to use the software.

Any update on this? It's been months now and no new comments, even though people are still seeing this error in 10.04 final.

today I had to resort to doing a database diagram with an archaic device known as a 'pencil'...

Hi,

installing package "python-paramiko" in Ubuntu 10.04 solves the problem (missing python import in sshtunnel.py).

Cheers,

Wolfgang

I have python-paramiko installed but error is still there: Module md5 is not there.

usr/lib/python2.6/dist-packages/Crypto/Hash/SHA.py:16: DeprecationWarning: the sha module is deprecated; use the hashlib module instead
  from sha import *

Traceback (most recent call last):

  File "/usr/share/mysql-workbench/sshtunnel.py", line 10, in <module>

    
import paramiko

  File "/usr/lib/pymodules/python2.6/paramiko/__init__.py", line 69, in <module>

    
from transport import randpool, SecurityOptions, Transport

  File "/usr/lib/pymodules/python2.6/paramiko/transport.py", line 32, in <module>

    
from paramiko import util

  File "/usr/lib/pymodules/python2.6/paramiko/util.py", line 32, in <module>

    
from paramiko.common import *

  File "/usr/lib/pymodules/python2.6/paramiko/common.py", line 101, in <module>

    
randpool = StrongLockingRandomPool()

  File "/usr/lib/pymodules/python2.6/paramiko/rng.py", line 69, in __init__

    
instance = _RandomPool()

  File "/usr/lib/python2.6/dist-packages/Crypto/Util/randpool.py", line 57, in __init__

    
from Crypto.Hash import SHA as hash

  File "/usr/lib/python2.6/dist-packages/Crypto/Hash/SHA.py", line 16, in <module>

    
from sha import *

  File "/usr/lib/python2.6/sha.py", line 10, in <module>

    
from hashlib import sha1 as sha

  File "/usr/lib/python2.6/hashlib.py", line 136, in <module>

    
md5 = __get_builtin_constructor('md5')

  File "/usr/lib/python2.6/hashlib.py", line 63, in __get_builtin_constructor

    
import _md5

ImportError
: 
No module named _md5

MySQL Workbench OSS for Linux/Unix version 5.2.16

Cairo Version: 1.8.10

Rendering Mode: Native requested (create a diagram to confirm)

OpenGL Driver Version: Not Detected

OS: Linux 2.6.32-24-generic

CPU: 2x Intel(R) Core(TM)2 Duo CPU     T7500  @ 2.20GHz 800.000 MHz, 3.8 GB RAM

Hi wolfgang, 

Thanks for the response, but I already had python-paramiko installed, so that's not it... :(

dale@computer:~$ mysql-workbench

** (mysql-workbench-bin:13711): WARNING **: GRTTreeView column 0 doesn't exit

** (mysql-workbench-bin:13711): WARNING **: GRTTreeView column 1 doesn't exit

** (mysql-workbench-bin:13711): WARNING **: GRTTreeView column 0 doesn't exit

** (mysql-workbench-bin:13711): WARNING **: GRTTreeView column 0 doesn't exit

** (mysql-workbench-bin:13711): WARNING **: GRTTreeView column 0 doesn't exit
Maximum number of clients reached** Message: Trying to load module '/usr/lib/mysql-workbench/modules/db.mysql.grt.so' (cpp)
** Message: Trying to load module '/usr/lib/mysql-workbench/modules/wb.mysql.import.grt.so' (cpp)
** Message: Trying to load module '/usr/lib/mysql-workbench/modules/tools.grt.lua' (lua)
** Message: Initialized Lua module /usr/lib/mysql-workbench/modules/tools.grt.lua (WbTools)
** Message: Trying to load module '/usr/lib/mysql-workbench/modules/wb.model.grt.so' (cpp)
** Message: Trying to load module '/usr/lib/mysql-workbench/modules/wb.validation.grt.so' (cpp)
** Message: WARNING: Could not get pointer to grt_module_init in module /usr/lib/mysql-workbench/modules/wb.validation.grt.so (`grt_module_init': /usr/lib/mysql-workbench/modules/wb.validation.grt.so: undefined symbol: grt_module_init)    
** Message: WARNING: Could not load wb.validation.grt.so: Invalid module /usr/lib/mysql-workbench/modules/wb.validation.grt.so    
** Message: Trying to load module '/usr/lib/mysql-workbench/modules/db.mysql.sqlparser.grt.so' (cpp)
** Message: Trying to load module '/usr/lib/mysql-workbench/modules/db.mysql.sqlide.grt.so' (cpp)
** Message: Trying to load module '/usr/lib/mysql-workbench/modules/wb.mysql.validation.grt.so' (cpp)
** Message: WARNING: Could not get pointer to grt_module_init in module /usr/lib/mysql-workbench/modules/wb.mysql.validation.grt.so (`grt_module_init': /usr/lib/mysql-workbench/modules/wb.mysql.validation.grt.so: undefined symbol: grt_module_init)    
** Message: WARNING: Could not load wb.mysql.validation.grt.so: Invalid module /usr/lib/mysql-workbench/modules/wb.mysql.validation.grt.so    
** Message: Trying to load module '/usr/lib/mysql-workbench/modules/wb_admin_grt.py' (python)
Debug level - 0
/usr/lib/python2.6/dist-packages/Crypto/Hash/SHA.py:16: DeprecationWarning: the sha module is deprecated; use the hashlib module instead
  from sha import *
** Message: Trying to load module '/usr/lib/mysql-workbench/modules/wb_utils_grt.py' (python)
** Message: Trying to load module '/usr/lib/mysql-workbench/modules/dbutils.grt.so' (cpp)
** Message: Trying to load module '/usr/lib/mysql-workbench/modules/table_utils.grt.lua' (lua)
** Message: Initialized Lua module /usr/lib/mysql-workbench/modules/table_utils.grt.lua (WbTableUtils)
** Message: Trying to load module '/usr/lib/mysql-workbench/modules/forms.grt.so' (cpp)
** Message: Trying to load module '/usr/lib/mysql-workbench/modules/db.mysql.query.grt.so' (cpp)
** Message: Trying to load module '/usr/lib/mysql-workbench/modules/catalog_utils.grt.lua' (lua)
** Message: Initialized Lua module /usr/lib/mysql-workbench/modules/catalog_utils.grt.lua (WbUtils)
** Message: Trying to load module '/usr/lib/mysql-workbench/plugins/wb.model.editors.wbp.so' (cpp)
** Message: Trying to load module '/usr/lib/mysql-workbench/plugins/db.mysql.wbp.so' (cpp)
** Message: Trying to load module '/usr/lib/mysql-workbench/plugins/db.mysql.diff.reporting.wbp.so' (cpp)
** Message: Trying to load module '/usr/lib/mysql-workbench/plugins/db.mysql.editors.wbp.so' (cpp)
** Message: Trying to load module '/usr/lib/mysql-workbench/plugins/db.checks.wbp.so' (cpp)
** Message: Trying to load module '/usr/lib/mysql-workbench/plugins/wb.printing.wbp.so' (cpp)

** (mysql-workbench-bin:13711): WARNING **: Plugin 'wb.tools.quickTables' from module WbTools has invalid type ''

** (mysql-workbench-bin:13711): WARNING **: :718: link 'com.mysql.wb.menu.view.advanced' <object app.MenuItem> key=owner could not be resolved
_view_impl has NULL ptr at 14
_app_impl has NULL ptr at 5
/usr/lib/python2.6/dist-packages/Crypto/Hash/SHA.py:16: DeprecationWarning: the sha module is deprecated; use the hashlib module instead
  from sha import *
Traceback (most recent call last):
  File "/usr/share/mysql-workbench/sshtunnel.py", line 10, in <module>
    import paramiko
  File "/usr/lib/pymodules/python2.6/paramiko/__init__.py", line 69, in <module>
    from transport import randpool, SecurityOptions, Transport
  File "/usr/lib/pymodules/python2.6/paramiko/transport.py", line 32, in <module>
    from paramiko import util
  File "/usr/lib/pymodules/python2.6/paramiko/util.py", line 32, in <module>
    from paramiko.common import *
  File "/usr/lib/pymodules/python2.6/paramiko/common.py", line 101, in <module>
    randpool = StrongLockingRandomPool()
  File "/usr/lib/pymodules/python2.6/paramiko/rng.py", line 69, in __init__
    instance = _RandomPool()
  File "/usr/lib/python2.6/dist-packages/Crypto/Util/randpool.py", line 57, in __init__
    from Crypto.Hash import SHA as hash
  File "/usr/lib/python2.6/dist-packages/Crypto/Hash/SHA.py", line 16, in <module>
    from sha import *
  File "/usr/lib/python2.6/sha.py", line 10, in <module>
    from hashlib import sha1 as sha
  File "/usr/lib/python2.6/hashlib.py", line 136, in <module>
    md5 = __get_builtin_constructor('md5')
  File "/usr/lib/python2.6/hashlib.py", line 63, in __get_builtin_constructor
    import _md5
ImportError: No module named _md5

** (mysql-workbench-bin:13711): WARNING **: Tunnel manager could not be executed

** (mysql-workbench-bin:13711): WARNING **: Error starting tunnel manager: Cannot start SSH tunnel manager

-Dale

Problem is not present anymore in version 5.2.27 on Ubuntu 10.04

System Information:
MySQL Workbench CE for Linux/Unix version 5.2.27
Data Directory: /usr/share/mysql-workbench
Cairo Version: 1.8.10
Rendering Mode: OpenGL is not available on this system, so Native is used for rendering.
OS: Linux 2.6.32-24-generic
CPU: 2x Intel(R) Core(TM)2 Duo CPU     T7500  @ 2.20GHz 800.000 MHz, 3.8 GB RAM

Under the mysql-workbench-gpl-5.2.33b-win32 installation process, it ask for .net framework 4.0. If the client computer didn't install .net framework 3.5 before, it will only install .net framework 4.0. The bug occur...

You don't necessary to uninstall the mysql-workbench-gpl-5.2.33b-win32. If you install the .net framework 3.5 sp1, it work fine.

Whare can I get the older version of workbench? I am also getting the SSH Tunnel error!

Where can I get the older version of workbench? I am also getting the SSH Tunnel error!