Jeffery, I think I found the flaw in Kea which may result in behavior you're observing. Thankfully, I also have a good guess how to work around this problem.
Can you please try adding the following parameter to your DHCPv4 server configuration: "host-reservation-identifiers": [ "auto" ] ? Other values should also work: "host-reservation-identifiers": [ "circuit-id", "hw-address", "duid", "client-id" ], OR "host-reservation-identifiers": [ "client-id" ], Marcin On 03.01.2017 18:57, Jeffery Harrell wrote: > 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. > > 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. > > On Tue, Jan 3, 2017 at 1:05 AM, Marcin Siodelski <[email protected] > <mailto:[email protected]>> wrote: > > On 03.01.2017 03:55, Jeffery Harrell wrote: > > I hope this isn’t a frequently asked question or anything; I’ve > searched > > and searched. Is it a known issue that client-id-based host > reservations > > aren’t currently working using the MySQL backend? I ask because (A) I > > can’t seem to get one to work in my environment, which may well be my > > fault, but (B) > > comparing /usr/share/kea/scripts/mysql/dhcpdb_create.mysql > > and /usr/share/kea/scripts/pgsql/dhcpdb_create.pgsql I see that the > > contents of host_identifier_type aren’t the same. The Postgres > version has > > > > INSERT INTO host_identifier_type VALUES (3, 'client-id’); > > > > while the MySQL version stops at #2, circuit-id. This makes me > wonder if > > client-id host reservations aren’t supposed to be working with the > MySQL > > backend right now? I thought maybe I’d ask to see if there was a quick > > answer that could save me more hours of fiddling around and trying to > > read the source code. > > > > Again, apologies if I’m treading on old ground. Thanks! > > > > > > Hello Jeffery, > > It seems to be a bug in our MySQL database creation scripts. The > host_identifier_type table should include 'client-id' entry. Other than > that, the 'client-id' based reservations should work for MySQL. > > Did you try yo insert the dhcp_identifier_type of 3 into the hosts table > for your reservation? > > Marcin > > _______________________________________________ Kea-users mailing list [email protected] https://lists.isc.org/mailman/listinfo/kea-users
