SQL Statement in users file

McSparin, Joe jmcsparin at hillcountrymemorial.org
Thu Jan 5 16:24:06 CET 2012

Does this seem like a doable scenario in the users file it doesn't
return anything but I'm not sure if it is query issue or if those values
are not available in the users file.

DEFAULT  Auth-Type = "ntlm_auth"
                Tunnel-Type = "VLAN",
                Tunnel-Medium-Type = "IEEE-802",
                Tunnel-Private-Group-id = "%{sql:SELECT
'vlans.assigned_vlan' FROM 'vlans' WHERE 'vlans.device_mac' =

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

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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20120105/77c0ba11/attachment.html>

More information about the Freeradius-Users mailing list