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