Opened 4 years ago

Closed 3 years ago

#4213 closed enhancement (complete)

Storing class information in Hosts in MySQL

Reported by: tomek Owned by: tmark
Priority: medium Milestone: Kea1.1
Component: host-reservations Version: git
Keywords: Cc:
CVSS Scoring: Parent Tickets:
Sensitive: no Defect Severity: N/A
Sub-Project: DHCP Feature Depending on Ticket:
Estimated Difficulty: 0 Add Hours to Ticket: 0
Total Hours: 0 Internal?: no

Description (last modified by tomek)

Ticket #3682 introduced MySQL host data source implementation that stores hosts information in MySQL. It covers majority of the functionalities: add and several retrieve operations. Two things were skipped there:

  1. IPv6 address/prefix reservation (because IPv6 allows multiple addresses, this requires additional code to insert the host, retrieve its host_id and then insert necessary reservations. The same is true for retrieval. Additional query to get all IPv6 reservations for a given host_id are required.
  1. Classes information stored in MySQL. There are two fields: dhcp4_client_classes and dhcp6_client_classes. Those two fields are defined in the MySQL schema, but they are not used yet. They should be set when adding a new host and retrieved when getting the host info from a database.

This ticket covers functionality 2 described above. It's somewhat extended functionality, so it's not a direct follow-up for #3682.


Change History (6)

comment:1 Changed 4 years ago by tomek

  • Description modified (diff)

comment:2 Changed 4 years ago by tomek

  • Component changed from dhcpdb to host-reservations

comment:3 Changed 4 years ago by tomek

  • Milestone changed from Kea1.1 to Outstanding Tasks

We're back in shoving tickets off from the current milestone. We decided on 2016-06-02 call to move this ticket to Outstanding.

comment:4 Changed 4 years ago by tmark

  • Owner set to tmark
  • Status changed from new to assigned

comment:5 Changed 3 years ago by tmark

  • Milestone changed from Outstanding Tasks to Kea1.1

This ticket is being implemented as part of #4279.

comment:6 Changed 3 years ago by tmark

  • Resolution set to complete
  • Status changed from assigned to closed

#4279 has been completed. This ticket is closed.

Note: See TracTickets for help on using tickets.