SQL Statement in users file

Brian Julin BJulin at clarku.edu
Thu Jan 5 19:22:17 CET 2012


 

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}

?




More information about the Freeradius-Users mailing list