I am ready to test my first freeRADIUS server with PostgreSQK backend. He is my setup: freeRADIUS Server: -CentOS 5.3 -freeRADIUS V# 2.1.6 (RPM install) -PostgreSQL V# 8.3.7 (RPM install) - Client eth0: Connect to the Internet eth1: Connected to the backend server thru a hub Backend Server: -CentOS 5.3 -PostgreSQL V# 8.3.7 (RPM install) - Server eth0: Connects to freeRADIUSserver via a hub. Both servers talk. I have ================= First I configured the necessary files (without backend SQL) and tested the RADIUS server in debug mode: radtest testid testpw localhost 0 testing123 -and- NTRadPing Test was a SUCCESS!!! ================= Now I have configured so that freeRADIUS uses the backend for sql data/tables. I have created the radius database & radius role. I have created RADIUS tables from schema.sql text file. ================= Now I need HELP. I need to add a couple of USER/PW into the PostgreSQL tables to test. How do I do that? Is there a GUI to add UID/PW? Are UID/PW added manually? Where can read about it? (Please donotjust point to the manual. I have read them all. At least mention Chapter #) What else should I know?
I need to add a couple of USER/PW into the PostgreSQL tables to test.
How do I do that? Is there a GUI to add UID/PW? Are UID/PW added manually? Where can read about it?
http://wiki.freeradius.org/SQL_HOWTO#Populating_SQL You have dialup admin included with the server. daloRadius is a good external GUI. http://freeradius.org/dialupadmin.html http://www.daloradius.com/ Ivan Kalik Kalik Informatika ISP
Hi,
I need to add a couple of USER/PW into the PostgreSQL tables to test.
How do I do that?
however you like
Is there a GUI to add UID/PW?
theres a basic GUI supplied as part of freeradius source - dialup_admin there is also DaloRADIUS - the author of that tool is on this list.
Are UID/PW added manually?
if you really want to. you can use psql directly on the command line. we have a set of PERL CGI scripts which deal with creating and removing accounts that have to be in the database rather than in our usual authentication store - these are using DBD:Pg etc to talk to postgres and deal with the data
Where can read about it? (Please donotjust point to the manual. I have
well, to be honest, this isnt a FreeRADIUS question this is now all postgresql/SQL stuff - how you enter/remove data etc from the database is down to your chosen ways, policies etc ...usually people start with the more simple/common MySQL as their first SQL steps so its quite refreshing to see someone taking on postgresql at this stage :-) alan
participants (3)
-
A.L.M.Buxey＠lboro.ac.uk -
Ivan Kalik -
Just E. Mail