MySQL Bugs: #77562: Remote Management SSH-Connections won't work

Bug #77562	Remote Management SSH-Connections won't work
Submitted:	30 Jun 2015 10:28	Modified:	1 Jul 2015 13:57
Reporter:	Roland Steinbach	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	6.3.4	OS:	Windows (Windows 7 64-bit)
Assigned to:		CPU Architecture:	Any
Tags:	fingerprint, ssh, ssh server fingerprint

Description:
When making a ssh-connection to a host (e.g. by clicking Management->Server Status), an error for a missing "SSH Server fingerprint" is issued (see image below).

Further Problems like in Bug #77450

How to repeat:
Create a connection (in my case Standard TCP/IP for Database and SSH for remote administration) and try to access Server Status or Serrver Logs or sth. like that.

Error Message

Attachment: ssh-problem.png (image/png, text), 8.48 KiB.

Workbench is 64-bit

Thank you for the bug report. Duplicate of https://bugs.mysql.com/bug.php?id=77450.

I removed the known hosts file and restarted workbench.  Still have the same problem on mac.

Where exactly ist the known_hosts file located in Windows?

When trying to test a connection for Remote management after the popup with the missing fingerprint after clicing "Continue" there is another popup saying "ERROR SSH connection cancelled".

After a bit debugging/process monitoring it seems to be an oddity of paramiko not storing the known_hosts on windows. 

Solution:

Create the file
c:\users\<user>\appdata\roaming\mysql\workbench\ssh\config

(note that the directory ssh doesn't exist)

Add the following line (just this line will do):

StrictHostKeyChecking no

SSH connections work without hassle then. Should also work on OSX as a workaround, the file there is

~/.ssh/ssh_config or ~/.ssh/config (don't know exactly)

(maybe it exists, if not try above, if yes just add the line)

Note this is only a workaround, removes the symptoms but not the cause.

Roland,
   On OSX I went into the ~/Library/Application SUpport/MySQL/Workbench/ directory and there is not a .ssh directory there.  I confirmed this through the finder as well as in the terminal.

The only .ssh directory I seem to be able to find is the ~/.ssh directory, which I have removed the known_hosts file.  I did this earlier and it didn't change anything.  

Unsure where to look next.

Mike, try to create a file

~/.ssh/config with the line

StrictHostKeyChecking no

in it and retry. If that doesn't work, rename the file to ~/.ssh/ssh_config and also retry, one of these should help (at least I hope so).

The solution proposed by Roland Steinbach, worked perfectly for me after the creation of the folder and config file in windows.

The problem with this solution is that you are now vulnerable to spoofing for all of your ssh connections, I suggest make this a temporary change if you need to use it.

adding 
StrictHostKeyChecking no
to config helps me

Thanks a lot Roland Steinbach, that fix worked for me. Oh! Workbench works and feels great. Quite a treat.