Bug #2985: DHCP LeaseStatus prop persisted to DB - NethServer 6 - NethServer.org

Bug #2985

« Previous | Next »

DHCP LeaseStatus prop persisted to DB

Added by Davide Principi over 6 years ago. Updated over 6 years ago.

Status:

CLOSED

Start date:

Priority:

Normal

Due date:

Assignee:

% Done:

100%

Category:

nethserver-dnsmasq

Target version:

v6.5

Security class:

Resolution:

Affected version:

v6.5-final

NEEDINFO:

Description

Hosts DB entries have a LeaseStatus prop set that must not be there, as it must be calculated each time from dnsmasq cache entries, to keep the view consistent.

Steps to reproduce:

create a reservation and save
edit, changing the Description field, then save again

The LeaseStatus prop has been persisted to DB.

Associated revisions

Revision 57b06086
Added by Davide Principi over 6 years ago

Claim db/hosts RPM ownership. Refs #2985

Revision 4659ebc0
Added by Davide Principi over 6 years ago

Remove LeaseStatus prop in hosts DB. Refs #2985

Requires nethserver-hosts > 1.1.0-1.ns6

History

#1 Updated by Davide Principi over 6 years ago

Subject changed from : LeaseStatus prop to DHCP expired leases always visible

Some entries under DHCP > IP reservation page never disappear.

Hosts DB entries have a LeaseStatus prop set that should not be there.

#2 Updated by Davide Principi over 6 years ago

Description updated (diff)

#3 Updated by Davide Principi over 6 years ago

NEEDINFO changed from No to Yes

Add reproducibility infos

#4 Updated by Giacomo Sanchietti over 6 years ago

Migration fragment to remove LeaseStatus property:

{
    use esmith::HostsDB;
    my $db = esmith::HostsDB->open();
    foreach ($db->get_all_by_prop( type => 'local' )) {
        my $l = $_->prop('LeaseStatus') || next;
        $_->delete_prop('LeaseStatus');
    }
}

#5 Updated by Davide Principi over 6 years ago

Subject changed from DHCP expired leases always visible to DHCP LeaseStatus prop persisted to DB
Description updated (diff)
Status changed from NEW to TRIAGED
% Done changed from 0 to 20
NEEDINFO changed from Yes to No