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

Alan DeKok aland at
Thu Aug 29 14:56:21 CEST 2019

On Aug 29, 2019, at 8:50 AM, Sabic, Enes <enes.sabic at> 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.

More information about the Freeradius-Users mailing list