Bug #51883 Server Instance fails to connect over SSH Tunnel
Submitted: 9 Mar 2010 18:39 Modified: 16 Mar 2010 2:35
Reporter: Jose Alejandro Carrillo Neira Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S2 (Serious)
Version:5.2.16 OS:Linux (Debian "Squeeze" 6.0)
Assigned to: Assigned Account CPU Architecture:Any
Tags: Instance, server, ssh, sys.config.path, tunnel

[9 Mar 2010 18:39] Jose Alejandro Carrillo Neira
Description:
Hello,

I tried to establish a server instance over an SSH Tunner, and though it successfully recognized and logged into the system prior to finishing the Wizard, afterwards it would not connect.

I fired up my console and did the same. I got his Python Traceback as a result:

** Message: function call error
Traceback (most recent call last):
  File "/usr/lib/mysql-workbench/modules/wb_admin_grt.py", line 149, in openAdministrator
    do_open_administrator(server_instance)
  File "/usr/lib/mysql-workbench/modules/wb_admin_grt.py", line 125, in do_open_administrator
    adminTab = AdministratorTab(server_instance)
  File "/usr/lib/mysql-workbench/modules/wb_admin_grt.py", line 95, in __init__
    self.configuration = wb_admin_configuration.WbAdminConfiguration(server_instance_settings, self.ctrl_be, self.monitor)
  File "/usr/lib/mysql-workbench/modules/wb_admin_configuration.py", line 60, in __init__
    sys_config_path = self.ctrl_be.get_config_file_path()
  File "/usr/lib/mysql-workbench/modules/wb_admin_control_be.py", line 667, in get_config_file_path
    return self.expand_path_variables(self.settings.serverInfo['sys.config.path'].strip(" \r\t\n\b"))
AttributeError: 'NoneType' object has no attribute 'strip'

How to repeat:
- Create a new instance.
- Choose Standard TCP/IP over SSH, and write your usual connection data.
- Disable SSH Administration.
- Start your new server instance.
- Voila, check your console.

Suggested fix:
Object type checking on 'self.settings.serverInfo['sys.config.path']' prior to accessing a method, perhaps?
[9 Mar 2010 18:40] Jose Alejandro Carrillo Neira
Oh, as an addenum, as soon as you finish, click "New Server Instance". You may be in for a treat.

Attachment: addenum.txt (text/plain), 74.78 KiB.

[15 Mar 2010 15:37] Jesse Shaffer
I have it installed on Windows, and edited the following to make it work:

On line 666 of modules\wb_admin_config_be.py:

    def get_config_file_path(self):
	  scp = self.settings.serverInfo['sys.config.path']
	  if scp is None:
	    return None
	  return self.expand_path_variables(scp.strip(" \r\t\n\b"))
[16 Mar 2010 2:35] Alfredo Kojima
This is a duplicate of bug #51476, which has been fixed.