Nagios Support Forum

So all along the plugin has been working as you are getting this line , but it is also outputting the notices.

what is this setting in the php.ini on the new server? We want this to be Off

Hi Scott,

If the plugin is working correctly, should it not return a "computed" number? See below from successful SQL script. I do not get this value with my unsuccessful SQL script. The unsuccessful SQL script, test_sql, should return "Critical" state as the count returned is 253

/usr/local/nagios/sql# /usr/local/nagios/libexec/check_mssql -H <HOST> --username <USERNAME> --password <PWD> --database <DATABASE> --port 1433 --query /usr/local/nagios/sql/successful_test_sql --result 0 --decode --warning 50 --critical 60 --querywarning 1 --querycritical 2 --result 0
CRITICAL: Query result 253 was higher than Query critical threshold 2.|query_duration=0.002628s;50;60 'computed'=253;1;2

Please see below from config file

grep display_errors /etc/php/7.2/cli/php.ini
; display_errors
display_errors = Off
; separately from display_errors. PHP's default behavior is to suppress those


Thanks,
Nelson

True, good point.

I started debugging this and get the same behavior on a CentOS system if I use However, If I just use the CASE statement it works as expected

Yes, if I remove the if/else statement and just have the case statement, it is working on my Ubuntu server.

I am wondering if there are packages missing on my Ubuntu and your CentOS environment that would support if/else statements


Thanks,
Nelson

I think I know what is going on but I don't have a solution at present.

I confirmed with @cdienger that this did work on his older CentOS system with the old plugin version 0.7.3 because CentOS6 & 7 with php 5.x still had support for the php mssql_connect functionality.

This was removed in newer versions of PHP and as such the plugin was re-written using the PHP extension pdo_dblib, however, for some reason, this doesn't like the if/else statements as it makes a prepared statement on the SQL server.

I am going to continue to look for a work around but wanted to touch base on the current findings.

Thanks for the update Scott.

Please let me know how the investigation in to a work-around is going


Thanks,
Nelson

nelsonw wrote:Thanks for the update Scott.

Please let me know how the investigation in to a work-around is going


Thanks,
Nelson

Unfortunately we have been unsuccessful using any form of IF statement in PDO, at present I do not see any workaround.

Would uninstalling php7 on my server and reverting back to php5 work?

nelsonw wrote:Would uninstalling php7 on my server and reverting back to php5 work?

Depending if 5 is supported on the OS it may work, but you would also need to revert the plugin to the one @cdienger posted here

https://support.nagios.com/forum/viewto ... 80#p291355

I would definitely do this in a test environment first and reverting PHP to 5 isn't going to be a straight forward thing on all OS's

Thanks Scott. I will hold off on reverting to version 5. Please let me know how you progress with a possible work-around or if there is any other alternative