where do I report an NDOUtils bug?

Andrey Dmitriev netcomrade at dmitriev.net
Mon May 23 17:29:44 CEST 2011


we upgraded from
1.4b7 to 1.4b9
nagios version was upgraded from 2.x to 3.2.3

There is no way to correlate contact notified to notifications anymore since
the first that used to track it is now inserted with '0' all the time
(confirmed via debug mode)

the specific field is CONTACT_OBJECT_ID in NAGIOS_NAGIOSNOTIFICATIONS table.
there doesn't seem to be any other way to join the data in order to find out
who was contacted.

before upgrade (supporting query below)
| cs-pnslij             | HTTP-alt                              | Primary
       |               439 |
| cs-pnslij             | jboss_ConnectionCount                 |
cwhite_email     |               463 |
| cs-pnslij             | jboss_ConnectionCount                 |
cs_cwhite_pager  |               459 |
| cs-pnslij             | jboss_ConnectionCount                 |
cs_clee_pager    |               458 |
| cs-pnslij             | jboss_ConnectionCount                 |
cs_clee_email    |               457 |
| cs-pnslij             | jboss_ConnectionCount                 |
ashburn_ops      |               447 |
+-----------------------+---------------------------------------+------------------+-------------------+


after upgrade:
| mt-ora2        | nrpe-system_load           | NULL         |
  0 |
| mt-ora2        | nrpe-system_load           | NULL         |
  0 |



query:
SELECT
obj1.name1 AS host_name
,obj1.name2 AS service_description
,obj2.name1 AS contact_name
,nagios_contactnotifications.contact_object_id
FROM `nagios_contactnotifications`
JOIN nagios_notifications ON
nagios_contactnotifications.notification_id=nagios_notifications.notification_id
LEFT JOIN nagios_objects as obj1 ON
nagios_notifications.object_id=obj1.object_id
LEFT JOIN nagios_objects as obj2 ON
nagios_contactnotifications.contact_object_id=obj2.object_id
LEFT JOIN nagios_instances ON
nagios_notifications.instance_id=nagios_instances.instance_id
WHERE
nagios_notifications. start_time >= DATE_SUB(CURDATE(), interval 48 hour)
ORDER BY nagios_notifications.start_time DESC
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20110523/20969c17/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
-------------- next part --------------
_______________________________________________
Nagios-users mailing list
Nagios-users at 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


More information about the Users mailing list