<div dir="ltr">Hi, Marcin. Thanks for the reply. I did try inserting the missing row into our MySQL database. I also tried setting up an isolated test environment this morning using PostgreSQL 9.5 as the backend but client-id reservations weren't working for me there either, so it seems pretty obvious that I'm doing something wrong. MAC address-based reservations work like a charm, but if I try to get Kea to give me a lease based on a client id reservation in a subnet with a pool, it gives me an IP from the pool, and if I try to get one out of a subnet with no pool it just doesn't give a lease at all.<div><br></div><div>Like I said, it seems to me to be a configuration problem on my end. I'm going to try to go through things very systematically following the documentation carefully to see if I can find my error.</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Jan 3, 2017 at 1:05 AM, Marcin Siodelski <span dir="ltr"><<a href="mailto:marcin@isc.org" target="_blank">marcin@isc.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="HOEnZb"><div class="h5">On 03.01.2017 03:55, Jeffery Harrell wrote:<br>
> I hope this isn’t a frequently asked question or anything; I’ve searched<br>
> and searched. Is it a known issue that client-id-based host reservations<br>
> aren’t currently working using the MySQL backend? I ask because (A) I<br>
> can’t seem to get one to work in my environment, which may well be my<br>
> fault, but (B)<br>
> comparing /usr/share/kea/scripts/mysql/<wbr>dhcpdb_create.mysql<br>
> and /usr/share/kea/scripts/pgsql/<wbr>dhcpdb_create.pgsql I see that the<br>
> contents of host_identifier_type aren’t the same. The Postgres version has<br>
><br>
> INSERT INTO host_identifier_type VALUES (3, 'client-id’);<br>
><br>
> while the MySQL version stops at #2, circuit-id. This makes me wonder if<br>
> client-id host reservations aren’t supposed to be working with the MySQL<br>
> backend right now? I thought maybe I’d ask to see if there was a quick<br>
> answer that could save me more hours of fiddling around and trying to<br>
> read the source code.<br>
><br>
> Again, apologies if I’m treading on old ground. Thanks!<br>
><br>
><br>
<br>
</div></div>Hello Jeffery,<br>
<br>
It seems to be a bug in our MySQL database creation scripts. The<br>
host_identifier_type table should include 'client-id' entry. Other than<br>
that, the 'client-id' based reservations should work for MySQL.<br>
<br>
Did you try yo insert the dhcp_identifier_type of 3 into the hosts table<br>
for your reservation?<br>
<span class="HOEnZb"><font color="#888888"><br>
Marcin<br>
<br>
</font></span></blockquote></div><br></div>