User loging correctly but with some error that I don't understand.
(Log)
Sat Oct 12 10:42:12 2002 : Error: rlm_sql: Stop packet with zero session
length. (user '', nas '180.117.209.1')
Sat Oct 12 10:42:12 2002 : Error: Accounting: logout: login entry for NAS
UNKNOWN-NAS port 17436 not found
Sat Oct 12 10:44:07 2002 : Error: rlm_sql_authorize: no rows returned from
query (no such user)
my config
mysql> select * from radcheck;
+----+-----------+---------------+--------------+------+
| id | UserName | Attribute | Value | op |
+----+-----------+---------------+--------------+------+
| 1 | username1 | 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 | username1 | 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