Bug #51332 Workbench reports "Checked server status: Server is stopped." when it is running
Submitted: 19 Feb 2010 16:28 Modified: 14 May 2010 0:07
Reporter: Greg Thomas Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S2 (Serious)
Version:5.2.20 Revision 5783 OS:Windows
Assigned to: CPU Architecture:Any

[19 Feb 2010 16:28] Greg Thomas
Description:
I'm running WB on a WinXP machine, and have MySQL Server 5.1 running on Windows 2003 (32bit). I have the Cygwin based OpenSSH server on Windows 2003, and am using the "SSH login based administration" option. SSH is working between the two.

When I attempt to administer the server, WB reports "Checked server status: Server is stopped."

The status bar reports no problems.

This is not the name of the MySQL Windows service, sc start/stop/query mysql all work just fine when logged in manually over ssh. 

If you examine the "output" in the status bar, it contains the following:

Unable to determine codepage from remote shell: x64 on x64Unable to fetch ProgramFiles value in remote Windows machine: Unable to fetch ProgramFiles(x86) value in remote Windows machine: Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_configuration.py", line 204, in tab_changed
    panel.page_activated()
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_config_file_ui.py", line 68, in page_activated
    self.create_ui()
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_config_file_ui.py", line 218, in create_ui
    self.load_options_from_cfg()
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_config_file_ui.py", line 617, in load_options_from_cfg
    self.cfg_be.parse_file(self.file_name_ctrl.get_string_value())
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_config_file_be.py", line 271, in parse_file
    self.file_name = self.read_mysql_cfg_file(file_name)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_config_file_be.py", line 188, in read_mysql_cfg_file
    local_file_name = self.ctrl_be.fetch_file(file_name)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_control_be.py", line 753, in fetch_file
    self.ssh.get("'" + fname + "'", name)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_control_be.py", line 410, in get
    ret = self.ssh.get(source, dest)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_ssh.py", line 218, in get
    sftp = self.client.open_sftp()
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/python/site-packages\paramiko\client.py", line 389, in open_sftp
    return self._transport.open_sftp_client()
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/python/site-packages\paramiko\transport.py", line 827, in open_sftp_client
    return SFTPClient.from_transport(self)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/python/site-packages\paramiko\sftp_client.py", line 106, in from_transport
    return cls(chan)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/python/site-packages\paramiko\sftp_client.py", line 89, in __init__
    raise SSHException('EOF during negotiation')
paramiko.SSHException: EOF during negotiation
Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_configuration.py", line 204, in tab_changed
    panel.page_activated()
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_config_file_ui.py", line 68, in page_activated
    self.create_ui()
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_config_file_ui.py", line 218, in create_ui
    self.load_options_from_cfg()
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_config_file_ui.py", line 617, in load_options_from_cfg
    self.cfg_be.parse_file(self.file_name_ctrl.get_string_value())
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_config_file_be.py", line 271, in parse_file
    self.file_name = self.read_mysql_cfg_file(file_name)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_config_file_be.py", line 188, in read_mysql_cfg_file
    local_file_name = self.ctrl_be.fetch_file(file_name)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_control_be.py", line 753, in fetch_file
    self.ssh.get("'" + fname + "'", name)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_control_be.py", line 410, in get
    ret = self.ssh.get(source, dest)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_ssh.py", line 218, in get
    sftp = self.client.open_sftp()
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/python/site-packages\paramiko\client.py", line 389, in open_sftp
    return self._transport.open_sftp_client()
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/python/site-packages\paramiko\transport.py", line 827, in open_sftp_client
    return SFTPClient.from_transport(self)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/python/site-packages\paramiko\sftp_client.py", line 106, in from_transport
    return cls(chan)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/python/site-packages\paramiko\sftp_client.py", line 89, in __init__
    raise SSHException('EOF during negotiation')
paramiko.SSHException: EOF during negotiation
Unable to determine codepage from remote shell: x64 on x64Unable to fetch ProgramFiles value in remote Windows machine: Unable to fetch ProgramFiles(x86) value in remote Windows machine: Unable to determine codepage from remote shell: x64 on x64Unable to fetch ProgramFiles value in remote Windows machine: Unable to fetch ProgramFiles(x86) value in remote Windows machine: 

How to repeat:
1. Create a Server Administration to a Windows 2003 server running MySQL and Cygwin OpenSSH server.
2. Attempt to connect to it.

Suggested fix:
a) At the very least, if WB is unable to determine the server status, it should report "unknown" rather than "stopped"

b) WB should be able to determine the status in this configuration.
[23 Feb 2010 17:15] Marc Chevrier
I have exactly same problem on Windows Server 2008 x64.
And I use basic connection mode (no SSH).
[27 Feb 2010 17:40] Glenn Kiddle
I also have the same issue with server 2008 32 bit running opensshd.
[5 Apr 2010 14:36] Irshad Valimamod
Hi

Having the same problem.

Running MySQL 5.0.45, WB 5.2.17, Windows Vista x86.
[25 Apr 2010 15:37] Valeriy Kravchuk
Please, check with a newer version, 5.2.19, and inform about the results.
[26 Apr 2010 12:08] Greg Thomas
I've checked with 5.2.19 Revision 5680, and the underlying behaviour is the same; Workbench reports Status: Stopped when the server is running.

The long stack trace has now gone, and instead the output window just contains the following ...

x64 on x64Unable to fetch ProgramFiles value in remote Windows machine: Unable to fetch ProgramFiles(x86) value in remote Windows machine: Checked server status: Server is stopped.

The server is configured correctly in the System Profile as:

Windows (MySQL 5.1 x86 Installer Package)
[28 Apr 2010 11:26] Greg Thomas
And in case you're wondering, 5.2.20 behaves exactly the same as 5.2.19 ...

x64 on x64Unable to fetch ProgramFiles value in local Windows machine: Unable to fetch ProgramFiles(x86) value in local Windows machine: Checked server status: Server is stopped.
[14 May 2010 0:07] Alfredo Kojima
If long stack trace is gone, then the originally reported bug is fixed.
There is now a 2nd problem which seems identical to the reported in bug #50585 which results in the same problem as before.
[31 May 2010 14:06] Irshad Valimamod
Still having the same problem.

MySQL 5.0.45
WB 5.2.21 R5918
Win Vista x86
[15 Feb 2011 20:23] Darius Florczyk
same problem in WB 5.2.31 revision 7115
[15 Feb 2011 20:25] Darius Florczyk
the old MySQL Administrator 1.2.17 works fine, will use that instead for now