-- -John

...

...

On 3/19/2010 at 4:21 PM, <freeradius-users-request@lists.freeradius.org> 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 ...