client configuration via postgres in version 1.0.1

Joel Bjerk joel.bjerk at
Fri Oct 14 19:43:20 CEST 2005

I managed to get freeradius to use the nas table (from postgres) but I
had to load the SQL module from the 'authorize' section of radiusd.conf.
What I would like to do is load the SQL module for the reading of the
nas table only.  Is this possible?

On Fri, 2005-10-14 at 11:30 -0400, Gunther wrote:
> Yes, it is possible, at least in 1.0.5. My nas list is in MySQL. The DB 
> table columns are in a fixed sequence and referred by
> position and not by name. The nas identifier must be either a DNS 
> resolvable name or IP address or
> IP Address/netmask, e.g.
> I only have 'client' in my clients.conf file.
> Unfortunately a change in the SQL nas table will only be active after 
> restarting freeradius and is not dynamically
> after adding/updating the nas table.
> You can assign the name of the NAS table in sql.conf (if you chose not 
> to use the default name).
> e.g. nas_table = "my_nas" and you have to set:
> # Set to 'yes' to read radius clients from the database ('nas' table)
>          readclients = yes
> Debug output:
> Debug: rlm_sql (sql): - generate_sql_clients
> Debug: rlm_sql (sql): Query: SELECT * FROM nas
> Debug: rlm_sql (sql): Reserving sql socket id: 4
> Debug: rlm_sql_mysql: query:  SELECT * FROM nas
> Debug: rlm_sql (sql): Read entry 
> nasname=my-resolvable-name-or-IP,shortname=moin,secret=whatever
> Debug: rlm_sql (sql): Adding client (moin) to clients list
> Gunther
> On Oct 13, 2005, at 2:13 PM, Joel Bjerk wrote:
> > Is it possible to use the nas table for client information instead of
> > clients.conf?  I tried uncommenting readclients=yes in sql.conf but the
> > server read the clients from clients.conf.
> >
> > Thanks,
> >
> > Joel
> >
> - 
> List info/subscribe/unsubscribe? See

More information about the Freeradius-Users mailing list