<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Mary,<br>
Is the correct subnet being selected (150136)?<br>
</p>
<p>Please share the complete Kea logging for this client.<br>
</p>
<p>Kind Regard Peter<br>
</p>
<div class="moz-cite-prefix">On 02/07/2024 05.58, Bull, Mary wrote:<br>
</div>
<blockquote type="cite"
cite="mid:BL0PR05MB502546F6FD14DA36C481BB18C0DC2@BL0PR05MB5025.namprd05.prod.outlook.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator"
content="Microsoft Word 15 (filtered medium)">
<style>@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;}p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Aptos",sans-serif;
mso-ligatures:standardcontextual;}span.EmailStyle17
{mso-style-type:personal-compose;
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.s1
{mso-style-name:s1;
color:#CA3323;}span.s2
{mso-style-name:s2;}.MsoChpDefault
{mso-style-type:export-only;
font-size:11.0pt;}div.WordSection1
{page:WordSection1;}</style>
<div class="WordSection1">
<p class="MsoNormal">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.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Log: <o:p></o:p></p>
<p class="p1"><span class="s1"><b>HOSTS_CFG_GET_ALL_IDENTIFIER</b></span><span
class="s2"> get all hosts with reservations using
identifier: hwaddr=9c934ea07417</span><o:p></o:p></p>
<p class="p1"><span class="s1"><b>HOSTS_CFG_GET_ALL_IDENTIFIER</b></span><span
class="s2">_COUNT using identifier hwaddr=9c934ea07417,
found 0 host(s)</span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">However, I can search and find this same
host in the hosts table in the database:
<o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size:8.5pt;font-family:Menlo;color:black;mso-ligatures:none">MariaDB
[kea]> select * from hosts where dhcp_identifier LIKE
'9c934ea07417';<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:8.5pt;font-family:Menlo;color:black;mso-ligatures:none">+---------+-----------------+----------------------+-----------------+-----------------+--------------+----------+----------------------+----------------------+-------------------+-----------------------+----------------------+--------------+----------+<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:8.5pt;font-family:Menlo;color:black;mso-ligatures:none">|
host_id | dhcp_identifier | dhcp_identifier_type |
dhcp4_subnet_id | ipv4_address |
<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:8.5pt;font-family:Menlo;color:black;mso-ligatures:none">+---------+-----------------+----------------------+-----------------+-----------------+--------------+----------+----------------------+----------------------+-------------------+-----------------------+----------------------+--------------+----------+<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:8.5pt;font-family:Menlo;color:black;mso-ligatures:none">|
34177 | 9c934ea07417 | 0 | 150136
177637420 <o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I have the host database configured. There
are no dynamic addresses given out for this subnet, only
reserved addresses identified in hosts table.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">"hosts-database": {<o:p></o:p></p>
<p class="MsoNormal"> "type": "mysql",<o:p></o:p></p>
<p class="MsoNormal"> "name": "kea",<o:p></o:p></p>
<p class="MsoNormal"> "user": "kea",<o:p></o:p></p>
<p class="MsoNormal"> "host": "",<o:p></o:p></p>
<p class="MsoNormal">}<o:p></o:p></p>
<p class="MsoNormal">"host-reservation-identifiers":
["hw-address"],<o:p></o:p></p>
<p class="MsoNormal"> "reservations-global": false,<o:p></o:p></p>
<p class="MsoNormal"> "reservations-in-subnet": true,<o:p></o:p></p>
<p class="MsoNormal"> "reservations-out-of-pool": true,<o:p></o:p></p>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
</blockquote>
<pre class="moz-signature" cols="72">--
Peter Davies
Support Engineer
Internet Systems Corporation
</pre>
</body>
</html>