check_mssql broken following Nagios Upgrade

[nelsonw]

Please note, I upgraded to the latest version of Nagios XI (5.5.7) , but the version of check_mssql provided in this version does not work. I get the following error

PHP Notice: Undefined variable: column_name in /usr/local/nagios/libexec/check_mssql on line 511
PHP Notice: Undefined variable: query_result in /usr/local/nagios/libexec/check_mssql on line 511
PHP Notice: Undefined variable: query_result in /usr/local/nagios/libexec/check_mssql on line 516
PHP Notice: Undefined variable: query_result in /usr/local/nagios/libexec/check_mssql on line 532

I have reverted to the previous working version of check_mssql. This has caused a lot of issues for us, as we rely heavily on Nagios to monitor our business critical applications

Please advise what other files in the libexec directory have changed, as I need to do due diligence that none of our other monitoring checks are broken.

Please also provide a working version of check_mssql

[cdienger]

What version of XI was installed prior to the upgrade? Are those errors found in logs or are they preventing the plugin from running? Notice messages for the most part can be ignored and disabled(see the last post of https://support.nagios.com/forum/viewto ... it=+notice for steps).

You can get the version number of the check_mssql plugin by running:

/usr/local/nagios/libexec/check_mssql -V

This plugin is just a php script and doesn't require compiling so you can simply copy this version to a new machine if needed.