MySQL Bugs: #32230: Query Browser hangs in OpenSuse 10.3 when specifying a default schema

Bug #32230	Query Browser hangs in OpenSuse 10.3 when specifying a default schema
Submitted:	9 Nov 2007 13:26	Modified:	18 Nov 2007 13:39
Reporter:	Joe Simone	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S1 (Critical)
Version:	5.0r12-56	OS:	Linux
Assigned to:		CPU Architecture:	Any
Tags:	opensuse 10.3 hang

Description:
The following is on a fresh install of OpenSuse 10.3 Linux box with KDE. All connections are as localhost as root from the server itself (no remote connecting)

I installed the server, admin GUI and query browser GUI all from Yast software management app as installable RPMs.

The server works fine, the admin GUI works fine, however when I start the query browser from Start Menu -> System -> Service Configuration -> MySQL Query Browser
the application hangs after trying to connect to localhost as root at 3306.

After about a minute of trying to connect to localhost the dialog box disappears and a quick inspection of the processes running reveals 2 zombie  mysql-query-bro processes (ps -e | grep my).

Query browser works fine under windows connecting to this server remotely.

One final comment, when I start the admin GUI client app (same version) after the above happens, it takes about 2 minutes to connect.  It does connect and works fine as localhost.  Subsequent attemtps at connection using the admin GUI client are instantaneous.  Don't know why the first attempt took so long.

A quick peek at the MySQL server log reveal nothing exceptional (no errors).

How to repeat:
see above

Thank you for the bug report. I tested on Suse 10.2 64-bit and with the package
mysql-gui-tools-5.0r12-linux-x86_64.tar.gz which I downloaded from the page:
http://dev.mysql.com/downloads/gui-tools/5.0.html. Could you please try to test
using a package from our download page?. Thanks in advance.

Miguel,
Thanks for your prompt reply.

I am suspecting this is a linux permission problem AND the query browser is not correctly reporting and displaying the error.

I have another OpenSuse 10.3 install on another machine and this problem is not evident.  If I login as jsimone, which is a member of mysql group then the browser comes up fine.  

I will verify on the problem machine whether or not the browser hangs if I connect from the root desktop.

If the browser would be so kind as to tell me what the error condition is, then I can remedy the situation, however the browser GUI just goes away!

Thank you for the feedback. How you commented could be a permission issue
and please if you are able to resolve that issue, comment here how you
did to resolve it. Thanks in advance.

Ok, I did this:

open a konsole window

su root
 pw
cd /var/lib/mysql
chown mysql -R .
chgrp mysql -R .
chmod 777 -R mysql

Now, while still logged in as root issue:
mysql-query-browswer
   server hostname: localhost
   username: root
   password:  pw
   default schema:  mysql
... nothing!

CTRL-C to kill the app

Now, while still logged in as root issue:
mysql-query-browswer
   server hostname: localhost
   username: root
   password:  pw
   default schema: 

UI pops up instantly.

So, this does not appear to be a permissions problem.  The problem happens when I specify a default schema and try to connect.

Now, if I log in as regular user (member of mysql group) and try this it works every time when the schema is NOT specified.  Fails every time when the schema is specified.

Hope this helps.
Joe

I was having the exact same problem. After reading this bug report I started query-browser from a terminal window as root and it was working fine. All previous attempts was as a local user. It was hanging up when defining a default schemata and if one was not defined it would hang up or freeze after selecting one. All attempts to run query-browser as root on OpenSuSE 10.3 have resulted the same as my attempts as a local user; since that initial gleam of hope after reading this bug report.

Thank you for the feedback. I still I am not able to repeat on Suse 10.2 using
default schema how you have mentioned, it is possible to you to test with our
package Generic x86 Linux TAR (bundled dependencies)?. Thanks in advance.

Unfortunately, the box that this happens on is a production box and I don't want to disturb the installed software on it.

The workaround for now is I won't specify a default schema!

By the way, you can do the 10.3 install over the net or from an ISO image available from the openSUSE site.

Thanks!

Thank you for the feedback. Indeed I installed Suse 10.3 64-bit and it hangs
however this behavior was already reported: http://bugs.mysql.com/bug.php?id=32037

A workaround is to run mysql-query-browser as root, remove your normal user's ~/.mysqlgui directory, copy /root/.mysqlgui to your user's ~/ directory, and chown $USER:users .mysqlgui -R