Thanks for the reply Stefan, Here is the output from mysql for the statement below: mysql> SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username -> = 'mpearson' ORDER BY id -> -> ; +------+----------+------------------+--------+----+ | id | UserName | Attribute | Value | op | +------+----------+------------------+--------+----+ | 1118 | mpearson | Password | XXXX| == | | 1119 | mpearson | Simultaneous-Use | 1 | == | +------+----------+------------------+--------+----+ 2 rows in set (0.29 sec) Also I went down through the debug of radisud and put in the select statments from I didn't get any results from: SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'mpearson' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id and SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'mpearson' ORDER BY id Thanks Mike Stefan Winter wrote:
Hi,
nicely done problem report!
My guess is that your tables contain a check item that is not satisfied by the incoming requests. Could you do a SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'mpearson' ORDER BY id
(this is one of the SQL statements in the debug output. It might also help to execute all other statements that appeared in the debug output for the user and post them too)
and post it to the list (obfuscate the password of course)? Because
rlm_sql (sql): No matching entry in the database for request from user [mpearson]
this output looks suspiciously like the user itself was found in the database, but there was more than one line concerning him and not all of those lines containing check items were satisfied.
Greetings,
Stefan Winter
------------------------------------------------------------------------
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html