<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div>Hi,</div><div><br></div><div>user1 is a member of group1 and group2. both group1 and group2 has replies in radgroupreply table.</div><div><br></div><div>when freeradius query for radusergroup, it will only get the first group the user is a member of and will proceed to get the reply attributes for that group as below.</div><div><br></div><div>query1: SELECT groupname FROM radusergroup WHERE username = 'user1@domain.com' ORDER BY priority</div><div>query2: SELECT id, groupname, attribute, value, op FROM
radgroupreply WHERE groupname = 'group1' ORDER BY id</div><div><br></div><div>from the debug, it does not do this query</div><div>query3: SELECT id, groupname, attribute, value, op FROM
radgroupreply WHERE groupname = 'group2' ORDER BY id</div><div><br></div><div>any idea why? </div><div><br></div><div>i am very sure that query 1 returns more that one value (that is 2 groups, group1 and group2) </div><div><br></div><div><br></div><div>thanks,</div><div>det<br></div></div></body></html>