Bug #53977 MEM agent ssh fingerprint detection fails on Ubuntu Linux
Submitted: 25 May 2010 16:51 Modified: 14 Jun 2010 14:52
Reporter: Daniël van Eeden Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Agent Severity:S3 (Non-critical)
Version:2.2.0.1705 OS:Linux (Ubuntu 9.04)
Assigned to: Michael Schuster CPU Architecture:Any

[25 May 2010 16:51] Daniël van Eeden
Description:
2010-05-25 18:40:15: (critical) MySQL Monitor Agent 2.2.0.1705 started.
2010-05-25 18:40:15: (critical) Running 'sh -c "ssh-keygen -l -f /etc/ssh/ssh_host_dsa_key.pub | awk '{print \"ssh:{\"$2\"}\"}'"' failed with the following message on stderr. Falling back to MAC address detection.
ssh-keygen: /opt/mysql/enterprise/monitor/lib/libcrypto.so.0.9.8: no version information available (required by ssh-keygen)

2010-05-25 18:40:15: (critical) network-io.c:312: successfully reconnected to dashboard at http://agent@mysqlmanager:18080/heartbeat
2010-05-25 18:40:15: (critical) agent_mysqld.c:696: successfully connected to database at /tmp/mysql.sock as user monitoragent (with password: YES)

# ldd `which ssh-keygen`
	linux-vdso.so.1 =>  (0x00007fff8a1ff000)
	libcrypto.so.0.9.8 => /lib/libcrypto.so.0.9.8 (0x00007f81d33bd000)
	libutil.so.1 => /lib/libutil.so.1 (0x00007f81d31ba000)
	libz.so.1 => /lib/libz.so.1 (0x00007f81d2fa2000)
	libnsl.so.1 => /lib/libnsl.so.1 (0x00007f81d2d88000)
	libcrypt.so.1 => /lib/libcrypt.so.1 (0x00007f81d2b50000)
	libresolv.so.2 => /lib/libresolv.so.2 (0x00007f81d2938000)
	libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2 (0x00007f81d270b000)
	libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0x00007f81d2470000)
	libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0x00007f81d224a000)
	libcom_err.so.2 => /lib/libcom_err.so.2 (0x00007f81d2046000)
	libc.so.6 => /lib/libc.so.6 (0x00007f81d1cd4000)
	libdl.so.2 => /lib/libdl.so.2 (0x00007f81d1ad0000)
	libkrb5support.so.0 => /usr/lib/libkrb5support.so.0 (0x00007f81d18c8000)
	libkeyutils.so.1 => /lib/libkeyutils.so.1 (0x00007f81d16c5000)
	libpthread.so.0 => /lib/libpthread.so.0 (0x00007f81d14a9000)
	/lib64/ld-linux-x86-64.so.2 (0x00007f81d3746000)

# find /opt/mysql/enterprise | grep libcrypto
/opt/mysql/enterprise/monitor/lib/libcrypto.so
/opt/mysql/enterprise/monitor/lib/libcrypto.so.0.9.8

How to repeat:
Start MEM agent on Ubuntu 9.04 and check the logs.

Suggested fix:
Use the correct libcrypto library.
[7 Jun 2010 23:40] Enterprise Tools JIRA Robot
Andy Bang writes: 
In build 2.2.2.1722.
[14 Jun 2010 14:52] MC Brown
Added note to changelog 2.2.2: 

       The ssh fingerprint used to identify agents would fail on Ubuntu Linux.