Dynamic clients from SQL.

Norbert Wegener norbert.wegener at siemens.com
Sat Jun 14 15:50:04 CEST 2008


As it seems to me:

if ("%{sqlnastype: SELECT nasname FROM nas WHERE nasname = 
%{Packet-Src-IP-Address}}") {
misses some ':

if ("%{sqlnastype: SELECT nasname FROM nas WHERE nasname = 
'%{Packet-Src-IP-Address}'}") {
works.

Norbert Wegener


Alan DeKok schrieb:
> $ cvs update
> $ more raddb/sites-available/dynamic-clients
>
>   It Just Works.
>
>   You can now manage clients in an SQL table.  When the server receives
> packets from a new client, it looks up the IP in SQL.  The clients can
> expire (so shared secrets can be changed).  When 'readclients=yes' is
> set in sql.conf, you only need one "client" entry in the configuration
> files.
>
>   The dynamic clients can be read from anywhere... not just from SQL.
>
>   The configuration needs to be tested, as the SQL example in the
> "dynamic-clients" file may not be exactly correct.  But it should be
> relatively easy to fix.
>
>   Client lookups are rate-limited, so DoS attacks won't affect the
> server.  The lookups are done NO MORE THAN once a second after the
> server starts.
>
>   Alan DeKok.
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>   




More information about the Freeradius-Users mailing list