I figured it out. As odd as it was, I had to restart Postgres after making the changes to the radius configs. Once I did that, it started passing the value rather than the variable name.
Brian Andrus FirstSpot, Inc. (310) 899-WiFi [EMAIL PROTECTED] http://www.firstspot.net -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan DeKok Sent: Saturday, March 12, 2005 9:49 AM To: freeradius-users@lists.freeradius.org Subject: Re: SQL auth_check_query and available variables "Brian Andrus" <[EMAIL PROTECTED]> wrote: > What variables are available to the auth_check_query? All attributes that exist. > SELECT id, username, attribute, value, op FROM radcheck WHERE username > = 'brian' AND allowed_NAS = '%{NAS-Identifier}'" I'm not sure why that would happen. I've never seen it myself. > Are the variables from the NAS unavailable to a SQL query for auth? If an attribute is in the request packet, you can use it in the SQL query. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
