Rlm_sql in freeradius-1.1.7
Dashamir Hoxha
dhoxha at albaniaonline.net
Thu Jan 17 15:01:26 CET 2008
Hi,
I have installed freeradius-1.1.7 in fedora8. However I find that the module
rlm_sql does not work as described in this page:
http://wiki.freeradius.org/Rlm_sql
For example, I have inserted such data in the database:
radcheck:
+------+----------+------------------+----+-------+
| id | UserName | Attribute | op | Value |
+------+----------+------------------+----+-------+
| 5272 | test | User-Password | := | test |
| 5262 | test | Simultaneous-Use | := | 5 |
+------+----------+------------------+----+-------+
radreply:
+----+----------+---------------+----+----------+
| id | UserName | Attribute | op | Value |
+----+----------+---------------+----+----------+
| 42 | test | Reply-Message | := | Wellcome |
+----+----------+---------------+----+----------+
usergroup:
+----------+-----------+----------+
| UserName | GroupName | priority |
+----------+-----------+----------+
| test | group2 | 2 |
| test | group1 | 1 |
+----------+-----------+----------+
radgroupcheck:
+----+-----------+----------------+----+-------+
| id | GroupName | Attribute | op | Value |
+----+-----------+----------------+----+-------+
| 42 | group1 | NAS-Identifier | != | 123 |
| 52 | group2 | NAS-Identifier | == | 123 |
+----+-----------+----------------+----+-------+
radgroupreply:
+----+-----------+---------------+----+--------+
| id | GroupName | Attribute | op | Value |
+----+-----------+---------------+----+--------+
| 52 | group1 | Reply-Message | += | group1 |
| 62 | group2 | Reply-Message | += | group2 |
+----+-----------+---------------+----+--------+
When I try to login with username 'test' and password 'test'
I get debug messages like these:
Sending Access-Accept of id 30 to 192.168.252.47 port 2053
Reply-Message := "Wellcome"
Reply-Message += "group1"
Reply-Message += "group2"
It seems to me that this is not according to the behavior
described in the documentation above. Am I right or I am
missing something?
Regards,
Dashamir
More information about the Freeradius-Users
mailing list