ndo1.4b1 DB structure issue

[Ethan Galstad]

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

-------------------------------------------------------------------------
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
_______________________________________________
Nagios-devel mailing list
Nagios-devel at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-devel