Here it is....Thanks for the help! Please let me know what you find, time is running out!
mysql> SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = '00062541e359' ORDER BY id; +-----+--------------+---------------+----------+------+ | id | UserName | Attribute | Value | op | +-----+--------------+---------------+----------+------+ | 205 | 00062541e359 | User-Password | ourpaswd | == | +-----+--------------+---------------+----------+------+ 1 row in set (0.00 sec) Ourpaswd is actully the shared for the radius server. Thank You -Mike -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeffrey C. Ollie Sent: Saturday, August 09, 2003 11:33 PM To: [EMAIL PROTECTED] Subject: RE: Cisco Aironet - MAC auth logs 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,radgr > ou > 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,radgr > ou > 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,radgr > ou > 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,radgr > ou > 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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
