NAS type when NAS is stored in SQL?

[John Doppke]

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