Fri Nov 22 18:45:00 2002 : Error: rlm_sql_authorize: no rows returned from
query (no such user)
Fri Nov 22 18:45:00 2002 : Auth: Login OK: [giancarlo] (from nas easy@1
port 2070 cli 54942324)
Fri Nov 22 18:47:07 2002 : Error: rlm_sql_authorize: no rows returned from
query (no such user)
Fri Nov 22 18:47:07 2002 : Auth: Login OK: [giancarlo] (from nas easy@1
port 17422 cli 54930260)
my config
-----------------------------------------------------------------------
mysql> select * from radcheck;
+----+-----------+---------------+--------------+------+
| id | UserName | Attribute | Value | op |
+----+-----------+---------------+--------------+------+
| 1 | giancarlo | User-Password | hp3ehp3 | == |
+----+-----------+---------------+--------------+------+
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 | =: | 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 | giancarlo | 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
