[Nagios-users] Discrpancy b/w NDOUtils DB and Nagios

2007-11-11 Thread Yana Millis
Hello, i'm trying to make some sense out of the data in NDOUtils
hostchecks table...Basically, I just want to test which hosts have
ever been down at any time.
There is large number of hosts whose host status, according
to Nagios' web interface, has been in critical DOWN condition
for quite some time. However, when I run the query on NDOUtils
tables, only a very small subset of these hosts show up.
(I.e. nagios shows that host X,Y,Z and W are down, but when I
run the query on DNOUtils hostchecks data table, only Y and Z
show up as having ever been down, which is *weird*).

I've ensured that Nagios performs the checks every two minutes,
that both nagios and ndoUtils have been running long enough,
and that the Ndo2db is only trimmed once a week (so trimming
could not be the cause of the missing records...)

The query that I'm running is as follows:
SELECT  o.name1, o.object_id, h.host_object_id
FROM nagios.nagios_objects o INNER JOIN
 nagios.nagios_hostchecks h
ON o.object_id=h.host_object_id
WHERE  o.objecttype_id=1 AND h.state=1 AND
is_raw_check=0;

So can anybody suggest a reason why the hosts which are down
(and critical) in Nagios' web interface are not recorded as such in
NDOUtils' database ??

thanks alot for any suggestions : 0)

--yana

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now  http://get.splunk.com/
___
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting 
any issue. 
::: Messages without supporting info will risk being sent to /dev/null


[Nagios-users] check_snmp_storage fails on 2003 box, works manually

2007-11-11 Thread chris serafin
I'm having an issue with getting some SNMP commands to work.

When issuing the check_snmp_storage.pl manually, I get perfect results,
but once I put it in Nagios 3.0b5, I get critical alerts: (Return code
of 127 is out of bounds - plugin may be missing)

This is the manual command I enter and the result:

$ sudo ./check_snmp_storage.pl -H 192.168.1.200 -C pUBLIC -m C -w 80 -c 95

C:\ Label:  Serial Number d0d8a583: 66%used(9055MB/13774MB) (80%) : OK

This is how I defined the command and service:
define command{
command_namecheck_snmp_storage_windrive
command_line$USER1$/check_snmp_storage -H $HOSTADDRESS$ -C
$ARG1$ -m $ARG2$  -w $ARG3$ -c $ARG4$
}


define service{
use generic-service
host_name   Bunker01_Win2003-01
service_description Check Drive C Memory
check_command
check_snmp_storage_windrive!pUBLIC!^C!90!100!
}


The host is running Ubuntu 7.x and Nagios 3.0b5

Chris Serafin
Security Engineer
[EMAIL PROTECTED]

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now  http://get.splunk.com/
___
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting 
any issue. 
::: Messages without supporting info will risk being sent to /dev/null


Re: [Nagios-users] check_snmp_storage fails on 2003 box, works manually

2007-11-11 Thread Hugo van der Kooij
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

chris serafin wrote:
 I'm having an issue with getting some SNMP commands to work.
 
 When issuing the check_snmp_storage.pl manually, I get perfect results,
 but once I put it in Nagios 3.0b5, I get critical alerts: (Return code
 of 127 is out of bounds - plugin may be missing)
 
 This is the manual command I enter and the result:
 
 $ sudo ./check_snmp_storage.pl -H 192.168.1.200 -C pUBLIC -m C -w 80 -c 95

Great for root. But what about the account that Nagios is running as?
Did you test it too? And where did you put check_snmp_storage.pl exactly?
./ is a rather relative distinction. But I think it does not matter 

 This is how I defined the command and service:
 define command{
 command_namecheck_snmp_storage_windrive
 command_line$USER1$/check_snmp_storage -H $HOSTADDRESS$ -C
 $ARG1$ -m $ARG2$  -w $ARG3$ -c $ARG4$

Hold on. Why are you afraid to come out and tell nagios it is a perl script?
$USER1$/check_snmp_storage  !!=  ./check_snmp_storage.pl

For those unaware of pseudo code: !!= stands for 'is most definitly
NOT'. Pretty much as !~= stands for 'almost but not quite unlike`;-)

Hugo.

- --
[EMAIL PROTECTED]   http://hugo.vanderkooij.org/
PGP/GPG? Use: http://hugo.vanderkooij.org/0x58F19981.asc

A: Yes.
Q: Are you sure?
A: Because it reverses the logical flow of conversation.
Q: Why is top posting frowned upon?

Bored? Click on http://spamornot.org/ and rate those images.

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.7 (GNU/Linux)

iD8DBQFHN/mgBvzDRVjxmYERAmt3AKCD35Rz1k7aT3POzEvQPYUNEQXo4ACfUa0H
Mg/Qj9Pt1/o0/6T4xxwwxZg=
=GD0Z
-END PGP SIGNATURE-

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now  http://get.splunk.com/
___
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting 
any issue. 
::: Messages without supporting info will risk being sent to /dev/null