Bug #51297 MySql Workbench crashes on loading Server Administration
Submitted: 18 Feb 2010 21:29 Modified: 5 Apr 2010 10:24
Reporter: Chuck Syperski Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S1 (Critical)
Version:5.2.16 Beta OS:Linux (Ubuntu 9.10 x64)
Assigned to: CPU Architecture:Any
Tags: administrator, crash

[18 Feb 2010 21:29] Chuck Syperski
Description:
The server administration portion crashes after clicking on the "Server Administation" on the Home screen, then selecting the the connection name and selecting OK.

I get the following at the command line:

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

** (mysql-workbench-bin:19235): 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
** Message: item_activated: 0x3a5a0c0 -> 'builtin:show_about'
** Message: item_activated: 0x3a5a0c0 -> 'builtin:show_about'
** Message: function call error
Traceback (most recent call last):
  File "/usr/lib/mysql-workbench/modules/wb_admin_grt.py", line 240, in tmpAdministratorShortcut
    tab = do_open_administrator(server)
  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'

glibmm-ERROR **: 
unhandled exception (type std::exception) in signal handler:
what: error calling WbAdmin.tmpAdministratorShortcut: see output for details

aborting...
Aborted

How to repeat:
Create a data connection, select "Server Administration", select datasource and click OK.

Suggested fix:
None
[19 Feb 2010 10:29] Susanne Ebrecht
Many thanks for writing a bug report.

The connecxtion itself is working?

Do you use password or no password in your connection?
[19 Feb 2010 13:05] Chuck Syperski
I have just tried with and without the password stored, both cause the application to crash.  I am able to test the connection and it connects successfully in the manage connections section.  Please let me know if I can provide any further information.
[23 Feb 2010 8:43] Susanne Ebrecht
How did you install Workbench?
[23 Feb 2010 12:57] Chuck Syperski
Via deb:

$ dpkg -s mysql-workbench-oss
Package: mysql-workbench-oss
Status: install ok installed
Priority: extra
Section: utils
Installed-Size: 163620
Maintainer: MySQL Workbench team <workbench@sun.com>
Architecture: amd64
Source: mysql-workbench
Version: 5.2.16-1ubu910
Depends: libatk1.0-0 (>= 1.20.0), libbonobo2-0 (>= 2.15.0), libc6 (>= 2.7), libcairo2 (>= 1.7.2), libcairomm-1.0-1 (>= 1.6.4), libfontconfig1 (>= 2.4.0), libfreetype6 (>= 2.2.1), libgcc1 (>= 1:4.1.1), libgl1-mesa-glx | libgl1, libglade2-0 (>= 1:2.6.1), libglib2.0-0 (>= 2.16.0), libglibmm-2.4-1c2a (>= 2.22.0), libgnome-keyring0 (>= 2.22.2), libgnome2-0 (>= 2.17.3), libgtk2.0-0 (>= 2.8.0), libgtkmm-2.4-1c2a (>= 1:2.18.0), liblua5.1-0, libmysqlclient15off (>= 5.0.27-1), liborbit2 (>= 1:2.14.10), libpango1.0-0 (>= 1.14.0), libpangomm-1.4-1 (>= 2.24.0), libpcre3 (>= 7.7), libpopt0 (>= 1.14), libsigc++-2.0-0c2a (>= 2.0.2), libsqlite3-0 (>= 3.6.16), libstdc++6 (>= 4.4.0), libuuid1 (>= 2.16-1), libxml2 (>= 2.7.4), libzip1, zlib1g (>= 1:1.2.0), python-paramiko, python-pexpect, mysql-client, gnome-keyring
Description: MySQL Workbench
 A database diagramming and development tool for MySQL.
Homepage: http://dev.mysql.com/workbench/
[24 Feb 2010 22:35] J P
I am getting the same behavior while using 5.2.16 on Windows XP SP3 32-bit.

When I click Server Administration, select my instance and click OK, I get the following exception.  This is with both saved and unsaved password in the vault:

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_grt.py", line 240, in tmpAdministratorShortcut
    tab = do_open_administrator(server)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_grt.py", line 125, in do_open_administrator
    adminTab = AdministratorTab(server_instance)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_grt.py", line 95, in __init__
    self.configuration = wb_admin_configuration.WbAdminConfiguration(server_instance_settings, self.ctrl_be, self.monitor)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_configuration.py", line 60, in __init__
    sys_config_path = self.ctrl_be.get_config_file_path()
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/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'

In addition, I am able to create a new server instance and the connection tests successfully.  However, when I double click on the instance in the Server Administration list, the following slightly different exception is in output:

Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_grt.py", line 149, in openAdministrator
    do_open_administrator(server_instance)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_grt.py", line 125, in do_open_administrator
    adminTab = AdministratorTab(server_instance)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_grt.py", line 95, in __init__
    self.configuration = wb_admin_configuration.WbAdminConfiguration(server_instance_settings, self.ctrl_be, self.monitor)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_configuration.py", line 60, in __init__
    sys_config_path = self.ctrl_be.get_config_file_path()
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/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'
[25 Feb 2010 16:18] MySQL Verification Team
Administration on Ubuntu 9.10

Attachment: wb-admin.png (image/png, text), 131.16 KiB.

[25 Feb 2010 16:19] MySQL Verification Team
I couldn't repeat on Ubuntu 9.10 X64 (I attached a picture).
[3 Mar 2010 15:49] William Warby
I'm seeing this same behaviour on Mac OS X 10.6.2 with Workbench 5.2.16 beta which I downloaded yesterday.

I found I could create a connection on the SQL Development side of Workbench but when I tried to use the same connection on the Server Administration side, I got the error (output below). I tried two different connections with different hostnames but they are both on the same remote server (Dreamhost) which I believe is running BSD and MySQL version 5.0.88-userstats-log if that helps you. A localhost connection to Server Administration works fine. For the moment I'm reverting to the old MySQL Administrator tool - I hope this gets fixed soon as the new workbench looks COOL!

Traceback (most recent call last):
  File "/Applications/MySQLWorkbench.app/Contents/PlugIns/wb_admin_grt.py", line 149, in openAdministrator
    do_open_administrator(server_instance)
  File "/Applications/MySQLWorkbench.app/Contents/PlugIns/wb_admin_grt.py", line 125, in do_open_administrator
    adminTab = AdministratorTab(server_instance)
  File "/Applications/MySQLWorkbench.app/Contents/PlugIns/wb_admin_grt.py", line 95, in __init__
    self.configuration = wb_admin_configuration.WbAdminConfiguration(server_instance_settings, self.ctrl_be, self.monitor)
  File "/Applications/MySQLWorkbench.app/Contents/PlugIns/wb_admin_configuration.py", line 60, in __init__
    sys_config_path = self.ctrl_be.get_config_file_path()
  File "/Applications/MySQLWorkbench.app/Contents/PlugIns/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'
[5 Mar 2010 10:24] Susanne Ebrecht
Did you configure in the workbench server instance the server start/stop and daemon process correct?

Do you have a my.cnf?
[5 Mar 2010 11:38] William Warby
Susanne,

In my case, I didn't configure the my.cnf section. I am using a shared MySQL instance provided by my web host so I have no control over the MySQL service itself or it's configuration file. What I need to be able to do is import and export backups from this part of Workbench as that's all I'm allowed to do. MySQL Administrator permits this function whilst disabling most of the other tabs.
[10 Mar 2010 23:42] 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"))
[5 Apr 2010 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".