On Fri, 27 May 2011 18:26:12 +0200 Matej Gregr igregr@fit.vutbr.cz wrote:
Hello, I noticed, that NAV does not close arp entries after monitored node become unavailable. For example: There is an active mac address 11:22:33:44:55:66 with end_time set to infinity. When the monitored node goes down, the mac address remains in active state, so you can find it using machinetracker as a still active address, which apparently is not true.
I suggest, that there should be another rule in database, enssuring that arp entries will be closed.
Something like:
CREATE OR REPLACE RULE netbox_status_close_arp AS ON UPDATE TO netbox WHERE NEW.up='n' DO UPDATE arp SET end_time=NOW() WHERE netboxid=OLD.netboxid AND end_time='infinity';
A very astute observation :-) ipdevpoll will not update any data related to a node while the node is down (though the ancient Perl-implementation of the arplogger probably did).
Your rule appears to be just the thing we need here - I've nicked it into NAV and attributed it to you :-)
https://bugs.launchpad.net/nav/+bug/790600