rlm_sql - restrict user/hosts groups

Jarosław Kłopotek - INTERDUO jkl at interduo.pl
Mon Apr 29 10:50:34 UTC 2024


Hi,
I use freeradius 3.0 and rlm_sql and I would like to create 
hostgroup/usergroup ACL for login access.

In postgres SQL i created:

SELECT * FROM nasgroup;
  id | nasgroupname |    nasname
----+--------------+---------------
   1 | restricted   | 172.20.2.42

freeradius=# SELECT * FROM radusergroup;
  id |  username   | groupname | priority
----+-------------+-----------+----------
   4 | user1        | adm       |        1
   5 | user2   | adm       |        1
   6 | user3 | adm       |        1
   1 | user4       | superadm  |        1
   2 | user5      | superadm  |        1
   3 | user6        | superadm  |        1
   7 | user7    | read  |        1

So in this example I would like to restrict access for all hosts in 
group restricted (172.20.2.42) only for users in group superadm (user4, 
user5, user6).

How to this in proper way?

-- 
Jarosław Kłopotek - INTERDUO




More information about the Freeradius-Users mailing list