How to: freeRADIUS with PostgreSQL Backend!

A.L.M.Buxey at A.L.M.Buxey at
Fri May 22 10:13:28 CEST 2009


> What I am looking for is any kind of Step-by-Step document detailing  
> sequential steps needed to setup a PostgreSQL back end for freeRADIUS.  
> Has someone written such a document? Is there such a writeup available?

just to reiterate Alans comments - the config file is self documenting.

read sql.conf  see that it asks what type of SQL you want to use. config
each section of sql.conf

no go to the subdirectory of your chosen DB solution and edit the files
in there.

by default, the default server (and sites-enabled/* stuff) will always
be working with 'sql' - in authorisation, authentication, post-auth,
accounting etc etc (once you enable the line) - you can use multiple
SQL instances (eg different tables) by giving your chosen SQL a name

ie in sql.conf, instead of 

sql {

blah blah blah

you have

sql sql_engine1 {

blah blah blah


*now* instead of 'sql' in all the sections of tour server, you can have 'sql_engine1'

(thus, you can have multiples - one that does that does authorisation,
one that does NAS clients etc etc - ie it scales!)


More information about the Freeradius-Users mailing list