How to: freeRADIUS with PostgreSQL Backend!
I have setup a working freeRADIUS server & now want to add PostgreSQL as backend for storage of data. I have read the freeRADIUS documentation and researched the internet on this subject. 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 E. Mail wrote:
I have setup a working freeRADIUS server & now want to add PostgreSQL as backend for storage of data. I have read the freeRADIUS documentation and researched the internet on this subject.
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?
Read sql.conf, and follow the comments in it. Un-comment the various references to "sql" in sites-available/default, and sites-available/inner-tunnel. Add the tables, etc. to postgresql. That's really about it. Alan DeKok.
Hi,
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 tag 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 accounting..one that does authorisation, one that does NAS clients etc etc - ie it scales!) alan
participants (3)
-
A.L.M.Buxey@lboro.ac.uk -
Alan DeKok -
Just E. Mail