I have the following in my users file. It does a lookup of my vlans table on the users mac-address(aka Calling-Station-Id) if it can't find it then it assumes it is a guest and then defaults to vlan 16. DEFAULT Auth-Type = "ntlm_auth" Tunnel-Type = "VLAN", Tunnel-Medium-Type = "IEEE-802", Tunnel-Private-Group-id = "%{%{sql:SELECT radius.vlans.assigned_ vlan FROM radius.vlans WHERE radius.vlans.device_mac = '%{Calling-Station-Id}'}: -'16'}" Joseph R. McSparin Network Administrator Hill Country Memorial Hospital 830 990 6638 phone 830 990 6623 fax jmcsparin@hillcountrymemorial.org -----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 Walter Gould Sent: Thursday, February 09, 2012 9:49 AM To: freeradius-users@lists.freeradius.org Subject: VMPS fallback vlan All, I have FR vmps configured to query postgresql for a mac address and return the vlan that is assigned to it. That is working well. However, I would like to configure vmps to return a "fallback" or guest vlan for cases when a mac address is not in the database. Can anyone give me some suggestions or config examples? Thanks, Walter - 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.