radius+mysql weird problem

Jorge Minassian - Comintec jorge at comintec.net
Sat Dec 23 00:36:27 CET 2006


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,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op 
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,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op 
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





More information about the Freeradius-Users mailing list