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