check_mk_active_sql! Return code of 127 is out of bounds – plugin may be missing

Running OMD 1.10 with Check_MK trying to monitor MSSQL on a Windows Server.

To configure a check I went to WATO – Host & Service Parameters -> Active Checks -> Check SQL Database

Add a new check and configure the appropriate config (Type, name, user, pass, sql-statement) and enable Performance Data.

However this was throwing the error ‘Return code of 127 is out of bounds – plugin may be missing’.

This fix for this was to copy /opt/omd/versions/default/share/doc/check_mk/treasures/active_checks/check_sql to /opt/omd/sites/YOURSITE/lib/nagios/plugins

Then add the execute permission to it (chmod +x check_sql).

 

Total Views: (4283)

5 thoughts on “check_mk_active_sql! Return code of 127 is out of bounds – plugin may be missing”

  1. The good news: This fixes the plugin may be missing error.

    The bad news: The plugin still doesn’t seem to work out of the box. The web interface just returns a warning with null in terms of response or feedback. Running a trace on the SQL Server, you can see its not even executing the query.

    1. Replying to my own question, for other that follow that advice.

      On OMD 1.20, do not copy from /opt/omd/sites/YOURSITE/share/check_mk/checks/check_sql This contain the check_mk script, not the nagios script.

      I found the correct script to copy at /opt/omd/versions/default/share/doc/check_mk/treasures/active_checks/check_sql.

      The destination folder was correct.

Leave a Reply

Your email address will not be published. Required fields are marked *

Connect with Facebook

*