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