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: [email protected]
Website: http://www.nagios.org
This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]