Hi Alan, Could you possibly provide a more elaborate example than that? How do I differentiate between the different groups of requests? As the tables look like this:
desc radcheck; +-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | id | int(11) unsigned | NO | PRI | NULL | auto_increment | | username | varchar(64) | NO | MUL | | | | attribute | varchar(64) | NO | | | | | op | char(2) | NO | | == | | | value | varchar(253) | NO | | | | +-----------+------------------+------+-----+---------+----------------+ 5 rows in set (0.00 sec)
desc radgroupreply; +-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | id | int(11) unsigned | NO | PRI | NULL | auto_increment | | groupname | varchar(64) | NO | MUL | | | | attribute | varchar(64) | NO | | | | | op | char(2) | NO | | = | | | value | varchar(253) | NO | | | | +-----------+------------------+------+-----+---------+----------------+ 5 rows in set (0.00 sec)
How do I then "tie" together the different attribute checks? And the same regarding the radgroupreply: how do I tell which reply belongs to which check? -- Marius Den 09.12.2015 23:11, skrev A.L.M.Buxey@lboro.ac.uk:
Hi,
The theory here is that if the user "testuser" logs in with the password "example" from the device with MAC address "a0:a8:cd:60:af:c2", then he should be placed into the VLAN 3, if not, into VLAN 4. Is this possible with FreeRADIUS and specifically when using the SQL backend?
yes - using radcheck and radgroupreply etc as per normal.
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html