Using FreeRADIUS with SQL backend and advanced configuration

Marius Flage marius at flage.org
Wed Dec 9 23:48:00 CET 2015


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 at 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
> 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 196 bytes
Desc: OpenPGP digital signature
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20151209/f5e4c7b8/attachment.sig>


More information about the Freeradius-Users mailing list