This is a discussion on radius+mysql weird problem within the FreeRADIUS Users forums, part of the Networking and Network Related category; Hello all !, After upgrading Fedora from FC2 to FC4, I got what is described below from log (radiusd -X) If ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
Hello all !,
After upgrading Fedora from FC2 to FC4, I got what is described below from log (radiusd -X) If I query database manually, I get all info about users (all users are correctly on DB), but radius still says "No matching entry in the database ....". If using "files", it works OK. I tried to downgrade DB (from 4.1 to 3.23), also reinstal freeradius from rpm or compiled by me, but problem persists. Have someone any ad about this ?. I will apreciate any help to troubleshoot this problem !. Thank you very much, Jorge. ---- Ready to process requests. rad_recv: Access-Request packet from host localhost:56607, id=27, length=55 User-Name = "000" User-Password = "1234" NAS-IP-Address = 255.255.255.255 NAS-Port = 1 modcall: entering group authorize for request 0 modcall[authorize]: module "preprocess" returns ok for request 0 rlm_realm: No '@' in User-Name = "000", looking up realm NULL rlm_realm: No such realm "NULL" modcall[authorize]: module "suffix" returns noop for request 0 radius_xlat: '000' rlm_sql (sql): sql_set_user escaped user --> '000' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = '000' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 4 radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupc heck.Attribute,radgroupcheck.Value,radgroupcheck.o p FROM radgroupcheck,usergroup WHERE usergroup.Username = '000' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = '000' ORDER BY id' radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupr eply.Attribute,radgroupreply.Value,radgroupreply.o p FROM radgroupreply,usergroup WHERE usergroup.Username = '000' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql (sql): No matching entry in the database for request from user [000] rlm_sql (sql): Released sql socket id: 4 modcall[authorize]: module "sql" returns notfound for request 0 modcall: group authorize returns ok for request 0 auth: No authenticate method (Auth-Type) configuration found for the request: Rejecting the user auth: Failed to validate the user. Login incorrect: [000/1234] (from client gabriel port 1) Sending Access-Reject of id 27 to localhost:56607 Finished request 0 Going to the next request - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html |
![]() |
| Thread Tools | |
| Display Modes | |
|
|