MSSQL Job Monitoring

[nscott]

Tailing the /usr/local/nagios/var/nagios.log can be helpful. If nagios tries to run the plugin but fails it should show up in the nagios.log. You may have to set the debug level to 29 in the nagios.cfg and then restart Nagios. Then tail -f /usr/local/nagios/var/nagios.log and look for the info on your plugin. That should yield some useful information.

[easy2kent]

The log file helped provide some information but I ran a debugging plugin to find out why it is coming up unknown:

[1316527142.213222] [016.1] [pid=29769] Handling check result for service 'SQL JOB TEST' on host 'Testing DB'...
[1316527142.213225] [016.0] [pid=29769] ** Handling check result for service 'SQL JOB TEST' on host 'Testing DB'...
[1316527142.213229] [016.1] [pid=29769] HOST: Testing DB, SERVICE: SQL JOB TEST, CHECK TYPE: Active, OPTIONS: 0, SCHEDULED: Yes, RESCHEDULE: Yes, EXITED OK: Yes, RETURN CODE: 3, OUTPUT: UNKNOWN:\n
[1316527142.213237] [016.2] [pid=29769] Parsing check output...
[1316527142.213241] [016.2] [pid=29769] Short Output: UNKNOWN:
[1316527142.213244] [016.2] [pid=29769] Long Output: NULL
[1316527142.213247] [016.2] [pid=29769] Perf Data: NULL

I ran it through a debugging plugin and it gave me something after the UNKNOWN. It says java.io.FileNotFoundException: /url.properties (No such file or directory)
I do not know where that file is supposed to be though. The owner says to put it in the /usr/local/nagios/libexec folder along with the other files which is where it is located right now

[easy2kent]

UPDATE: I put url.properties into the root dir and it worked!!!!!!

The link is still not working though but it is now critical and gives an <a href= but doesn't display as a link
I have escape_html_tags=0 but the link is just coming up as plain text still.

Thanks for all of the help everybody,
Kent

[nscott]

Cool kent! Glad you found the fix! That plain text HTML is part of XI, we're planning on adding it and some other features along with it in Nagios XI coming up but its still just a roadmap.

[mroter]

Hi,

I have the same problem.
I've tried it all including deleting the sqllog dir since it was created with root and nagios had no rigts to overwrite exsiting files.
Any Idea?
Thanks
Matty

[easy2kent]

Have you tried putting the url.properties file into the root folder /. I found that is where the script looks for the file so if it is not there it will not run and return UNKNOWN.

[scottwilkerson]

mroter,

In addition to what easy2kent suggested, could you describe what errors yo are getting so we can verify this is the same problem.