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