FreeRadius 071
Mysql
--
User are autenticated but I got this error in the log for each
authentications.
Fri Nov 15 10:01:56 2002 : Error: rlm_sql_authorize: no rows returned from
query (no such user)
Fri Nov 15 10:01:56 2002 : Auth: Login OK: [rexsitt] (from nas easy@1 port
17522 cli 143448807)
--
my config
-----------------------------------------------------------------------
mysql> select * from radcheck;
+----+-----------+---------------+--------------+------+
| id | UserName | Attribute | Value | op |
+----+-----------+---------------+--------------+------+
| 1 | rexsitt | User-Password | hp3ehp3 | NULL |
+----+-----------+---------------+--------------+------+
mysql> select * from radgroupcheck;
+----+-----------+-----------+--------+------+
| id | GroupName | Attribute | Value | op |
+----+-----------+-----------+--------+------+
| 1 | stop | Auth-Type | reject | := |
+----+-----------+-----------+--------+------+
mysql> select * from radgroupreply;
+----+-----------+-----------+-------+------+------+
| id | GroupName | Attribute | Value | op | prio |
+----+-----------+-----------+-------+------+------+
| 1 | dialin | Auth-Type | PAP | NULL | 0 |
+----+-----------+-----------+-------+------+------+
1 row in set (0.00 sec)
mysql> select * from radreply;
Empty set (0.00 sec)
mysql> select * from usergroup;
+----+-----------+-----------+
| id | UserName | GroupName |
+----+-----------+-----------+
| 1 | ressitt | dialin |
+----+-----------+-----------+
2 rows in set (0.00 sec)
==================================================
authorize {
preprocess
#chap
#counter
#attr_filter
#eap
suffix
sql
files
}
###========================================================================
==
# Authentication.
#
authenticate {
# unix
# mschap
# authtype CHAP {
# chap
# }
# authtype PAP {
# pap
# }
#sql
#
}
#####==================================================================
accounting {
detail
sql
radutmp
}
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
