Re: DHCPv6 - MySQL Reservations

David Lake via Freeradius-Users <[email protected]> Thu, 2 Apr 2026 09:56:43 +0000

Newsgroups	gmane.comp.freeradius.user
Message-ID	<PAXPR06MB78872A9B07BC7FFB06C79F53B551A@PAXPR06MB7887.eurprd06.prod.outlook.com>

PERFECT!

Thank you.

David

On 02/04/2026, 10:54, "Alan DeKok" <[email protected]> wrote:

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