freeradius and mysql - no matching entry in db
Luqman H
luqeckr at gmail.com
Tue Oct 25 11:18:59 CEST 2005
i have fedora core 4 and freeradius-1.0.5
and this is what i do...
# radtest luqe mypassword localhost 1812 testing123
Sending Access-Request of id 24 to 127.0.0.1:1812
User-Name = "luqe"
User-Password = "mypassword"
NAS-IP-Address = dns.mammiri.net
NAS-Port = 1812
rad_recv: Access-Reject packet from host 127.0.0.1:1812, id=24, length=20
* On radius log:
radius_xlat: 'SELECT id, UserName, Attribute, Value, op
FROM radcheck WHERE Username = 'luqe' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 2
rlm_sql_mysql: query: SELECT id, UserName, Attribute, Value, op
FROM radcheck WHERE Username = 'luqe' ORDER BY
id
radius_xlat: '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'
rlm_sql_mysql: query: 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
radius_xlat: 'SELECT id, UserName, Attribute, Value, op
FROM radreply WHERE Username = 'luqe' ORDER BY id'
rlm_sql_mysql: query: SELECT id, UserName, Attribute, Value, op
FROM radreply WHERE Username = 'luqe' ORDER BY
id
radius_xlat: '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_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 2
modcall: group authorize returns ok for request 2
auth: No authenticate method (Auth-Type) configuration found for the
request: Rejecting the user
auth: Failed to validate the user.
No matching entry in the database for request from user [luqe]
but if i'm quering manually on mysql:
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