NAS type with NAS defined in SQL (FR 2.1.6)

2010-09-15 Thread John Doppke 
I've tried dozens of ways but I can't figure out how to get the NAS type for 
clients defined in MySQL.

The column is populated, the query has the correct fields matching the source 
code for the module.  The module appears to populate the address, shortname, 
nastype, secret and virtual server.  Yet when I expand ${client:nastype} I 
only get a value for clients defined in the clients file.  SQL clients are 
always blank.

I know I could do a special SQL query on each request, but I shouldn't have to. 
 The data should already be in a variable.

-John


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: NAS type with NAS defined in SQL (FR 2.1.6)

2010-09-15 Thread Alan DeKok 
John Doppke wrote:
 I've tried dozens of ways but I can't figure out how to get the NAS type for 
 clients defined in MySQL.
 
 The column is populated, the query has the correct fields matching the source 
 code for the module.  The module appears to populate the address, shortname, 
 nastype, secret and virtual server.  Yet when I expand ${client:nastype} I 
 only get a value for clients defined in the clients file.  SQL clients are 
 always blank.

  The client:nastype expansion grabs the nastype field from the
*config* files.  For SQL... there is no client config file.

 I know I could do a special SQL query on each request, but I shouldn't have 
 to.  The data should already be in a variable.

  Sure.  Send a patch.  See src/main/mainconfig.c, function xlat_client().

  Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html