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

Jeffery Harrell sparky at charlietango.com
Tue Jan 3 17:57:43 UTC 2017


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> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20170103/a068d43e/attachment.htm>


More information about the Kea-users mailing list