MySQL Bugs: #28959: mysql-administrator binary does not work on Ubuntu

Bug #28959	mysql-administrator binary does not work on Ubuntu
Submitted:	7 Jun 2007 20:49	Modified:	10 Jul 2008 17:21
Reporter:	Richard Bronosky	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	5.0r12	OS:	Linux (Ubuntu 7.04 (Feisty), 7.10)
Assigned to:		CPU Architecture:	Any
Tags:	regression

Description:
When trying to use mysql-administrator as found in mysql-gui-tools-5.0r12-linux-i386, the "Connect to MySQL Server Instance" window is displayed.  When the "Connect" button is pressed, the app dies delivers the following message to the console:
./mysql-administrator-bin: symbol lookup error: /usr/lib/libbonoboui-2.so.0: undefined symbol: g_type_register_static_simple

How to repeat:
wget http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-gui-tools-5.0r12-linux-i386.tar.gz/...
tar zxvf mysql-gui-tools-5.0r12-linux-i386.tar.gz
cd mysql-gui-tools-5.0r11b-linux-i386
./mysql-administrator --update-paths
# You get prompted to do this if you run ./mysql-administrator directly
./mysql-administrator
# Supply "Server Hostname", "Username", and "Password" then click "Connect" button.
# Observe the follow messages in the console:
(mysql-administrator-bin:17941): Gtk-WARNING **: Unable to locate theme engine in module_path: "ubuntulooks",
Fontconfig warning: line 32: unknown element "cachedir"
Fontconfig warning: line 33: unknown element "cachedir"
Fontconfig warning: "/etc/fonts/conf.d/80-delicious.conf", line 18: invalid match target "scan"
./mysql-administrator-bin: symbol lookup error: /usr/lib/libbonoboui-2.so.0: undefined symbol: g_type_register_static_simple

Suggested fix:
I downloaded the source for http://packages.ubuntu.com/edgy/libs/libbonoboui2-0 and http://packages.ubuntu.com/feisty/libs/libbonoboui2-0 then greped it for g_type_register_static_simple.  It seems to me that your bundled dependencies are expecting something from the system that is not present.

I was able to download the gui tools source tar ball from http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-gui-tools-5.0r12.tar.gz/from/pick and build it successfully via:
sudo aptitude install libpcre3-dev libmysqlclient15-dev libglib2.0-dev libxml2-dev libglade2-dev libgtkmm-2.4-dev g++
cd mysql-gui-common
./configure
make
make install
cd ../mysql-administrator
./configure
make
make install

The resulting mysql-administrator seemed to work fine.

My I please add that the aptitude install requirements were grueling to come up with (for an intermediate like myself).  Also, the configure script didn't realize that I was missing g++ because Ubuntu started putting scripts in place that echo something like "to get $0 run apt-get install..."  I was only clued into to this when "cc1plus" couldn't be found.

Bug #28952 was marked as a duplicate of this one.

Thank you for the report.

Verified on Ubuntu 6 with different error: "./mysql-administrator-bin: 1: Syntzx error: "(" unexpected"

Sorry: used wrong binaries. Ignore previous comment.

Status of the report changed to "Analyzing"

Thank you for the report.

> cd mysql-gui-tools-5.0r11b-linux-i386
> ./mysql-administrator --update-paths

You indicated you cd into 5.0r11b directory. Was it missprint? If wasn't, please run ./mysql-administrator --update-paths with new 5.0.r12 version.

Also please provide output of ldd mysql-administrator-bin

I have the same problem. Output of ldd mysql-administrator-bin

        linux-gate.so.1 =>  (0xffffe000)
        libpthread.so.0 => /lib/tls/i686/cmov/libpthread.so.0 (0xb7edd000)
        libcrypt.so.1 => /lib/tls/i686/cmov/libcrypt.so.1 (0xb7eaf000)
        libnsl.so.1 => /lib/tls/i686/cmov/libnsl.so.1 (0xb7e97000)
        libglade-2.0.so.0 => /usr/lib/libglade-2.0.so.0 (0xb7e7f000)
        libxml2.so.2 => /usr/lib/libxml2.so.2 (0xb7d62000)
        libgtkmm-2.4.so.1 => /usr/lib/libgtkmm-2.4.so.1 (0xb7a48000)
        libgdkmm-2.4.so.1 => /usr/lib/libgdkmm-2.4.so.1 (0xb7a03000)
        libatkmm-1.6.so.1 => /usr/lib/libatkmm-1.6.so.1 (0xb79c1000)
        libgtk-x11-2.0.so.0 => /usr/lib/libgtk-x11-2.0.so.0 (0xb7668000)
        libpangomm-1.4.so.1 => /usr/lib/libpangomm-1.4.so.1 (0xb763d000)
        libglibmm-2.4.so.1 => /usr/lib/libglibmm-2.4.so.1 (0xb75ec000)
        libsigc-2.0.so.0 => /usr/lib/libsigc-2.0.so.0 (0xb75e6000)
        libgdk-x11-2.0.so.0 => /usr/lib/libgdk-x11-2.0.so.0 (0xb7560000)
        libatk-1.0.so.0 => /usr/lib/libatk-1.0.so.0 (0xb7545000)
        libgdk_pixbuf-2.0.so.0 => /usr/lib/libgdk_pixbuf-2.0.so.0 (0xb752d000)
        libm.so.6 => /lib/tls/i686/cmov/libm.so.6 (0xb7506000)
        libpangocairo-1.0.so.0 => /usr/lib/libpangocairo-1.0.so.0 (0xb74fe000)
        libfontconfig.so.1 => /usr/lib/libfontconfig.so.1 (0xb74d3000)
        libXext.so.6 => /usr/lib/libXext.so.6 (0xb74c5000)
        libXrender.so.1 => /usr/lib/libXrender.so.1 (0xb74bd000)
        libXinerama.so.1 => /usr/lib/libXinerama.so.1 (0xb74b9000)
        libXi.so.6 => /usr/lib/libXi.so.6 (0xb74b1000)
        libXrandr.so.2 => /usr/lib/libXrandr.so.2 (0xb74ab000)
        libXcursor.so.1 => /usr/lib/libXcursor.so.1 (0xb74a2000)
        libXfixes.so.3 => /usr/lib/libXfixes.so.3 (0xb749d000)
        libpango-1.0.so.0 => /usr/lib/libpango-1.0.so.0 (0xb745f000)
        libcairo.so.2 => /usr/lib/libcairo.so.2 (0xb73ee000)
        libX11.so.6 => /usr/lib/libX11.so.6 (0xb72fd000)
        libgobject-2.0.so.0 => /usr/lib/libgobject-2.0.so.0 (0xb72c3000)
        libgmodule-2.0.so.0 => /usr/lib/libgmodule-2.0.so.0 (0xb72c0000)
        libdl.so.2 => /lib/tls/i686/cmov/libdl.so.2 (0xb72bc000)
        libglib-2.0.so.0 => /usr/lib/libglib-2.0.so.0 (0xb7227000)
        libutil.so.1 => /lib/tls/i686/cmov/libutil.so.1 (0xb7222000)
        libpcre.so.3 => /usr/lib/libpcre.so.3 (0xb7202000)
        libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0xb7118000)
        libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xb710c000)
        libc.so.6 => /lib/tls/i686/cmov/libc.so.6 (0xb6fcb000)
        /lib/ld-linux.so.2 (0xb7f02000)
        libz.so.1 => /usr/lib/libz.so.1 (0xb6fb6000)
        libcairomm-1.0.so.1 => /usr/lib/libcairomm-1.0.so.1 (0xb6f9f000)
        libpangoft2-1.0.so.0 => /usr/lib/libpangoft2-1.0.so.0 (0xb6f74000)
        libfreetype.so.6 => /usr/lib/libfreetype.so.6 (0xb6f09000)
        libexpat.so.1 => /usr/lib/libexpat.so.1 (0xb6ee8000)
        libXau.so.6 => /usr/lib/libXau.so.6 (0xb6ee5000)
        libpng12.so.0 => /usr/lib/libpng12.so.0 (0xb6ec2000)
        libXdmcp.so.6 => /usr/lib/libXdmcp.so.6 (0xb6ebd000)

I also have this bug with the latest generic binaries of the GUI tools, on a current Gentoo system.

i have below error in Fedora 7 with mysql-gui-tools-5.0r12-linux-i386.tar.gz
Any help?

[root@birmingham mysql-gui-tools-5.0]# ./mysql-administrator --update-pathsUpdating mysql-administrator installation paths...
Done.
[root@birmingham mysql-gui-tools-5.0]# ldd mysql-administrator-bin
        linux-gate.so.1 =>  (0x00110000)
        libpthread.so.0 => /lib/libpthread.so.0 (0x4c8e2000)
        libcrypt.so.1 => /lib/libcrypt.so.1 (0x4d9e6000)
        libnsl.so.1 => /lib/libnsl.so.1 (0x4cb83000)
        libglade-2.0.so.0 => /usr/lib/libglade-2.0.so.0 (0x4dc25000)
        libxml2.so.2 => /usr/lib/libxml2.so.2 (0x4cf09000)
        libgtkmm-2.4.so.1 => not found
        libgdkmm-2.4.so.1 => not found
        libatkmm-1.6.so.1 => not found
        libgtk-x11-2.0.so.0 => /usr/lib/libgtk-x11-2.0.so.0 (0x4d248000)
        libpangomm-1.4.so.1 => not found
        libglibmm-2.4.so.1 => not found
        libsigc-2.0.so.0 => not found
        libgdk-x11-2.0.so.0 => /usr/lib/libgdk-x11-2.0.so.0 (0x4d128000)
        libatk-1.0.so.0 => /usr/lib/libatk-1.0.so.0 (0x4d706000)
        libgdk_pixbuf-2.0.so.0 => /usr/lib/libgdk_pixbuf-2.0.so.0 (0x4d0c9000)
        libm.so.6 => /lib/libm.so.6 (0x4c8b0000)
        libpangocairo-1.0.so.0 => /usr/lib/libpangocairo-1.0.so.0 (0x4d6ca000)
        libfontconfig.so.1 => /usr/lib/libfontconfig.so.1 (0x4cdf9000)
        libXext.so.6 => /usr/lib/libXext.so.6 (0x4cb71000)
        libXrender.so.1 => /usr/lib/libXrender.so.1 (0x4d070000)
        libXinerama.so.1 => /usr/lib/libXinerama.so.1 (0x4cee0000)
        libXi.so.6 => /usr/lib/libXi.so.6 (0x4d03e000)
        libXrandr.so.2 => /usr/lib/libXrandr.so.2 (0x4d62c000)
        libXcursor.so.1 => /usr/lib/libXcursor.so.1 (0x4d0e2000)
        libXfixes.so.3 => /usr/lib/libXfixes.so.3 (0x4d0c2000)
        libpango-1.0.so.0 => /usr/lib/libpango-1.0.so.0 (0x4d5e8000)
        libcairo.so.2 => /usr/lib/libcairo.so.2 (0x4d1c7000)
        libX11.so.6 => /usr/lib/libX11.so.6 (0x4ca07000)
        libgobject-2.0.so.0 => /lib/libgobject-2.0.so.0 (0x4cb30000)
        libgmodule-2.0.so.0 => /lib/libgmodule-2.0.so.0 (0x4cba3000)
        libdl.so.2 => /lib/libdl.so.2 (0x4c8db000)
        libglib-2.0.so.0 => /lib/libglib-2.0.so.0 (0x4c911000)
        libutil.so.1 => /lib/libutil.so.1 (0x4d740000)
        libpcre.so.3 => not found
        libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x4d80d000)
        libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x4d724000)
        libc.so.6 => /lib/libc.so.6 (0x4c75a000)
        /lib/ld-linux.so.2 (0x4c73b000)
        libz.so.1 => /lib/libz.so.1 (0x4c8fc000)
        libpng12.so.0 => /usr/lib/libpng12.so.0 (0x4cc91000)
        libpangoft2-1.0.so.0 => /usr/lib/libpangoft2-1.0.so.0 (0x4d6d5000)
        libfreetype.so.6 => /usr/lib/libfreetype.so.6 (0x4cbef000)
        libexpat.so.0 => /lib/libexpat.so.0 (0x4ce2a000)
        libXau.so.6 => /usr/lib/libXau.so.6 (0x4c9fa000)
        libXdmcp.so.6 => /usr/lib/libXdmcp.so.6 (0x4c9ff000)
[root@birmingham mysql-gui-tools-5.0]# 
[root@birmingham mysql-gui-tools-5.0]# ./mysql-administrator
/usr/share/themes/Clearlooks/gtk-2.0/gtkrc:34: error: unexpected character `@', expected string constant
Fontconfig warning: line 32: unknown element "cachedir"
Fontconfig warning: line 33: unknown element "cachedir"
Fontconfig warning: "/etc/fonts/conf.d/80-delicious.conf", line 18: invalid match target "scan"
./mysql-administrator-bin: symbol lookup error: /usr/lib/libbonoboui-2.so.0: undefined symbol: g_type_register_static_simple
[root@birmingham mysql-gui-tools-5.0]#

I have the same problem with fedora 7.

Are there news?

Thank you
Duccio

There is a very simple fix: 
delete libgobject-2.0.so form the /lib dir of mysql-gui-tools:

$ cd /opt/mysql-gui-tools-5.0/lib
$ mv libgobject-2.0.so.0 libgobject-2.0.so.0.bak

This is due to the fact that this messes up the system's installed libgobject libraries in /usr/lib:

$ locate libgobject
/opt/mysql-gui-tools-5.0/lib/libgobject-2.0.so.0
/usr/lib/libgobject-2.0.so.0
/usr/lib/libgobject-2.0.so.0.1200.11

Removing (actually moving it out the way, as suggested above) seems to fix the problem.

See also 
https://www.linuxquestions.org/questions/linux-software-2/gtk-applications-problem-490276/

Works like a charm (deleting libgobject) on Fedora 7.

Thanks!

Still same problem on Ubuntu 7.10
This bug is taking too long, I think :-(

I can confirm that the problem still exists on Ubuntu 7.10 after removing  libgobject-2.0.so.0 from the MySQL Administrator lib folder.

On Ubuntu 7.10 probelm still exists.

Tried mv libgobject-2.0.so.0 libgobject-2.0.so.0.bak

But then get:

./mysql-administrator-bin: symbol lookup error: /usr/lib/libgobject-2.0.so.0: undefined symbol: g_regex_unref

Do we need to build from source?

Similar problem on PCLinuxOS 2007. I'm getting the following error when running mysql-administrator and trying to connect via tcp/ip. When I press the "connect" button I get...

/opt/mysql-gui-tools-5.0/mysql-administrator-bin: symbol lookup error: /usr/lib/libbonoboui-2.so.0: undefined symbol: g_once_init_enter_impl

Happy new year!
I still cannot use mysql-administrator under Ubuntu 7.10:
All I get is:

/opt/mysql-gui-tools-5.0$ ./mysql-administrator
./mysql-administrator-bin: symbol lookup error: /usr/lib/libgobject-2.0.so.0: undefined symbol: g_regex_unref

and I have:

$ locate libgobject
/usr/lib/libgobject-2.0.so.0

This bug is almost 7 months old, with severity S2. Is it going to be patched? Do you need more info? Any news there?

Strace for more info:

/opt/mysql-gui-tools-5.0$ strace ./mysql-administrator
execve("./mysql-administrator", ["./mysql-administrator"], [/* 36 vars */]) = 0
brk(0)                                  = 0x805f000
access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
mmap2(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7fdc000
access("/etc/ld.so.preload", R_OK)      = -1 ENOENT (No such file or directory)
open("/etc/ld.so.cache", O_RDONLY)      = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=56831, ...}) = 0
mmap2(NULL, 56831, PROT_READ, MAP_PRIVATE, 3, 0) = 0xb7fce000
close(3)                                = 0
access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
open("/lib/tls/i686/cmov/libc.so.6", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\260a\1"..., 512) = 512
fstat64(3, {st_mode=S_IFREG|0644, st_size=1339816, ...}) = 0
mmap2(NULL, 1349136, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0xb7e84000
mmap2(0xb7fc8000, 12288, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x143) = 0xb7fc8000
mmap2(0xb7fcb000, 9744, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0xb7fcb000
close(3)                                = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7e83000
set_thread_area({entry_number:-1 -> 6, base_addr:0xb7e836b0, limit:1048575, seg_32bit:1, contents:0, read_exec_only:0, limit_in_pages:1, seg_not_present:0, useable:1}) = 0
mprotect(0xb7fc8000, 4096, PROT_READ)   = 0
munmap(0xb7fce000, 56831)               = 0
getpid()                                = 7434
rt_sigaction(SIGCHLD, {SIG_DFL}, {SIG_DFL}, 8) = 0
geteuid32()                             = 1000
brk(0)                                  = 0x805f000
brk(0x8080000)                          = 0x8080000
getppid()                               = 7433
stat64("/opt/mysql-gui-tools-5.0", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
stat64(".", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
open("./mysql-administrator", O_RDONLY) = 3
fcntl64(3, F_DUPFD, 10)                 = 10
close(3)                                = 0
fcntl64(10, F_SETFD, FD_CLOEXEC)        = 0
rt_sigaction(SIGINT, NULL, {SIG_DFL}, 8) = 0
rt_sigaction(SIGINT, {0x80551b0, ~[RTMIN RT_1], 0}, NULL, 8) = 0
rt_sigaction(SIGQUIT, NULL, {SIG_DFL}, 8) = 0
rt_sigaction(SIGQUIT, {SIG_DFL}, NULL, 8) = 0
rt_sigaction(SIGTERM, NULL, {SIG_DFL}, 8) = 0
rt_sigaction(SIGTERM, {SIG_DFL}, NULL, 8) = 0
read(10, "#!/bin/sh\n\nPRG=\"$0\"\n\n# need this"..., 8192) = 3186
lstat64("./mysql-administrator", {st_mode=S_IFREG|0755, st_size=3186, ...}) = 0
pipe([3, 4])                            = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0xb7e836f8) = 7435
--- SIGCHLD (Child exited) @ 0 (0) ---
close(4)                                = 0
read(3, ".\n", 128)                     = 2
read(3, "", 128)                        = 0
close(3)                                = 0
wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], 0, NULL) = 7435
pipe([3, 4])                            = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0xb7e836f8) = 7436
--- SIGCHLD (Child exited) @ 0 (0) ---
close(4)                                = 0
read(3, "/opt\n", 128)                  = 5
read(3, "", 128)                        = 0
close(3)                                = 0
wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], 0, NULL) = 7436
pipe([3, 4])                            = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0xb7e836f8) = 7437
--- SIGCHLD (Child exited) @ 0 (0) ---
close(4)                                = 0
read(3, "/opt/mysql-gui-tools-5.0\n", 128) = 25
read(3, "", 128)                        = 0
close(3)                                = 0
wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], 0, NULL) = 7437
stat64("/opt/share", 0xbf90144c)        = -1 ENOENT (No such file or directory)
stat64("/opt/mysql-gui-tools-5.0/share", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
stat64("/opt/mysql-gui-tools-5.0/lib/pango.modules", {st_mode=S_IFREG|0644, st_size=485, ...}) = 0
pipe([3, 4])                            = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0xb7e836f8) = 7438
close(4)                                = 0
read(3, "/opt/mysql-gui-tools-5.0\n", 128) = 25
read(3, "", 128)                        = 0
close(3)                                = 0
wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], 0, NULL) = 7438
--- SIGCHLD (Child exited) @ 0 (0) ---
stat64("/opt/mysql-gui-tools-5.0/lib/pango.modules", {st_mode=S_IFREG|0644, st_size=485, ...}) = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0xb7e836f8) = 7441
wait4(-1, ./mysql-administrator-bin: symbol lookup error: /usr/lib/libgobject-2.0.so.0: undefined symbol: g_regex_unref
[{WIFEXITED(s) && WEXITSTATUS(s) == 127}], 0, NULL) = 7441
--- SIGCHLD (Child exited) @ 0 (0) ---
read(10, "", 8192)                      = 0
exit_group(127)                         = ?
Process 7434 detached

To fix this problem in Ubuntu 7.10 try to (re)move 'lib' in /opt/mysql-gui-tools-5.0

mv lib lib_

Next create empty directory '/etc/mysql/conf.d'

That's all :) In some systems may be necessary to install missing libraries (previously present in '/opt/mysql-gui-tools-5.0/lib').

>[6 Jan 20:00] Pawel Dys

>To fix this problem in Ubuntu 7.10 try to (re)move 'lib' in >/opt/mysql-gui-tools-5.0

>mv lib lib_

>Next create empty directory '/etc/mysql/conf.d'

>That's all :) In some systems may be necessary to install missing libraries >(previously
>present in '/opt/mysql-gui-tools-5.0/lib').

!!!!!GREAT, IT WORKS !!!!!!!!!!!!1

This info was very helpful, but I found that I had to install a good many more dev packages (e.g. libglade-2.0) before the gui tools would compile successfully.

Thank you for the report.

I can not repeat described behavior neither on Kubuntu 7.04, nor on different Linux installations. Probably you use broken package. So I close the report as "Can't repeat".