MySQL Bugs: #51405: Workbench unable to open SSH tunnel to server in VirtualBox guest.

Bug #51405	Workbench unable to open SSH tunnel to server in VirtualBox guest.
Submitted:	22 Feb 2010 21:48	Modified:	10 Sep 2010 8:51
Reporter:	Scott Wright	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.2.16 Community	OS:	MacOS (10.6.2)
Assigned to:		CPU Architecture:	Any

Description:
MySQL 5.1 is running on OpenSolaris 2009.06 in a VirtualBox guest VM on a Mac OS X 10.6 host.  (Using Bridged Networking.)  (All running on a Macbook Pro.)

Using the Mac terminal, I can open an SSH session and connect to MySQL on the guest machine.  "SQL Developer" appears to work properly; I can connect, create, and query databases.

If I attempt to connect through Server Administration, I get the following error:

Error Connecting to Server (student@opensolaris.local)
Could not establish SSH connection: Incompatible ssh server (no acceptable ciphers).

If I "cancel" before entering the solaris users password, then Workbench opens the Admin panel, but with limited functionality (no Startup, or Configuration abilities.)

How to repeat:
MySQL connection:
host: opensolaris.local
port: 3306
username: root  (MySQL user)

SSH connection:
host: opensolaris.local
port 22
username: student  (opensolaris account)

both hosts are opensolaris.local.

Why do you need ssh here?

Please try localhost connection first and let us know if you have same error with it.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I'm sorry for being unclear.  Workbench gives me this message when I log into my server without SSH:

"SSH based Remote Administration is disabled.
To use this functionality, the server where MySQL is located must have a SSH server running
and you must enable remote administration in the server profile, providing login details for it."

This message is displayed under both the Startup and Configuration screens of the Server Admin tab.  If I enable remote administration in the server profile and provide login details, I get the message that the SSH connection failed because of no compatible ciphers.

Yes, I can connect successfully to the mysql server for database tasks, and "some" of the admin tasks, but I can't start or stop the server or examine it's configuration from within Workbench without logging in via SSH.

It's possible there's something wrong with the default SSH server settings in OpenSolaris 06/2009, but as far as I can tell, it's running properly.

To confirm:  I can access the shell on my OpenSolaris machine (inside a VirtualBox container,) via commandline ssh.

ssh student@opensolaris.local

SSH running in Mac Terminal can access the server's shell, but MySQL Workbench is unable to make the same connection for mysql admin purposes.

Hello Scott,

first of all we published Workbench 5.2.26 a few days ago.

I would plead you to test with this version again.

At the moment Workbench only support OpenSSH ...
I am not sure if the default SSH on OpenSolaris is OpenSSH.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".