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