Bug #61321 WB 5.2.34 freezes in Windows Server 2003
Submitted: 27 May 2011 11:20 Modified: 14 Jun 2011 16:42
Reporter: Jesse Castleberry Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.34 OS:Windows (Server 2003)
Assigned to: CPU Architecture:Any

[27 May 2011 11:20] Jesse Castleberry
Description:
When I run WB 5.2.34 in Windows Server 2003, It will freeze at one point. 
When I double-click on a connection under SQL Development it asks me for a 
password.  After I enter the password and press Enter, it starts to bring up 
the query part, but just freezes.  I have to "end task" to get out.

I can log into the server administrator part without a problem.

I am using SSH to connect to the database server.  Which brings me to a 
possible bug.  Before, the query connection was set to "Standard TCP/IP", so 
thinking this needed to be changed to SSH, I changed it to "Standard TCP/IP 
over SSH".  I changed the host name from 127.0.0.1:22 to the IP of my 
server:22. When I click Test, the test fails, stating, "can't connect to 
MySQL Server on 127.0.0.1", but I've changed both the SSH and MySQL hosts to 
the IP address of the server.

One other thing to throw in here.  I don't know if this makes a difference, but I am connecting to the WS03 Server through Remote Desktop.  I do not have physical access to the server.

It is also very flakey.  Sometimes after I play with it for a while, the 
query part will come up, but I'm never able to duplicate the same set of circumstances.

How to repeat:
Through Remote Desktop, bring up WB on a WS03 server connected to a database server over SSH, and double-click on a connection.

Suggested fix:
Make it bring up the SQL Developer instead of freezing.
[27 May 2011 11:54] Valeriy Kravchuk
Please, send the output of Help > System Info menu item.
[27 May 2011 12:20] Jesse Castleberry
MySQL Workbench CE for Windows version 5.2.34

Configuration Directory: C:\Documents and Settings\Administrator\Application Data\MySQL\Workbench

Data Directory: C:\Program Files\MySQL\MySQL Workbench 5.2 CE

Cairo Version: 1.8.8

Rendering Mode: OpenGL is not available on this system, so GDI is used for rendering.

OS: Microsoft Windows Server 2003, Web Edition Service Pack 2 (build 3790)

CPU: 4x Intel(R) Xeon(R) CPU           E5502  @ 1.87GHz, 2.0 GiB RAM

Active video adapter: Matrox G200eW (Nuvoton) - English

Installed video RAM: 8 MB

Current video mode: 800 x 600 x 65536 colors

Used bit depth: 16

Driver version: 6.12.01.1000

Installed display drivers: G200eWd.dll

Current user language: English (United States)

-- Don't know if it'll make much difference, but the "Current video mode" is wrong.  It's actually in 1280x1024 (Medium 16 bit) mode.
[9 Jun 2011 14:37] Armando Lopez Valencia
Hello Jesse.
Can you try with this configuration:
SSH Hostname: yourHostNameAddress
MySQL Hostname: localhost

Please make sure that the user that is trying to connect to the remote MySQL server have privileges to connect to external hosts (you can use '%' on the "Local connectivity to host matching option" on your MySQL server)
[9 Jun 2011 15:15] Jesse Castleberry
That worked.  In fact, I haven't been having any freeze up problems at all since I left this message, but the whole "connect over ssh" thing stumped me.  But, w/ localhost in the MySQL Host field seems to work.
[14 Jun 2011 16:42] Armando Lopez Valencia
I'm glad that it worked.
Please feel free to report any other finding.
Thanks.