[Kea-users] Kea 1.1.0, MySQL and client-id

[Marcin Siodelski]

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 <marcin at isc.org
> <mailto:marcin at isc.org>> 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
> 
>