--
-John
>>> On 3/19/2010 at 4:21 PM, <[email protected]>
wrote:
> t does if the info is there:
>
> SELECT id, nasname, shortname, type, secret FROM ${nas_table}
>
> (in fact, it can also populate the 'server' too - add that as last
> option in the SELECT - latest version of FreeRADIUS only!)
>
> what does the server say when you start - ie radiusd -X
>
> alan
>
I think this is the relevent part:
radius_db = "radius"
read_groups = yes
sqltrace = yes
sqltracefile = "/var/log/radius/sqltrace.sql"
readclients = yes
deletestalesessions = yes
num_sql_socks = 5
lifetime = 0
max_queries = 0
sql_user_name = "%{User-Name}"
default_user_profile = "sqldefault"
nas_query = "SELECT id, nasname, shortname, type, secret FROM nas"
authorize_check_query = "SELECT id, username, attribute, value, op
FROM radcheck
WHERE username = '%{SQL-User-Name}' ORDER BY id"
authorize_reply_query = "SELECT id, username, attribute, value, op
FROM radreply
WHERE username = '%{SQL-User-Name}' ORDER BY id"
authorize_group_check_query = "SELECT id, groupname, attribute,
Value, op
FROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER
BY id"
authorize_group_reply_query = "SELECT id, groupname, attribute,
value, op
Also:
rlm_sql (sql): Processing generate_sql_clients
rlm_sql (sql) in generate_sql_clients: query is SELECT id, nasname, shortname,
type, secret FROM nas
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql_mysql: query: SELECT id, nasname, shortname, type, secret FROM nas
rlm_sql (sql): Read entry nasname=192.168.41.233,shortname=
LAFAYETTE-IN-WAP10,secret=xxx
rlm_sql (sql): Adding client 192.168.41.233 ( LAFAYETTE-IN-WAP10,
server=<none>) to clients list
rlm_sql (sql): Read entry nasname=140.171.181.215,shortname= WAP16,secret=xxx
rlm_sql (sql): Adding client 192.168.181.215 ( WAP16, server=<none>) to clients
list
...
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
