DHCPv6 - MySQL Reservations

[David Lake]

PERFECT!

Thank you.

David

On 02/04/2026, 10:54, "Alan DeKok" <alan.dekok at inkbridge.io> wrote:

On Apr 2, 2026, at 3:53 AM, David Lake via Freeradius-Users <freeradius-users at lists.freeradius.org<mailto:freeradius-users at lists.freeradius.org>> wrote:
> I’m setting up FreeRadius v4 and so far, all working very nicely with a MariaDB Galera datastore.

  That's good.

> I’d like to fix reservations in IPv6 to statically-assigned v6 prefixes in the same database.
>
> How do I do that please?  I can’t find anything in the documentation on v6 lease allocation other than to exclude link-local.

  See raddb/mods-config/sql/ippool/mysql/schema.sql

...
status ENUM('dynamic', 'static', 'declined', 'disabled') DEFAULT 'dynamic',
...

  You just list the IP / MAC in the table, and mark it as "static".  The IP Pool code will do the rest.

  Alan DeKok.