Lookup lists / arrays?

[David Hartburn]

Can anyone offer some configuration advice?

Our wireless deployment automatically assigns users to any one of around 
20 client VLANS. We have a very small number of MAC addresses (currently 
2) that for one reason or another need a static IP. We use RADIUS to 
make sure they are put on one specific VLAN. This is currently done with 
a MySQL table of MAC addresses and the following section in the post auth:

		# Return a static vlan for those in the static IP group
		if ("%{sql:SELECT COUNT(*) FROM eduroam_static WHERE 
mac='%{Calling-Station-Id}'}" != 0) {
			update reply {
				Tunnel-Type := VLAN
				Tunnel-Medium-Type := IEEE-802
				Tunnel-Private-Group-ID := 641
			}
		}

While this works quite nicely, I have two concerns. One is the 
efficiency overhead. It is performing a SQL lookup on every auth just to 
make sure 2 MAC addresses are put in the correct VLAN. The other is that 
we do not have a resilient database server, so when that reboots for 
patching my FreeRADIUS servers fall over.

Build a better database infrastructure is one solution, but I was 
wondering if there is a better way of doing this?

Being such a small dataset, is it possible to maintain an array or list, 
then use a function to say something like 'if (%{Calling-Station-Id} is 
in list) {.....'?

I could make that if statement a big list of 'this mac or this mac 
or...', but it could get messy. I would also like to keep the list of 
special MAC addresses in its own file. This would allow us to deploy the 
list via puppet.

My googling has not turned up anything like what I want, apart from the 
mac2vlan file used by VPMS. Running a VPMS server seems like overkill too.

Any suggestions appreciated.

Yours

Dave Hartburn