MySQL Bugs: #51332: Workbench reports "Checked server status: Server is stopped." when it is running

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

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.

I have exactly same problem on Windows Server 2008 x64.
And I use basic connection mode (no SSH).

I also have the same issue with server 2008 32 bit running opensshd.

Hi

Having the same problem.

Running MySQL 5.0.45, WB 5.2.17, Windows Vista x86.

Please, check with a newer version, 5.2.19, and inform about the results.

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)

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.

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.

Still having the same problem.

MySQL 5.0.45
WB 5.2.21 R5918
Win Vista x86

same problem in WB 5.2.31 revision 7115

the old MySQL Administrator 1.2.17 works fine, will use that instead for now