[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freeradius-users
Subject:    Re: Many Mac Addresses to several Vlan ID's Authentication(Aruba Switch) - How to deploy?
From:       Alan DeKok <aland () deployingradius ! com>
Date:       2019-08-29 12:56:21
Message-ID: 8AA0EB94-90FC-4511-897A-AEDE2B5FC7B3 () deployingradius ! com
[Download RAW message or body]

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


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


[prev in list] [next in list] [prev in thread] [next in thread]