[Kea-users] Reservation lookup fails

[Bull, Mary]

I’ve set up host reservations with lookup specified by hw-address; however, the log is showing that devices are failing to find the reservation in the mysql backend.

Log:

HOSTS_CFG_GET_ALL_IDENTIFIER get all hosts with reservations using identifier: hwaddr=9c934ea07417

HOSTS_CFG_GET_ALL_IDENTIFIER_COUNT using identifier hwaddr=9c934ea07417, found 0 host(s)

However, I can search and find this same host in the hosts table in the database:
MariaDB [kea]> select * from hosts where dhcp_identifier LIKE '9c934ea07417';
+---------+-----------------+----------------------+-----------------+-----------------+--------------+----------+----------------------+----------------------+-------------------+-----------------------+----------------------+--------------+----------+
| host_id | dhcp_identifier | dhcp_identifier_type | dhcp4_subnet_id | ipv4_address |
+---------+-----------------+----------------------+-----------------+-----------------+--------------+----------+----------------------+----------------------+-------------------+-----------------------+----------------------+--------------+----------+
|   34177 | 9c934ea07417    |                    0 | 150136             177637420


I have the host database configured. There are no dynamic addresses given out for this subnet, only reserved addresses identified in hosts table.

"hosts-database": {
        "type": "mysql",
        "name": "kea",
        "user": "kea",
        "host": "",
}
"host-reservation-identifiers": ["hw-address"],
        "reservations-global": false,
        "reservations-in-subnet": true,
        "reservations-out-of-pool": true,
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20240702/4beaa737/attachment-0001.htm>