Hi all, sorry I forgot to run the other queries. The AP is a Cisco Aironet 1200 (1220b) Here are the queries:
> SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = > '00062541e359' ORDER BY id +-----+--------------+---------------+----------+------+ | id | UserName | Attribute | Value | op | +-----+--------------+---------------+----------+------+ | 215 | 00062541e359 | User-Password | ourpaswd | == | +-----+--------------+---------------+----------+------+ 1 row in set (0.00 sec) > SELECT > radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgr > ou > pcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE > usergroup.Username = '00062541e359' AND usergroup.GroupName = > radgroupcheck.GroupName ORDER BY radgroupcheck.id Empty set (0.00 sec) > SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = > '00062541e359' ORDER BY id Empty set (0.00 sec) > SELECT > radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgr > ou > pcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE > usergroup.Username = '00022d111111' AND usergroup.GroupName = > radgroupcheck.GroupName ORDER BY radgroupcheck.id Empty set (0.00 sec) > SELECT > radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgr > ou > preply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE > usergroup.Username = '00062541e359' AND usergroup.GroupName = > radgroupreply.GroupName ORDER BY radgroupreply.id Empty set (0.00 sec) > SELECT Value,Attribute FROM radcheck WHERE UserName = '00062541e359' > AND ( Attribute = 'User-Password' OR Attribute = 'Password' OR > Attribute = > 'Crypt-Password') ORDER BY Attribute DESC +----------+---------------+ | Value | Attribute | +----------+---------------+ | ourpaswd | User-Password | +----------+---------------+ 1 row in set (0.00 sec) > SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = > '00022d111111' ORDER BY id +-----+--------------+---------------+----------+------+ | id | UserName | Attribute | Value | op | +-----+--------------+---------------+----------+------+ | 215 | 00022d111111 | User-Password | ourpaswd | == | +-----+--------------+---------------+----------+------+ 1 row in set (0.00 sec) > SELECT > radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgr > ou > pcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE > usergroup.Username = '00022d111111' AND usergroup.GroupName = > radgroupcheck.GroupName ORDER BY radgroupcheck.id Empty set (0.00 sec) > SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = > '00022d111111' ORDER BY id Empty set (0.00 sec) > SELECT > radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgr > ou > preply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE > usergroup.Username = '00022d111111' AND usergroup.GroupName = > radgroupreply.GroupName ORDER BY radgroupreply.id Empty set (0.00 sec) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
