Nagios Support Forum

Did you fix the permissions of query.sql to get it working? Does your password contain any special characters? This may be halting Nagios. If so, try putting your password in double quotes "" to see if that works. i do fix it.. and it´s working just fine. i was using 0 when OK and 1 when ...

root@idleh-VBox:/home/idleh# ls -l /nagios-scripts/query.sql -rwxr-xr-x 1 root root 429 Dec 30 18:38 /nagios-scripts/query.sql now i get it working just fine. i am trying to add as a service on a host.. but i dont know how to add --hostame --username and etc etc to the check_command string. define s...

its seems that the query is executing .. because of the execution time. without query string. idleh@idleh-VBox:/tmp$ sudo /usr/local/nagios/libexec/check_mssql -H x.x.x.x --port xxxx--username sa --password mypass OK: Connect time=0.148633 seconds.|query_duration=0.148633s;; without --result idleh@i...

What happens if you use the "-s" flag in your check (instead of "-q")? For example: /usr/local/nagios/libexec/check_mssql -H x.x.x.x --username <username> --password "<password>" --database <database> --instance <instance> -s /path/to/your/file.sql it returns this. -s ...

The plugin for you query for some reason isn't returning any data. Can you post the query you are running so we can review it? Can you check the log file on the MSSQL server for any errors and post them here? i have no errors.. this is what i have in mysql.sql file Declare @date1 datetime Declare @...

Run the command again but remove the -r 'ok' from the command. The -r option you have defined expects ok in the output but the data that is returned from your query doesn't have it so that is why you are receiving a Critical message. Let us know how it works for you. Ok, im not having the critical ...

Run the command again but remove the -r 'ok' from the command. The -r option you have defined expects ok in the output but the data that is returned from your query doesn't have it so that is why you are receiving a Critical message. Let us know how it works for you. Ok, im not having the critical ...

YES!! it works!! thank you so much! now i am trying to get the result from a query like check_mssql -H myhost -p myport -U userdb -P passworddb -d database -sp sp_mysptest -r 'ok' this returns also that i have to use query to get a result.... UNKNOWN: The -r switch requires the -q switch. Please spe...

the first time i have installed this plug in, i got it working.. then i updated from another version founded in this forum.. and came out this problem. Also, where is the one you updated from? i´ve download it from here https://exchange.nagios.org/directory/Plugins/Databases/SQLServer/check_mssql/d...

Hi there, this is my first post in this forum, i am having this problem " ./check_mssql PHP Parse error: syntax error, unexpected ')' in /usr/local/nagios/libexec/check_mssql on line 83 " i trying to get working the check_mssql plugin. download from here " https://exchange.nagios.org/...