freeradius and mysql - no matching entry in db
Luqman H
luqeckr at gmail.com
Wed Oct 26 06:24:04 CEST 2005
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)
More information about the Freeradius-Users
mailing list