Bug #53286 wrong server status and confusing error message

• Submitted: 29 Apr 2010 11:45
• Modified: 30 Apr 2010 7:40
• Reporter: Susanne Ebrecht
• Status: Closed
• Category: MySQL Workbench: Administration
• Severity: S2 (Serious)
• Version: 5.2.20
• OS: Any
• CPU Architecture: Any
• Tags: regression

[29 Apr 2010 11:45] Susanne Ebrecht

Description:
1. Make sure that the server is not running
2. Start Workbench
3. Administrator -> double click the server instance

You will get the following error message:

Cannot Connect to MySQL
Lost connection to MySQL server at 
'reading initial communication packet',
system error: 111
Connection parameters might be incorrect or the
server might be down.
Some functionality will not be available.

4. Click OK
5. look into Administrator:

2010-04-29 13:42:56 - Checked server status: Server is running.
2010-04-29 13:42:57 - Server is running

Take shell and look if server is running:

$ ps ax | grep mysql
10204 pts/0    S      0:00 /bin/bash ./bin/mysql-workbench
10208 pts/0    S      0:00 /bin/sh /usr/bin/catchsegv ./bin/mysql-workbench-bin
10210 pts/0    SLl    0:09 ./bin/mysql-workbench-bin
11093 pts/0    S      0:00 /bin/bash ./bin/mysql-workbench
11097 pts/0    S      0:00 /bin/sh /usr/bin/catchsegv ./bin/mysql-workbench-bin
11099 pts/0    SLl    0:06 ./bin/mysql-workbench-bin
12002 pts/0    S+     0:00 grep mysql

No server is running.

How to repeat:
See above

[29 Apr 2010 16:05] Alfredo Kojima

Hi

Please provide the entry for the instance you tested from ~/.mysql/workbench/server_instances.xml

[30 Apr 2010 7:40] Susanne Ebrecht

Sorry Alfredo. Seems I forgot to close this.

It was a configuration mistake I made.