Cool that worked. Thanks.
Joseph R. McSparin Network Administrator Hill Country Memorial Hospital 830 990 6638 phone 830 990 6623 fax [email protected] -----Original Message----- From: freeradius-users-bounces+jmcsparin=hillcountrymemorial.org@lists.freerad ius.org [mailto:freeradius-users-bounces+jmcsparin=hillcountrymemorial.org@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. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
