Mapping between sqlippool and radius attributes

Thore Krüss thore at
Fri Apr 13 18:05:38 CEST 2018

On Fri, Apr 13, 2018 at 09:18:12AM -0400, Alan DeKok wrote:
> On Apr 13, 2018, at 8:02 AM, Thore Krüss <thore at> wrote:
> > after reading the configuration files, the wiki entry as well as trying to dig
> > in the code I haven't been able to figure out how the columns from the sqlippool
> > module are mapped back to radius attributes.
>   See raddb/mods-config/sql/ippool/
>   The files there contain all of the queries necessary for IP pool allocation.
>   Also, read raddb/mods-available/sqlippool
>   That file contains documentation about how it works, and it includes the files which do the actual queries.
> > The default table scheme creates a column "framedipaddress" which appears to
> > become the "Framed-IP-Address" attribute through magic.
>   As always, run the server in debug mode.  Read the output.  See what it does.
>   i.e. configure the sqlippool module as per the docs and examples, then send it packets and read the debug output.  It should then be clear what's going on and how.
> > Is there a way to extend this with a "Framed-IPv6-Prefix"? 
> > Is adding a column with that name sufficient?
>   No.  Read raddb/mods-available/sqlippool.  This is documented.

Thank you for your quick reply,
looking at this:
made it a whole lot clearer than the config provided with debian (stretch).

Thank you for the hint in that direction.

Best regards

More information about the Freeradius-Users mailing list