[Nagios-devel] ndo1.4b1 DB structure issue

Ethan Galstad nagios at nagios.org
Thu Jan 18 22:12:55 UTC 2007


Good catch!  I'll get CVS updated shortly.  Thanks.

Sébastien Barbereau wrote:
> Hi,
> as I've been playing with the new 1.4b1 of the ndo databroker I noticed 
> that the nagios_service_contacts and nagios_host_contacts are not 
> properly "updated".
> 
> When ndo2db is updating the nagios_host_contacts table he does :
> INSERT INTO nagios_host_contacts SET instance_id='1', host_id='3', 
> contact_object_id='34' ON DUPLICATE KEY UPDATE instance_id='1', 
> host_id='3', contact_object_id='34';
> and then
> INSERT INTO nagios_host_contacts SET instance_id='1', host_id='3', 
> contact_object_id='41' ON DUPLICATE KEY UPDATE instance_id='1', 
> host_id='3', contact_object_id='41';
> 
> But the table structure states that only instance_id is a unique key 
> therefore nagios_host_contacts contains only the latest entry and not 
> any other host to contact information ...
> 
> So you need to change the nagios_host_contacts and 
> nagios_service_contacts tables by adding them as unique keys.
> 
> Sorry if this was already report ...
> 
> Seb.
> 


Ethan Galstad,
Nagios Developer
---
Email: nagios at nagios.org
Website: http://www.nagios.org




More information about the Nagios-devel mailing list