radius+mysql weird problem

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 ...


Go Back   Usenet Forums > Networking and Network Related > FreeRADIUS Users

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 12-23-2006
Jorge Minassian - Comintec
 
Posts: n/a
Default radius+mysql weird problem

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
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 08:25 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0