[Kea-users] Reservation lookup fails

[Peter Davies]

Hi Mary,
    Is the correct subnet being selected (150136)?

Please share the complete Kea logging for this client.

Kind Regard Peter

On 02/07/2024 05.58, Bull, Mary wrote:
>
> 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,
>
>
-- 
Peter Davies
Support Engineer
Internet Systems Corporation
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20240702/c1fd13dc/attachment.htm>