No matching entry in the database for request from user...
kno
linsms at gmail.com
Wed Mar 1 11:31:31 CET 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
More information about the Freeradius-Users
mailing list