MySQL Bugs: #51476: Problem with manage instances

Bug #51476	Problem with manage instances
Submitted:	24 Feb 2010 20:50	Modified:	26 Mar 2010 10:21
Reporter:	Erik Hommel	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S1 (Critical)
Version:	5.2.16	OS:	Windows (Vista)
Assigned to:	Alfredo Kojima	CPU Architecture:	Any

Description:
Exception = System.Runtime.InteropServices.SEHException
Message = Een extern onderdeel heeft een uitzondering veroorzaakt.
FullText = System.Runtime.InteropServices.SEHException: Een extern onderdeel heeft een uitzondering veroorzaakt.
   bij MySQL.Forms.DrawBoxImpl.drawbox_mouse_click(Object sender, MouseEventArgs e)
   bij System.Windows.Forms.Control.OnMouseClick(MouseEventArgs e)
   bij System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   bij System.Windows.Forms.Control.WndProc(Message& m)
   bij System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   bij System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   bij System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

How to repeat:
Go to manage instances, bug comes up straight away.
I have wampserver 2.0 with MySQL 5.1.36

Thank you for the bug report. I couldn't repeat, please print here the output of Help->System Info?. Thanks in advance.

The contents of Help->System Info:
MySQL Workbench OSS for Windows version 5.2.16
Cairo Version: 1.8.8
Rendering Mode: OpenGL requested (create a diagram to confirm)
OpenGL Driver Version: 2.1.2
OS: Microsoft Windows Vista Business Edition Service Pack 2 (build 6002), 32-bit
CPU: 2x Intel(R) Core(TM)2 CPU         T7400  @ 2.16GHz, 3.3 GiB RAM
Video adapter info:
Adapter type: NVIDIA GeForce Go 7950 GTX
Chip Type: GeForce Go 7950 GTX
BIOS String: Version 5.71.22.45.6
Video Memory: 524288 KB

I will also attach some screen captures in a file

Screencaptures of bug

Attachment: bug MySQL Workbench.doc (application/msword, text), 189.00 KiB.

This happens when a server instance is created with SSH connection deactivated right from the start. WB doesn't write the XML keys for SSH connections to the profile in that case - particularly the following key causes troubles when missing in profile:  
<value type="string" key="sys.config.path"></value>

This also prevents such profiles from launching admin when double-clicking the profile in the list with following output:
Traceback (most recent call last):
  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_grt.py", line 149, in openAdministrator
    do_open_administrator(server_instance)
  File "C:\Program Files (x86)\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 (x86)\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 (x86)\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 (x86)\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'

Bug #51522 has been marked as duplicate of this one

I had same problems under vista 32bit and windows 7 32bit. 

I manually insert the line
   <value type="string" key="sys.config.path"></value> 
in the serverInfo section of the server_instances.xml

This solves the problem in my case.

Where do I find server_instances.xml?

on window systems the file is located in your personal profile like
c:\users\<myaccount>\AppData\Roaming\MySQL\Workbench\

modified server_instances.xml for non-ssh access

Attachment: 2010-03-10_23-42_example.jpg (image/jpeg, text), 145.19 KiB.

Marked bug #51483 as duplicate of this one

This has been fixed. I believe bug #51368 which was closed first is the same issue as this, I'm marking this one as QA review because description and progress log seems more straightforward.

Bug #51978 marked as duplicate of this one

Marked bug #51810 as duplicate of this one

Marked bug #51883 as duplicate

Marked bug #51803 as dupe

fix confirmed in repository

Bug #52115 has been marked as duplicate of this one

Bug #52163 has been marked as duplicate of this one

Bug #51292 has been marked as duplicate of this one

Bug #51668 has been marked as duplicate of this one

Bug #51784 has been marked as duplicate of this one

Bug #51789 has been marked as duplicate of this one

Bug #51940, Bug #51947, Bug #52021, Bug #52028, Bug #52108, Bug #52240 have been marked as duplicate of this one

The entry for bug#51368 has been updated with a list of all duplicates (including bug#51476).

Bug #52407 has been marked as duplicate of this one

Bug #52395 has been marked as duplicate of this one

bug #52452 has been marked as duplicate of this one

Bug #52674 has been marked as duplicate of this one

Bug #52697 has been marked as duplicate of this one