2 Apr
2026
2 Apr
'26
5:54 a.m.
On Apr 2, 2026, at 3:53 AM, David Lake via Freeradius-Users <freeradius-users@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.