MySQL Bugs: #15659: Query Browser 1.1.15 Crashes on SuSe 10.0

Bug #15659	Query Browser 1.1.15 Crashes on SuSe 10.0
Submitted:	11 Dec 2005 1:04	Modified:	21 Jan 2006 9:49
Reporter:	Steve Ruane	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S1 (Critical)
Version:	1.1.15	OS:	Linux (SuSE 10.0)
Assigned to:		CPU Architecture:	Any

Description:
Running MySql 5.0.16 on SuSE 10.0. This is a compile from source using gcc 4.0.2. I tried the compiled binary too (compiled on SuSE 9.3).

MySql Administrator is unstable and crashes randomly (v1.1.3), but it is useable. 

QueryBrowser (v1.1.15), however crashes immedaitely when I click "Connect". If I deliebrately supply bogus login credentials, it reports that the user is unauthorized, so it seems to be hitting the database, but if I click "connect" after supplying valid credentials it crashes immediately.

There is no error message that I've been able to capture.

I also have the 5.0.16 client installed.

How to repeat:
To repeat this error: install MySql v5.0.16 on SuSE 10.0 with Query Browser 1.1.15 and click "Connect" as the root user.

Suggested fix:
rpm specific to SuSE 10.0

Can you, please, try to use generic 1.1.17-1 RPM or build it from 1.1.17 sources (both are available at http://dev.mysql.com/downloads/query-browser/1.1.html)? I do not think that using 1.1.15 RPMs for SuSE 9.3 is the best idea in your case.

Please, try and inform about the results.

Thank you for your quick response.

It just doesn't work.

I started with a clean install of SuSE 10.0

installed samba 3.0.20b
installed MySql Server 5.0.16.glibc23 (generic rpm)
Mysql Administrator 1.1.4-1 (generic rpm)
and attempted to install MySql Query Browser 1.1.17-1 (generic rpm) and it simply woudln't install reporting that it requires libgtkhtml-3.6.so.18

Using the mysql command-line interface, I defined and populated two databases and started mysql administrator. MySql Administrator was extremely unstable and crashed intemittently. Then it droped the two schemas I had defined. MySql Administrator 1.1.4-1 isn't useable, and causes a loss of data.

But MySql query browser 1.1.17-1 simply won't install at all.

I'm going to try to build MySql administrator and query browser from source, but wasn't able to before due to  library errors. However, I'll try to build a copy while I wait for your next suggestion.

Thanks for your efforts,

Steve

Sorry about that weird behaviour of QB and Administrator on your platform There are many bug reports for them on SuSE 10 (and OpenSuSE 10), so, I think, some incompatibility problem really exists.

Do you really have this libgtkhtml-3.6.so.18 on your machine? If no, you'll have to upgrade the library. Please, send the results of the 

ls libgtk*

command from your libraries directory.

Inform about any errors you'll get during compile from sources.

Again, I thank you for your quick response.

I had to reinstall SuSE 10.0 again. Due to a change in disk controller, I had to install the 64-bit version. If you're curious, I have an intel ICH7R raid controller (4 ports) with three drives in a raid 5 configuration and one drive in the fourth port not part of the array. SuSE 10.0 (32 bit) can't see any of the drives on the ICH7R when its configured this way, but the 64-bit version can. To get around this restriction, up until now I had the fourth drive (the one with SuSE on it) in an external enclosure connected via a USB port. SuSE is unstable when run this way, so I connected the SuSE drive directly to the disk controller.

But I had to install 64-bit SuSE.

And  MySql Server 5.0.16-0.glibc23.x86_64 installed just fine, as did the coresponding client.

I couldn't find a compiled version of MySql Administrator nor MySql Query Browser for x86_64, so I'll have to try to build my own.

I believe, there are no 64-bit binaries of QB on our site, so yes, you'll have to build from sources. Please, inform about any results.

I feel like an idiot. Thanks for your patience.

I have all the prerequisite libraries specified in the MySql 5.0 docummentation and I am unable to get around this error when I run 

sh ./autogen.sh
...
...
...
checking for LC_MESSAGES... yes
checking libintl.h usability... yes
checking libintl.h presence... yes
checking for libintl.h... yes
checking for ngettext in libc... yes
checking for dgettext in libc... yes
checking for bind_textdomain_codeset... yes
checking for msgfmt... /usr/bin/msgfmt
checking for dcgettext... yes
checking for gmsgfmt... /usr/bin/msgfmt
checking for xgettext... no
checking for catalogs to be installed...  ja de pt_BR
./configure: line 5617: ./po/POTFILES.in: No such file or directory
checking for GLIB... configure: error: The pkg-config script could not be found or is too old.  Make sure it
is in your PATH or set the PKG_CONFIG environment variable to the full
path to pkg-config.

Alternatively, you may set the environment variables GLIB_CFLAGS
and GLIB_LIBS to avoid the need to call pkg-config.
See the pkg-config man page for more details.

To get pkg-config, see <http://www.freedesktop.org/software/pkgconfig>.
See `config.log' for more details.

>>>> pkg-config is in my PATH:

linux:/home/admin/mysql-administrator-1.1.5/mysql-gui-common # which pkg-config

/usr/local/bin/pkg-config

...and its verson 0.20

I'm running out of ideas.

An update:

I was able to compile MySql Administrator by building version 1.0.22a from the tarball. It's a little unstable, but its useable. I would prefer to be able to use v1.1, but it simply won't build on open SuSe v10.0 x86_64.

I'm also unable, to build Query Browser. The last release I tried was 1.1.17. It says it needs gtkhtml-3.0, which puts us back where we started when I first submitted this bug report.

I have a copy of gtkhtml-3.0.10, but it won't build either. I'm working on it, though.

If you have any suggestions, I would be delighted to hear them.

Thanks.

I do not think that any new binaries of QB for your platform will be released till the end of the year. I notified the developers about the (numerious) problems on this platform, so we have just to wait.

You may try to compile 1.1.14-1 sources for SuSE 9.3 (http://dev.mysql.com/get/Downloads/MySQLAdministrationSuite/mysql-query-browser-1.1.14-1.s...)
and, if they compile successfully, you may get some hints on how to compile later versions.

Sorry, but I have no SuSE 10.0 and 64-bit platfrom to test the builds myself yet.

Thank you for your efforts.

I was able to bild a stable copy of MySql 5.0.16 from the surce tarball, and a stable copy of Administrator 1.1.5 from the source rpm (but not the source tarball). Query Browser simply will not bulid despite the best application of my limited skills. I will wait for the developers to catch up.

Maybe someone will give you an x86_64 platform for Christmas.

Please, try to repeat with a newer version, 1.1.18, now available at http://dev.mysql.com/downloads/query-browser/1.1.html. Inform about the results.

It Works!

Thsi is what I did:

cd mysql-query-browser-1.1.18/mysql-gui-common
./configure
 make
make install
cd ../mysql-query-browser
./configure --with-gtkhtml=libgtkhtml-3.8 
make
make install

And this on Open SuSE 10.0 x86_64. Thank you very much for your help!

Steve

Closed as problem solved in version 1.1.18.