if i include the user file, ----------------- rlm_sql_mysql: query: SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'luqe' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id rlm_sql (sql): No matching entry in the database for request from user [luqe] rlm_sql (sql): Released sql socket id: 2 modcall[authorize]: module "sql" returns notfound for request 1 modcall: group authorize returns ok for request 1 rad_check_password: Found Auth-Type Local auth: type Local auth: user supplied User-Password matches local User-Password Login OK: [luqe] (from client dns port 1812) Sending Access-Accept of id 4 to 127.0.0.1:32810 Finished request 1
---------------------- it successfully authenticate using 'user' file... but still fail with mysql.. with: No matching entry in the database ... so maybe the problem is in my data table that not correctly filled so here again i list my table data, please correct it to match the freeradius-1.0.5 requirement... ----------------- mysql> SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = 'luqe' ORDER BY id; +-----+----------+---------------+----------+----+ | id | UserName | Attribute | Value | op | +-----+----------+---------------+----------+----+ | 553 | luqe | User-Password | mypassword | := | +-----+----------+---------------+----------+----+ 1 row in set (0.00 sec) mysql> SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'luqe' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id; +----+-----------+------------------+-------+----+ | id | GroupName | Attribute | Value | op | +----+-----------+------------------+-------+----+ | 3 | dial-up | Auth-Type | Local | := | | 4 | dial-up | Simultaneous-Use | 1 | == | +----+-----------+------------------+-------+----+ 2 rows in set (0.00 sec) mysql> SELECT id, UserName, Attribute, Value, op FROM radreply WHERE Username = 'luqe' ORDER BY id; +-----+----------+-------------------+-------------+----+ | id | UserName | Attribute | Value | op | +-----+----------+-------------------+-------------+----+ | 553 | luqe | User-Password | mypassword | := | | 554 | luqe | Framed-IP-Address | 192.168.1.2 | := | | 558 | luqe | Simultaneous-Use | 2 | = | +-----+----------+-------------------+-------------+----+ 3 rows in set (0.00 sec) mysql> SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'luqe' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id; +----+-----------+--------------------+---------------------+----+ | id | GroupName | Attribute | Value | op | +----+-----------+--------------------+---------------------+----+ | 4 | dial-up | Service-Type | Framed-User | := | | 5 | dial-up | Framed-Protocol | PPP | := | | 7 | dial-up | Framed-Compression | Van-Jacobson-TCP-IP | := | +----+-----------+--------------------+---------------------+----+ 3 rows in set (0.02 sec) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
