Mike,

Could you run the following queries manually against your MySQL database
and post the results?

> SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username =
> '00062541e359' ORDER BY id

> SELECT
> radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgrou
> pcheck.Value,radgroupcheck.op  FROM radgroupcheck,usergroup WHERE
> usergroup.Username = 'user' AND usergroup.GroupName =
> radgroupcheck.GroupName ORDER BY radgroupcheck.id

> SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username =
> '00062541e359' ORDER BY id

> SELECT
> radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrou
> preply.Value,radgroupreply.op  FROM radgroupreply,usergroup WHERE
> usergroup.Username = '00062541e359' AND usergroup.GroupName =
> radgroupreply.GroupName ORDER BY radgroupreply.id

> SELECT Value,Attribute FROM radcheck WHERE UserName = '00062541e359' AND
> ( Attribute = 'User-Password' OR Attribute = 'Password' OR Attribute =
> 'Crypt-Password') ORDER BY Attribute DESC

> SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username =
> '00022d111111' ORDER BY id

> SELECT
> radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgrou
> pcheck.Value,radgroupcheck.op  FROM radgroupcheck,usergroup WHERE
> usergroup.Username = '00022d111111' AND usergroup.GroupName =
> radgroupcheck.GroupName ORDER BY radgroupcheck.id

> SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username =
> '00022d111111' ORDER BY id

> SELECT
> radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrou
> preply.Value,radgroupreply.op  FROM radgroupreply,usergroup WHERE
> usergroup.Username = '00022d111111' AND usergroup.GroupName =
> radgroupreply.GroupName ORDER BY radgroupreply.id



- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to