Hi,
> mysql> select * from radcheck;
> +----+----------+--------------------+----+-------------------+
> | id | username | attribute | op | value |
> +----+----------+--------------------+----+-------------------+
> | 1 | user01 | Cleartext-Password | := | pass01 |
> | 2 | user01 | Calling-Station-Id | == | 98-4B-4A-F5-BF-40 |
> +----+----------+--------------------+----+-------------------+
okay
> mysql> SELECT id, username, attribute, value, op FROM radcheck WHERE
> username = 'user01' ORDER BY id;
> +----+----------+--------------------+-------------------+----+
> | id | username | attribute | value | op |
> +----+----------+--------------------+-------------------+----+
> | 1 | user01 | Cleartext-Password | pass01 | := |
> | 2 | user01 | Calling-Station-Id | 98-4B-4A-F5-BF-40 | == |
> +----+----------+--------------------+-------------------+----+
yep. okay.
but if you look at your debug output:
[sql] expand: SELECT groupname FROM radusergroup
WHERE username = '%{SQL-User-Name}' ORDER BY priority ->
SELECT groupname FROM radusergroup WHERE username =
'user01' ORDER BY priority
rlm_sql (sql): Released sql socket id: 4
[sql] User user01 not found
so, there is no user01 in the radusergroup SQL table. so it fails. so if you
dont
need the sqlusergroup, turn it off.
alan
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
