No matching entry in the database for request from user...
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
+----+----------+-----------+-------+----+
| id | UserName | Attribute | Value | op |
+----+----------+-----------+-------+----+
| 1 | kno | Password | kk | == |
+----+----------+-----------+-------+----+
Try calling the attribute "User-Password" and the op ":=" as it is documented in lots of places and discussed very often on this list. Greetings, Stefan Winter -- Stefan WINTER RESTENA Foundation - Réseau Téléinformatique de l'Education Nationale et de la Recherche R&D Engineer 6, rue Richard Coudenhove-Kalergi L-1359 Luxembourg email: stefan.winter@restena.lu Tel.: +352 424409-1 http://www.restena.lu Fax: +352 422473
El Miércoles, 1 de Marzo de 2006 12:47, Stefan Winter escribió:
+----+----------+-----------+-------+----+
| id | UserName | Attribute | Value | op |
+----+----------+-----------+-------+----+
| 1 | kno | Password | kk | == |
+----+----------+-----------+-------+----+
Try calling the attribute "User-Password" and the op ":=" as it is documented in lots of places and discussed very often on this list.
Greetings,
Stefan Winter Ok changed: SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'kno' ORDER BY id; +----+----------+---------------+-------+----+ | id | UserName | Attribute | Value | op | +----+----------+---------------+-------+----+ | 1 | kno | User-Password | kk | := | +----+----------+---------------+-------+----+ But the same message in the server: 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:59454, id=214, length=55 Sending Access-Reject of id 214 to 80.xx.xx.xx:59454
More ideas? Thanks
+----+----------+---------------+-------+----+
| id | UserName | Attribute | Value | op |
+----+----------+---------------+-------+----+
| 1 | kno | User-Password | kk | := |
+----+----------+---------------+-------+----+ But the same message in the server: 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:59454, id=214, length=55 Sending Access-Reject of id 214 to 80.xx.xx.xx:59454
More ideas? Thanks
Sure. Post the complete output of "radiusd -X" and at least the authorize {} and authenticate {} section of your radiusd.conf. That will help a lot in finding the problem. Greetings, Stefan Winter -- Stefan WINTER RESTENA Foundation - Réseau Téléinformatique de l'Education Nationale et de la Recherche R&D Engineer 6, rue Richard Coudenhove-Kalergi L-1359 Luxembourg email: stefan.winter@restena.lu Tel.: +352 424409-1 http://www.restena.lu Fax: +352 422473
Hi,
SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'kno' ORDER BY id; +----+----------+---------------+-------+----+ | id | UserName | Attribute | Value | op | +----+----------+---------------+-------+----+ | 1 | kno | User-Password | kk | := | +----+----------+---------------+-------+----+
UserName Username ? alan
El Miércoles, 1 de Marzo de 2006 13:51, A.L.M.Buxey@lboro.ac.uk escribió:
Hi,
SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'kno' ORDER BY id; +----+----------+---------------+-------+----+
| id | UserName | Attribute | Value | op |
+----+----------+---------------+-------+----+
| 1 | kno | User-Password | kk | := |
+----+----------+---------------+-------+----+
UserName Username No it was not. I've truncate all tables (usergruup, etc) execept radcheck and it has work. Now to crypt passwords with md5 Thanks a lot, kNo
?
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (3)
-
A.L.M.Buxey＠lboro.ac.uk -
kno -
Stefan Winter