MySQL Bugs: #71652: Detect duplicate ssh host keys

Bug #71652	Detect duplicate ssh host keys
Submitted:	10 Feb 2014 10:29	Modified:	24 Feb 2014 12:10
Reporter:	Daniël van Eeden (OCA)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Enterprise Monitor	Severity:	S3 (Non-critical)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
I've got a setup with 3 machines: 1 with mem, 2 with agents each monitoring 1 local instance.

In the top right corner the sumary is: 1 hosts, 3 instances.

I expect this to be 3 hosts, 3 instances.

How to repeat:
The agents were installed with the 'Host Only' option. Then the local instances were added with to be monitored via a UNIX socket.

Hi Daniel,

Do the hosts happen to have the same SSH keys defined on them? Because this is used as the host identity, these have to be unique across hosts for us (otherwise it tends to manifest as you describe above).

Mark

Hi Mark,

You've guessed correctly: the SSH fingerprints in /etc/ssh/ssh_host_key.pub are the same.

It's hard to find this one as ssh seems to use /etc/ssh/ssh_host_rsa_key.pub. The host key used by MEM seems to be the SSHv1 key and the other one is the SSHv2 key. (on RHEL6).

I believe this bug report should be changed to: detect and alert on duplicate ssh fingerprings.

And "ssh-keygen -l -f /etc/ssh/ssh_host_key.pub" should be somewhere in the troubleshooting section of the documentation.

Changed the title from "Wrong server count in summary" to "Detect duplicate ssh host keys"

Verifying.