Many Mac Addresses to several Vlan ID's Authentication(Aruba Switch) - How to deploy?

[Alan DeKok]

On Aug 29, 2019, at 8:50 AM, Sabic, Enes <enes.sabic at bechtle.com> wrote:
> 
> Thx for quick response. I've a few question. I've already started with impleting it with mysql(Table with two fields,vlan(macs with type varchar(40) and vlan with type int(1)

  That's good...

> Where and how can I configure how to deploy it into mysql?

  Make sure you know the right SQL queries.  Then, copy the queries to the FreeRADIUS configuration with appropriate magic...

	update reply {
		Tunnel Type := VLAN
		Tunnel Medium Type := IEEE-802
		Tunnel-Private-Group-Id := "%{sql:select VLAN from TABLE where mac='%{User-Name}'}"
	}

  That's if the MAC address is in the User-Name field.  It may be somewhere else.

  Alan DeKok.