VMPS fallback vlan

[McSparin, Joe]

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 at hillcountrymemorial.org

-----Original Message-----
From:
freeradius-users-bounces+jmcsparin=hillcountrymemorial.org at lists.freerad
ius.org
[mailto:freeradius-users-bounces+jmcsparin=hillcountrymemorial.org at lists
.freeradius.org] On Behalf Of Walter Gould
Sent: Thursday, February 09, 2012 9:49 AM
To: freeradius-users at 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.