MySQL Bugs: #43125: error message launching mysql-monitor

Bug #43125	error message launching mysql-monitor
Submitted:	24 Feb 0:16	Modified:	1 May 11:52
Reporter:	Pozzi Jean-Paul
Status:	Verified
Category:	Monitoring: Agent	Severity:	S3 (Non-critical)
Version:	2.0.4.7141	OS:	Linux
Assigned to:	Jan Kneschke	Target Version:
Tags:	monitor agent ssl
Triage:	Needs Triage: R2 (Low) / E2 (Low)

Description:
Hello,

When launching the agent I get the message :
Starting MySQL Enterprise agent service...ssh-keygen:
/opt/mysql/enterprise/agent/lib/mysql-proxy/libcrypto.so.0.9.8: no version information
available (required by ssh-keygen)

Occurs on Suse 64 bits and Debian 32 bits.

Regards

JP Pozzi

PS:
./mysql-monitor-agent --version
mysql-proxy 0.7.0
  glib2: 2.16.3
  libevent: 1.4.6-stable
  proxy: 0.7.0
  monitor: 0.7.0
  MySQL Monitor Agent(agent): 2.0.4.7141
  admin: 0.7.0

How to repeat:

Launch monitor agent

We use that to provide a more unique host ID. If it's not available we fall back to the
mac address of the box.

Can you clarify: is it logging but working anyway? Or is it shutting down?

All is working, only the message is disturbing.
I do not try SSH connection.

AS my evaluation time has only 4 days left I don't know if
I will enough time to test all functions.

Regards

JP Pozzi

We call "ssh-keygen" to extract the host-id from the ssh-host-key.

As we also set LD_LIBRARY_PATH to point to our own libraries (incl. a bundled
libopenssl.so) this leads to a mismatch of our binaries being linked against th bundled
openssl and ssh-keygen linked against the system-provided libopenssl.

As a workaround run the ssh-keygen command by hand:

  $ ssh-keygen -l -f /etc/ssh/ssh_host_key.pub  | awk  '{print $2}'
  82:01:1d:38:42:77:69:58:5b:11:4c:f9:48:68:93:31
  $ echo 'agent-host-id = 82:01:1d:38:42:77:69:58:5b:11:4c:f9:48:68:93:31' >>
mysql-monitor-agent.ini

Jan Kneschke writes: 
Proposal: before we call ssh-keygen unset the LD_LIBRARY_PATH internally.