SQL Statement in users file

[McSparin, Joe]

Cool that worked. Thanks. 


Joseph R. McSparin
Network Administrator
Hill Country Memorial Hospital
830 990 6638 phone
830 990 6623 fax
jmcsparin at hillcountrymemorial.org

-----Original Message-----
From:
freeradius-users-bounces+jmcsparin=hillcountrymemorial.org at lists.freerad
ius.org
[mailto:freeradius-users-bounces+jmcsparin=hillcountrymemorial.org at lists
.freeradius.org] On Behalf Of Brian Julin
Sent: Thursday, January 05, 2012 12:22 PM
To: FreeRadius users mailing list
Subject: RE: SQL Statement in users file


 

McSparin, Joe wrote:
> 
> Does anyone know if there is a way in the users file to set 
> the Tunnel-Private-Group-id = "some_default_vlan" if the 
> following sql statement comes back blank.
> 
> DEFAULT         Auth-Type = "ntlm_auth"
>                 Tunnel-Type = "VLAN",
>                 Tunnel-Medium-Type = "IEEE-802",
>                 Tunnel-Private-Group-id = "%{sql:SELECT 
> radius.vlans.assigned_vl an FROM radius.vlans WHERE 
> radius.vlans.device_mac = '%{Calling-Station-Id}'}" 

maybe %{%{sql:SELECT radius.vlans.assigned_vl an FROM radius.vlans WHERE
radius.vlans.device_mac = '%{Calling-Station-Id}'}:-some_default_vlan}

?

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

-- 
This email message and any attachments are for the sole use of the intended recipient(s) and contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message and any attachments.