<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Aptos;
panose-1:2 11 0 4 2 2 2 2 2 4;}
@font-face
{font-family:Menlo;
panose-1:2 11 6 9 3 8 4 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:12.0pt;
font-family:"Aptos",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Aptos",sans-serif;
color:windowtext;}
p.p1, li.p1, div.p1
{mso-style-name:p1;
margin:0in;
font-size:8.5pt;
font-family:Menlo;
color:black;}
span.s2
{mso-style-name:s2;
color:#CA3323;}
span.s1
{mso-style-name:s1;}
span.apple-converted-space
{mso-style-name:apple-converted-space;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt">I’m using Kea version 2-4. <o:p>
</o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt">Kea is not identifying the host reservation present in the database with correct hw address and subnet id.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt">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?
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt">I believe the </span><span class="s1"><span style="font-size:10.0pt">HOSTS_MGR_ALTERNATE_GET4_SUBNET_ID_IDENTIFIER is the message about looking in the database?
</span></span><span style="font-size:10.0pt"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Log messages: <o:p></o:p></span></p>
<p class="p1"><span class="s1">Jul</span><span class="apple-converted-space"> </span>
<span class="s1">8 22:54:49 is-kea-03: DHCP4_SUBNET_DATA [hwtype=1 9c934e</span><span class="s2"><b>7adf7a</b></span><span class="s1">], cid=[019c934e7adf:7a], tid=0x6a9e: the selected subnet details: 10.150.136.0/24</span><o:p></o:p></p>
<p class="p1"><span class="s1">Jul</span><span class="apple-converted-space"> </span>
<span class="s1">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=9c934e</span><span class="s2"><b>7adf7a</b></span><o:p></o:p></p>
<p class="p1"><span class="s1">Jul</span><span class="apple-converted-space"> </span>
<span class="s1">8 22:54:49 is-kea-03: HOSTS_CFG_GET_ALL_IDENTIFIER get all hosts with reservations using identifier: hwaddr=9c934e</span><span class="s2"><b>7adf7a</b></span><o:p></o:p></p>
<p class="p1"><span class="s1">Jul</span><span class="apple-converted-space"> </span>
<span class="s1">8 22:54:49 is-kea-03: HOSTS_CFG_GET_ALL_IDENTIFIER_COUNT using identifier hwaddr=MariaDB
</span><o:p></o:p></p>
<p class="p1"><span class="s1">, found 0 host(s)</span><o:p></o:p></p>
<p class="p1"><span class="s1">Jul</span><span class="apple-converted-space"> </span>
<span class="s1">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=9c934e</span><span class="s2"><b>7adf7a<o:p></o:p></b></span></p>
<p class="p1"><o:p> </o:p></p>
<p class="p1"><span class="s1"><b>Jul</b></span><span class="apple-converted-space"><b>
</b></span><span class="s1"><b>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=9c934e</b></span><span class="s2"><b>7adf7a</b></span><b><o:p></o:p></b></p>
<p class="p1"><span class="s1"><b>Jul</b></span><span class="apple-converted-space"><b>
</b></span><span class="s1"><b>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=9c934e</b></span><span class="s2"><b>7adf7a</b></span><b><o:p></o:p></b></p>
<p class="p1"><span class="s1"><b>Jul</b></span><span class="apple-converted-space"><b>
</b></span><span class="s1"><b>8 22:54</b></span><b><o:p></o:p></b></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Database entry: <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="p1"><span class="s1">[kea]> select dhcp_identifier, dhcp4_subnet_id, ipv4_address from hosts where dhcp_identifier like '9c934e7adf7a';</span><o:p></o:p></p>
<p class="p1"><span class="s1">+-----------------+-----------------+--------------+</span><o:p></o:p></p>
<p class="p1"><span class="s1">| dhcp_identifier | dhcp4_subnet_id | ipv4_address |</span><o:p></o:p></p>
<p class="p1"><span class="s1">+-----------------+-----------------+--------------+</span><o:p></o:p></p>
<p class="p1"><span class="s1">| 9c934e7adf7a</span><span class="apple-converted-space">
</span><span class="s1">|</span><span class="apple-converted-space"> </span>
<span class="s1">150136 |</span><span class="apple-converted-space"> </span><span class="s1">177637408 |</span><o:p></o:p></p>
<p class="p1"><span class="s1">+-----------------+-----------------+--------------+</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<div id="mail-editor-reference-message-container">
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="margin-bottom:12.0pt"><b><span style="color:black">From:
</span></b><span style="color:black">Kea-users <kea-users-bounces@lists.isc.org> on behalf of kea-users-request@lists.isc.org <kea-users-request@lists.isc.org><br>
<b>Date: </b>Saturday, July 6, 2024 at 8:00</span><span style="font-family:"Arial",sans-serif;color:black"> </span><span style="color:black">AM<br>
<b>To: </b>kea-users@lists.isc.org <kea-users@lists.isc.org><br>
<b>Subject: </b>Kea-users Digest, Vol 121, Issue 11<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt">Send Kea-users mailing list submissions to<br>
kea-users@lists.isc.org<br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="https://lists.isc.org/mailman/listinfo/kea-users">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</a><br>
or, via email, send a message with subject or body 'help' to<br>
kea-users-request@lists.isc.org<br>
<br>
You can reach the person managing the list at<br>
kea-users-owner@lists.isc.org<br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of Kea-users digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Re: kea-dhcp6 an stateful/static GUA and ULA<br>
(Django [Bastard Operator from Hell])<br>
2. Re: kea-dhcp6 an stateful/static GUA and ULA<br>
(Django [Bastard Operator from Hell])<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Fri, 5 Jul 2024 16:36:04 +0200<br>
From: "Django [Bastard Operator from Hell]" <django@nausch.org><br>
To: kea-users@lists.isc.org<br>
Subject: Re: [Kea-users] kea-dhcp6 an stateful/static GUA and ULA<br>
Message-ID: <919f9d94-b6a4-41ba-b91c-2d86cdf38d88@nausch.org><br>
Content-Type: text/plain; charset=UTF-8; format=flowed<br>
<br>
HI, here I'm again .... ;)<br>
<br>
OK. The blogpost here ?<br>
<a href="https://blog.ipspace.net/2022/05/ipv6-ula-made-useless.html">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</a><br>
? is already two years old, but I would say that the author is not that <br>
wrong and the article almost summarises the topic well.<br>
<br>
So just use GUA and everything will be fine ;)<br>
<br>
<br>
ttyl<br>
Django<br>
<br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Fri, 5 Jul 2024 17:15:09 +0200<br>
From: "Django [Bastard Operator from Hell]" <django@nausch.org><br>
To: kea-users@lists.isc.org<br>
Subject: Re: [Kea-users] kea-dhcp6 an stateful/static GUA and ULA<br>
Message-ID: <80406576-ec95-40fd-91a9-9990d7d03875@nausch.org><br>
Content-Type: text/plain; charset=UTF-8; format=flowed<br>
<br>
.... last but not least:<br>
<br>
<br>
Oh yes, I forgot to mention one more thing: I have been allocated a <br>
fixed IPv6 GUA address block /56 by my ISP. So I don't have to work with <br>
static ULAs, as the GUA of the hosts changes accordingly with a new IPv6 <br>
prefix! My GUA always remain the same IPv6 Global Unified Addresses! :)<br>
<br>
<br>
If, on the other hand, you have been assigned a new IPv6 prefix by the <br>
ISP every day or when reconnecting, you will then use static ULAs for <br>
static communication relationships and generate the GUA via SLAAC.<br>
<br>
<br>
ttyl<br>
Django<br>
<br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<br>
<br>
ISC funds the development of this software with paid support subscriptions. Contact us at
<a href="https://www.isc.org/contact/">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</a>
for more information.<br>
<br>
Kea-users mailing list<br>
Kea-users@lists.isc.org<br>
<a href="https://lists.isc.org/mailman/listinfo/kea-users">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</a><br>
<br>
<br>
------------------------------<br>
<br>
End of Kea-users Digest, Vol 121, Issue 11<br>
******************************************<o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</body>
</html>