Bug #51758 Unable to do server administration using workbench
Submitted: 5 Mar 2010 6:37 Modified: 10 Apr 2010 10:24
Reporter: Shaun van Wyngaard Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S1 (Critical)
Version:5.2.16 beta rev 5249 OS:Microsoft Windows (XP SP3)
Assigned to: CPU Architecture:Any

[5 Mar 2010 6:37] Shaun van Wyngaard
Description:
Trying to connect to server, first time running the program, previously used Administrator.

Exception = System.Runtime.InteropServices.SEHException
Message = External component has thrown an exception.
FullText = System.Runtime.InteropServices.SEHException: External component has thrown an exception.
   at MySQL.Forms.DrawBoxImpl.drawbox_mouse_click(Object sender, MouseEventArgs e)
   at System.Windows.Forms.Control.OnMouseClick(MouseEventArgs e)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

How to repeat:
Click server administrator, select the server to connect to (in my case "Server 1") and click OK.
[5 Mar 2010 6:39] Susanne Ebrecht
Did you test if the connection is working at all?
[5 Mar 2010 7:45] Shaun van Wyngaard
Yes. I am trying to do Server Administration, I click at bottom "Manage Server Instances". my server is selected by default on left panel, I click "Manage Connections" while in the drop-down is selected already "Server 1 - root@193.1.1.52:3306 <Standard(TCP/IP)>.
I select my server from Stored Connections panel in left, click test connection and it responds by "Connection parameters are correct"
[5 Mar 2010 9:06] Susanne Ebrecht
Did you configure services correct?
[5 Mar 2010 9:29] Shaun van Wyngaard
By services, I'm assuming you're talking about Windows Services?
Status of MySQL:Started
Startup type:Automatic

I previously used MySQL Administrator 1.2.17, had no problems connecting to the server. I still have it loaded at this point, and I can still connect using it.
[5 Mar 2010 9:48] Susanne Ebrecht
I meant in the instance configuration. If you set there the right service name for your MySQL server service on Windows.
[5 Mar 2010 10:02] Shaun van Wyngaard
I look for this info under "Manage Server Instances"?
Two tabs are shown, Connection & system Profile
Under Connection:
Connection:Server 1 - root@193.1.1.52:3306 <Standard (TCP/IP)>
MySQL Server Version:5.0.22-community-nt

SSH Shell Connection is not enabled, don't know about this???

Under System Profile tab:
System Type:Windows
Installation Type:Windows (MySQL5.0 x64 Installer Package)
Everything else is grayed out.

Please excuse my ignorance if I am looking in wrong place.
[10 Mar 2010 10:24] Susanne Ebrecht
http://dev.mysql.com/doc/workbench/en/wb-manage-server-instance-dialog.html

Look at Figure 7.2.

Did you configure there the correct service name for your MySQL server at the field "Instance name from my.ini"
[10 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".