No matching entry in the database for request from user...

1 Mar 2006

      Hi, I've just start "playing" with freeradius and I'm doing some test to 
learn.
The authorization via files works:
radtest kno1 kk  80.xx.xx.xx  1 testing123
Sending Access-Request of id 128 to 80.xx.xx.xx port 1812
        User-Name = "kno1"
        User-Password = "kk"
        NAS-IP-Address = 255.255.255.255
        NAS-Port = 1
rad_recv: Access-Accept packet from host 80.xx.xx.xx:1812, id=128, length=33
        Reply-Message = "Hello, kno1"
But I want to do it via mysql, and here is the problem. 
I've try to follow the notes at http://www.frontios.com/freeradius.html
I've an user in the DB:
SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'kno' 
ORDER BY id;
+----+----------+-----------+-------+----+
| id | UserName | Attribute | Value | op |
+----+----------+-----------+-------+----+
|  1 | kno      | Password  | kk    | == |
+----+----------+-----------+-------+----+
But the authorization  fails:
radtest kno kk  80.xx.xx.xx  1 testing123
Sending Access-Request of id 110 to 80.xx.xx.xx port 1812
        User-Name = "kno"
        User-Password = "kk"
        NAS-IP-Address = 255.255.255.255
        NAS-Port = 1
Re-sending Access-Request of id 110 to 80.xx.xx.xx port 1812
        User-Name = "kno"
        User-Password = "kk"
        NAS-IP-Address = 255.255.255.255
        NAS-Port = 1
[re-sending 4 times]
rad_recv: Access-Reject packet from host 80.xx.xx.xx:1812, id=110, length=20

The server side log:

rad_recv: Access-Request packet from host 80.xx.xx.xx:59115, id=110, length=55
        User-Name = "kno"
        User-Password = "kk"
        NAS-IP-Address = 255.255.255.255
        NAS-Port = 1
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql_mysql: query:  SELECT id,UserName,Attribute,Value,op FROM radcheck 
WHERE Username = 'kno' ORDER BY id;
rlm_sql_mysql: query:  SELECT 
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op  
FROM radgroupcheck,usergroup WHERE usergroup.Username = 'kno' AND 
usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id;
rlm_sql_mysql: query:  SELECT id,UserName,Attribute,Value,op FROM radreply 
WHERE Username = 'kno' ORDER BY id;
rlm_sql_mysql: query:  SELECT 
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op  
FROM radgroupreply,usergroup WHERE usergroup.Username = 'kno' AND 
usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id;
rlm_sql (sql): No matching entry in the database for request from user [kno]
rlm_sql (sql): Released sql socket id: 4
Login incorrect (No password configured for the user): [kno/kk] (from client 
kno port 1)
Login incorrect: [kno/kk] (from client kno port 1)
rad_recv: Access-Request packet from host 80.xx.xx.xx:59115, id=110, length=55
Sending Access-Reject of id 110 to 80.xx.xx.xx:59115

I don't know where is the error, any ideas?
Thanks, kNo