<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" 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=Windows-1252">
<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: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;}
@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="#467886" vlink="#96607D" style="word-wrap:break-word">
<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>
</body>
</html>