MySQL Bugs: #51404: Workbench shows incorrect server status when SSH is NOT configured

Bug #51404	Workbench shows incorrect server status when SSH is NOT configured
Submitted:	22 Feb 2010 21:20	Modified:	23 Feb 2010 17:49
Reporter:	Tony Leding	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	5.2.18	OS:	MacOS
Assigned to:		CPU Architecture:	Any
Tags:	admin, mac, osx, server, workbench

Description:
When SSH is not configured for a remote server admin connection, the server status is incorrectly shows ans "Not running" when the server is indeed running.

when the same connection is modified to use SSH, then the status is displayed correctly.

How to repeat:
1) Connect via CLI to the server
2) Perform "ps -C mysqld -o pid=" to verify that a PID is returned indicating that the server is running
3) Configure a Workbench "Server Administration" instance WITHOUT SSH
2) Connect to the server via Workbench 
3) Note the server status in the first pane - this should show "Stopped"
6) Disconnect from the server
7) Reconfigure the server instance to utilize SSH for server admin
8) Reconnect to the server and note the server status in the first pane - it should now say "Running"

Suggested fix:
Change Workbench so that it can properly determine and display the server status regardless of SSH configuration.

Many thanks for writing a bug report.

Unfortunately, without ssh the "ps" command is not able to work.

This is not a bug.

Hmmm - that's not true - the ps command does not require SSH to be executed.  I have done this literally thousands of times on boxes that only have telnet enabled and no SSH.

I only gave the ps command example as a means of testing to make sure the server was down but I had no idea it is the actual mechanism used by WB to check the server state.  I had assumed, possibly wrongly so, that WB would use the same mechanism to check server state remotely as it does locally which does not require SSH.

Can you please clarify how WB checks server state when connected remotely?  If it currently does use SSH, can this not be changed?

Thanks.