Radius 0.7.1 Login ok, but first line indicate one error
Fri Oct 18 23:10:41 2002 : Error: rlm_sql_authorize: no rows returned from query (no such user) Fri Oct 18 23:10:41 2002 : Auth: Login OK: [giancarlo] (from nas easy@1 port 22555 cli 43746040) What kind ok error is ? my config mysql> select * from radcheck; +----+-----------+---------------+--------------+------+ | id | UserName | Attribute | Value | op | +----+-----------+---------------+--------------+------+ | 1 | giancarlo | 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 | 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