ndo1.4b1 DB structure issue

[Sébastien Barbereau]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/developers/attachments/20070116/fcd53dfe/attachment.html>
-------------- next part --------------
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
-------------- next part --------------
_______________________________________________
Nagios-devel mailing list
Nagios-devel at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-devel