Check_mysql_health is constantly on Warning State

Troubleshooting
1

Hello Everyone.

I’ve encountered an ongoing issue with our DB checks where the check_mysql_health consistently displays a “WARN” state. Upon attempting to execute the check manually on the server, located at /opt/omd/sites/prod/local/lib/nagios/plugins, I received the following response:

./check_mysql_health --hostname XX.XXX.XX.XX --username xxxx --password xxxxx --database xxx --mode slave-lag

Response - HiRes.c: loadable library and perl binaries are mismatched (got handshake key 0xde00080, needed 0xcd00080)

Could someone shed some light on what this error signifies and perhaps provide guidance on resolving this issue?

Your assistance would be greatly appreciated.

Thank you.

Regards,
HSC

2

This looks like a version mismatch between the Perl module used for the build of the check and the now available one.
Can you please rebuild the check_mysql_health plugin from the source?
Such a problem can happen if you upgraded your OS after build of the plugin.

3

Thank you very Andreas for getting back on this, really appreciate it. That’s correct, there’s been an OS update recently. Would you happen to know where can I download or rebuild the check_mysql_health plugin?

Thank you very much.

4

The source and how-to install can be found here.
https://labs.consol.de/de/nagios/check_mysql_health/index.html
Keep in mind that the paths are different inside CMK than in this description.

5

Thank you Andreas, will have a look at the link

6

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed. Contact an admin if you think this should be re-opened.