MySQL Bugs: #24325: No theme loaded on MySQL GUI Tools on Ubuntu Edgy

Bug #24325	No theme loaded on MySQL GUI Tools on Ubuntu Edgy
Submitted:	15 Nov 2006 0:55	Modified:	16 Apr 2009 13:13
Reporter:	Erick Oliveira	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.2.5rc	OS:	Linux (Ubuntu 6.10 (Edgy))
Assigned to:	Alfredo Kojima	CPU Architecture:	Any
Tags:	appearance, edgy, gtk-warning, GUI, ubuntu, ubuntulooks

Description:
I have downloaded and installed the MySQL GUI tools to my Ubuntu Edgy, and when I try to start them from command line, I receive the following messages:

(mysql-administrator-bin:10868): Gtk-WARNING **: Impossível localizar a ferramenta de temas no module_path: "ubuntulooks",

(mysql-query-browser-bin:10991): Gtk-WARNING **: Impossível localizar a ferramenta de temas no module_path: "ubuntulooks",

And with MySQL Workbench I receive the following:

(mysql-workbench-bin:11016): Gtk-WARNING **: Impossível localizar a ferramenta de temas no module_path: "ubuntulooks",

** (mysql-workbench-bin:11016): WARNING **: Error getting color presets.

Both query browser and administrator starts, but have an horrible appearance with no theme related. The workbenh doesn't starts and never seen running.

How to repeat:
Download mysql-gui-tools-5.0r5-linux-i386.tar.gz file on Ubuntu Edgy.
Extract the file to '/opt' eg.
 
cd /opt
tar zxvf mysql-gui-tools-5.0r5-linux-i386.tar.gz

Enter the new directory created: 'mysql-gui-tools-5.0' and try to run applications inside:

cd mysql-gui-tools-5.0
./mysql-adminsitrator

OR

./mysql-query-browser

I installed the GUI Toolkit to /opt and had the same issue.

I have managed to resolve the problem, it is easy, if you look in the source of the shell scripts mysql-administrator, mysql-query-browser, mysql-workbench, it can be seen, that when the script uses tmp_DIRNAME2 to load the application, it does not set the lib prefix correctly.

I'm attaching a patch file for this.

@@ -25,7 +25,7 @@
 elif [ -d "$tmp_DIRNAME2/share" ]; then
     # installed to /opt or something similar
     DIRNAME="$tmp_DIRNAME2"
-    LIBPREFIX="$DIRNAME"
+    LIBPREFIX="$DIRNAME/lib/mysql-gui"
 else
     echo "Data files not found. Please check your installation."
     exit 1

I've tried your patch and it doesn't work.  I think the problem lies with the package being static.  I've scoured through the mysql-gui-tools directory tree and have managed to find a folder named gtk-engines.  Might it be that we have to put some gtk-engine files in there to make the gui work?  If so, what files are these?  The "gtk-engines-xxxx.so"s?  Can somebody with more technical experience look into this possibility?

Patch worked for me.
thanks

Thank you for reporting a bug. Unfortunately we no longer support MySQL Administrator on your platform. So this bug will not be fixed. Our new GUI tool MySQL Workbench will be supported on Windows, Linux and Mac. We plan to implement all features from Administrator into Workbench (if not already there).