Bug #52864 Workbench 5.1.17 cannot connect to mysql after "yum update"
Submitted: 15 Apr 2010 17:14 Modified: 26 May 2010 20:08
Reporter: Viet Pham Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S1 (Critical)
Version:5.1.17 OS:Linux (2.6.30.10-105.2.23.fc11.i586)
Assigned to: CPU Architecture:Any
Tags: workbench

[15 Apr 2010 17:14] Viet Pham
Description:
workbench stops being able to connect to mysql after "yum update"

How to repeat:

workbench was installed using the following commands. Reverse, forward, and sync functions worked perfectly.
- wget http://rpms.famillecollet.com/remi-release-11.rpm
- rpm -Uvh remi-release-11.rpm
- yum --enablerepo=remi install mysql-workbench

Yesterday, I updated the system (yum update). I can still model ER. However, reverse, forward, and sync functions sit there forever when I am at the step to connect to db. "Show Log" button does not show any error.

Here is more info:
- "mysqladmin version" output:
mysqladmin  Ver 8.42 Distrib 5.1.40, for pc-linux-gnu on i686
Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version		5.1.40-log
Protocol version	10
Connection		Localhost via UNIX socket
UNIX socket		/tmp/mysql.sock
Uptime:			25 min 47 sec

- MySQL Query Browser, which is on the same machine with workbench, can connect to mysql fine using the same account. I can query and get records back.

- system info:
/usr/local/src/workbench >> uname -a
Linux saigon 2.6.30.10-105.2.23.fc11.i586 #1 SMP Thu Feb 11 06:51:26 UTC 2010 i686 i686 i386 GNU/Linux

- SELinux is disabled.

- workbench and mysql are on the same machine.

- I searched bug db and can't find any solutions to this.
[15 Apr 2010 17:49] Viet Pham
I uninstalled 5.1.17 version and install 5.1.18 version, which solves the issue. 5.1.18 can be downloaded here: http://dev.mysql.com/downloads/mirror.php?id=377212
[15 Apr 2010 18:02] Valeriy Kravchuk
So, this is not repeatable with fresh 5.1.18.
[15 Apr 2010 18:05] Viet Pham
Yes, it's not repeatable in 5.1.18.
[26 May 2010 20:08] Viet Pham
Hi,

I selected the connection I wanted, clicked the "Next" button. It's supposed to connect to the database so that I can forward engineer or synchronize model, and it did. However, it just sat there forever after couple of times of successfully connecting to the db. When I closed the freezed window, workbench application closed too. This happens for Forward Engineer and Synchronize Model features in both 5.17.17 and 5.17.18 versions. Is this a known issue? I can't find it any where. I currently have about 70 tables on my model?