There is an entry for mpearson in my database but not that select statement. What should be in the radgroupreply and the radreply tables? I don't have any data in either of those tables. Thank Mike Alan DeKok wrote:
Mike Pearson <mpearson@usachoice.net> wrote:
My problems is I can't get the users to authenticate, I pasted the output from radtest and radiusd -X. I can provide any more information that my be needed.
Ok...
radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'mpearson' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql (sql): No matching entry in the database for request from user [mpearson]
That's the problem. Is there an entry for mpearson? If so, what does it look like?
Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html