Bug #47070 MySQL Administrator error when Options tab selected. No actual options presented

• Submitted: 2 Sep 2009 17:44
• Modified: 16 Nov 2009 17:54
• Reporter: Rad Van
• Status: Won't fix
• Category: MySQL Administrator
• Severity: S2 (Serious)
• Version: 1.2.12
• OS: MacOS (10.6)
• CPU Architecture: Any
• Tags: Administrator Mac Options Error

[2 Sep 2009 17:44] Rad Van

Description:
The error message:

Alert
Could not open GUI description file.
Error parsing XML file (bad document)

How to repeat:
Install Mac OS X 10.6
remove MySQL installation that comes with the OS
Install from mysql-5.1.37-osx10.5-x86_64.dmg
Install GUI tools from mysql-gui-tools-5.0-r12-osx10.4-universal.dmg
start MySQL service
connect with MySQL administrator
click on the Options tab
the error message described above is presented
click OK
MySQK Network Monitoring & Advisory Service ad is presented.
No actual MySQL options are presented. Administration & Security Advisors is the only option in the drop down menu

[2 Sep 2009 18:37] Valeriy Kravchuk

According to http://www.mysql.com/support/supportedplatforms/tools.html MySQL Administrator is NOT supported on any Mac OS X. Sorry.

[15 Sep 2009 19:42] Rod Spears

I worked fine for me on Mac OS X Leopard, stopped working when I installed Snow Leopard.

[15 Sep 2009 19:59] Rad Van

yeah, same for me. too bad they don't (seem) to care.

[26 Sep 2009 6:33] Johan Borchers

For me the same. Snow Leopard and installing mysql-gui-tools-5.0-r12-osx10.4-universal.dmg gives the error message on selecting the options tab:

Could not open GUI description file.
Error parsing XML file (bad document).

Johan

[31 Oct 2009 16:33] Eric Tiffany

Despite the earlier post, it seems that the GUI tools are supposed to work on MacOS (at least up through 10.4, which is now pretty dated).  See the installation notes here: http://dev.mysql.com/doc/administrator/en/gui-tools-installation-osx.html

Also, I can report that the GUI tools version included with the 5.1.40 release (which is 1.2.12) still has this problem.

[15 Nov 2009 6:01] Ramsey Gurley

If you check the console log, you'll find that the problem is the /Applications/MySQL Tools/MySQL Administrator.app/Contents/Resources/mysqladmin_startup_variables_description.xml is failing to load because it cannot find the DTD in the same directory.  It turns out that the spaces in the default file path is the problem here.  On Snow Leopard, just change that path to /Applications/MySQL_Tools/MySQL_Administrator.app or something else without spaces, and the Options pane will load up.  BTW, who marked this a Won't fix?  That's pretty lame guys, especially when something like this should be a simple fix.

[16 Nov 2009 13:36] Simon McLean

Same problem here. Ramsays extremely simple solution fixes this issue (thanks!). Agree with his comments too on whoever closed this as "won't fix"....

[16 Nov 2009 17:54] Rad Van

I assume it was marked "Won't Fix" by Valeriy. I also think they're aren't looking at our comments anymore because of it.

[5 Dec 2009 23:35] Raymond Gree

Ramsay
can you help telling what needs to be modified, I tried to find the related files without success
thanks if you have a little bit time to help
Ray

[6 Apr 2010 4:53] Hui Ong

It's pretty simple thanks to Ramsey. All I had to do to fix this for myself was to move MySQL Administrator into Applications (instead of being in MySQL Tools), then rename the app as "MySQL_Administrator". Start the app and all should be well.

[9 Mar 2011 21:30] Bruno Lallemand

I have done the same, and it is working (Mac OS 10.6.6)...

Thanks

bruno