[Kea-users] Kea not finding host reservation in database

Tue Jul 9 03:01:55 UTC 2024

I’m using Kea version 2-4.

Kea is not identifying the host reservation present in the database with correct hw address and subnet id.
I set up the database by inserting the values directly into the database, not using the custom hooks. Is this an issue? Is there an issue with formatting?
I believe the HOSTS_MGR_ALTERNATE_GET4_SUBNET_ID_IDENTIFIER is the message about looking in the database?

Log messages:

Jul  8 22:54:49 is-kea-03: DHCP4_SUBNET_DATA [hwtype=1 9c934e7adf7a], cid=[019c934e7adf:7a], tid=0x6a9e: the selected subnet details: 10.150.136.0/24

Jul  8 22:54:49 is-kea-03: HOSTS_CFG_GET_ONE_SUBNET_ID_IDENTIFIER get one host with IPv4 reservation for subnet id 150136, identified by hwaddr=9c934e7adf7a

Jul  8 22:54:49 is-kea-03: HOSTS_CFG_GET_ALL_IDENTIFIER get all hosts with reservations using identifier: hwaddr=9c934e7adf7a

Jul  8 22:54:49 is-kea-03: HOSTS_CFG_GET_ALL_IDENTIFIER_COUNT using identifier hwaddr=MariaDB

, found 0 host(s)

Jul  8 22:54:49 is-kea-03: HOSTS_CFG_GET_ONE_SUBNET_ID_IDENTIFIER_NULL host not found using subnet id 150136 and identifier hwaddr=9c934e7adf7a

Jul  8 22:54:49 is-kea-03: HOSTS_MGR_ALTERNATE_GET4_SUBNET_ID_IDENTIFIER get one host with IPv4 reservation for subnet id 150136, identified by hwaddr=9c934e7adf7a

Jul  8 22:54:49 is-kea-03: HOSTS_MGR_ALTERNATE_GET4_SUBNET_ID_IDENTIFIER_NULL host not found using subnet id 150136 and identifier hwaddr=9c934e7adf7a

Jul  8 22:54

Database entry:

[kea]> select dhcp_identifier, dhcp4_subnet_id, ipv4_address from hosts where dhcp_identifier like '9c934e7adf7a';

+-----------------+-----------------+--------------+

| dhcp_identifier | dhcp4_subnet_id | ipv4_address |

+-----------------+-----------------+--------------+

| 9c934e7adf7a    |          150136 |    177637408 |

+-----------------+-----------------+--------------+

From: Kea-users <kea-users-bounces at lists.isc.org> on behalf of kea-users-request at lists.isc.org <kea-users-request at lists.isc.org>
Date: Saturday, July 6, 2024 at 8:00 AM
To: kea-users at lists.isc.org <kea-users at lists.isc.org>
Subject: Kea-users Digest, Vol 121, Issue 11
Send Kea-users mailing list submissions to
        kea-users at lists.isc.org

To subscribe or unsubscribe via the World Wide Web, visit
        https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.isc.org%2Fmailman%2Flistinfo%2Fkea-users&data=05%7C02%7Cmbull%40wm.edu%7C75a88486baba4f6d6fd108dc9db32ae4%7Cb93cbc3e661d40588693a897b924b8d7%7C0%7C0%7C638558640066066511%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=ju5aTOmQVDKqE8i9ruxaW%2FXnokUpKnNEcmaIBn8JFQ0%3D&reserved=0<https://lists.isc.org/mailman/listinfo/kea-users>
or, via email, send a message with subject or body 'help' to
        kea-users-request at lists.isc.org

You can reach the person managing the list at
        kea-users-owner at lists.isc.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Kea-users digest..."

Today's Topics:

   1. Re: kea-dhcp6 an stateful/static GUA and ULA
      (Django [Bastard Operator from Hell])
   2. Re: kea-dhcp6 an stateful/static GUA and ULA
      (Django [Bastard Operator from Hell])

----------------------------------------------------------------------

Message: 1
Date: Fri, 5 Jul 2024 16:36:04 +0200
From: "Django [Bastard Operator from Hell]" <django at nausch.org>
To: kea-users at lists.isc.org
Subject: Re: [Kea-users] kea-dhcp6 an stateful/static GUA and ULA
Message-ID: <919f9d94-b6a4-41ba-b91c-2d86cdf38d88 at nausch.org>
Content-Type: text/plain; charset=UTF-8; format=flowed

HI, here I'm again .... ;)

OK. The blogpost here ?
      https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fblog.ipspace.net%2F2022%2F05%2Fipv6-ula-made-useless.html&data=05%7C02%7Cmbull%40wm.edu%7C75a88486baba4f6d6fd108dc9db32ae4%7Cb93cbc3e661d40588693a897b924b8d7%7C0%7C0%7C638558640066074272%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=SF79feYPsBvCOOwkujtswNu0A7uyCnGdRdE8tMqYr8M%3D&reserved=0<https://blog.ipspace.net/2022/05/ipv6-ula-made-useless.html>
? is already two years old, but I would say that the author is not that
wrong and the article almost summarises the topic well.

So just use GUA and everything will be fine ;)

ttyl
Django

------------------------------

Message: 2
Date: Fri, 5 Jul 2024 17:15:09 +0200
From: "Django [Bastard Operator from Hell]" <django at nausch.org>
To: kea-users at lists.isc.org
Subject: Re: [Kea-users] kea-dhcp6 an stateful/static GUA and ULA
Message-ID: <80406576-ec95-40fd-91a9-9990d7d03875 at nausch.org>
Content-Type: text/plain; charset=UTF-8; format=flowed

.... last but not least:

Oh yes, I forgot to mention one more thing: I have been allocated a
fixed IPv6 GUA address block /56 by my ISP. So I don't have to work with
static ULAs, as the GUA of the hosts changes accordingly with a new IPv6
prefix! My GUA always remain the same IPv6 Global Unified Addresses! :)

If, on the other hand, you have been assigned a new IPv6 prefix by the
ISP every day or when reconnecting, you will then use static ULAs for
static communication relationships and generate the GUA via SLAAC.

ttyl
Django

------------------------------

Subject: Digest Footer

_______________________________________________

ISC funds the development of this software with paid support subscriptions. Contact us at https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.isc.org%2Fcontact%2F&data=05%7C02%7Cmbull%40wm.edu%7C75a88486baba4f6d6fd108dc9db32ae4%7Cb93cbc3e661d40588693a897b924b8d7%7C0%7C0%7C638558640066078925%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=pwqGWffS2orVQC3wulZBw0jFiUnJvU6NctWzHSIEf9s%3D&reserved=0<https://www.isc.org/contact/> for more information.

Kea-users mailing list
Kea-users at lists.isc.org
https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.isc.org%2Fmailman%2Flistinfo%2Fkea-users&data=05%7C02%7Cmbull%40wm.edu%7C75a88486baba4f6d6fd108dc9db32ae4%7Cb93cbc3e661d40588693a897b924b8d7%7C0%7C0%7C638558640066083482%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=YpVsCQ53eXmIAnB%2FRPsPyF63ygq%2BBnXodC1FcRA30Qg%3D&reserved=0<https://lists.isc.org/mailman/listinfo/kea-users>

------------------------------

End of Kea-users Digest, Vol 121, Issue 11
******************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20240709/cea193a8/attachment-0001.htm>