Re: DHCPv6 - MySQL Reservations

Alan DeKok via Freeradius-Users <[email protected]> Thu, 2 Apr 2026 05:54:22 -0400

Newsgroups	gmane.comp.freeradius.user
Message-ID	<[email protected]>

On Apr 2, 2026, at 3:53 AM, David Lake via Freeradius-Users <[email protected]> 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.

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

signature.asc (application/pgp-signature, 833 B)