DHCPv6 - MySQL Reservations
Hi I’m setting up FreeRadius v4 and so far, all working very nicely with a MariaDB Galera datastore. 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. Thanks David David Lake Visiting Professor 5G Innovation Centre (5GIC and 6GIC) Tel: +44 (0)7711 736784 Email: d.lake@surrey.ac.uk<mailto:%20d.lake@surrey.ac.uk> Web: surrey.ac.uk<http://www.surrey.ac.uk/?utm_medium=internal&utm_source=emailsignature&utm_campaign=reputation+50th+brand> [A blue text on a black background Description automatically generated]<http://www.surrey.ac.uk/?utm_source=emailsignature&utm_medium=internal&utm_campaign=emailsignature_1819&utm_content=emailsignature_homepage> James Clerk Maxwell Building, University of Surrey, Guildford, Surrey, GU2 7XH, UK
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.
PERFECT! Thank you. David On 02/04/2026, 10:54, "Alan DeKok" <alan.dekok@inkbridge.io> wrote: On Apr 2, 2026, at 3:53 AM, David Lake via Freeradius-Users <freeradius-users@lists.freeradius.org<mailto: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.
participants (2)
-
Alan DeKok -
David Lake