Random error with check_mssql

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
gixxx11
Posts: 16
Joined: Mon Apr 17, 2017 8:54 am

Random error with check_mssql

Post by gixxx11 »

On occasion I get the following error when runing a mssql check:

ERROR: In range threshold START:END, START must be less than or equal to END

But 90% of the time I get the expect output of a 1 or 0. I'm not sure where to even begin on fixing this.

Code: Select all

/usr/local/nagios/libexec/check_mssql -H 192.168.#.# -d dbname -U user -P 'password' -w 1 -c 1 -p 1433 -r "0" -q "exec dbo.usp_AutoEmailMonitor"
User avatar
jdunitz
Posts: 235
Joined: Wed Feb 05, 2020 2:50 pm

Re: Random error with check_mssql

Post by jdunitz »

This appears to have been a bug in an older version of check_mssql.

Someone else had a similar problem a few years ago:
https://support.nagios.com/forum/viewto ... =6&t=36336


Check the version you're running, in case you somehow ended up with an old one.

If yours is current, and you're still having this problem, let us know and we'll go from there.

Thanks!
--Jeffrey
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
Locked