Hi,

user1 is a member of group1 and group2. both group1 and group2 has replies in radgroupreply table.

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.

query1: SELECT groupname           FROM radusergroup           WHERE username = 'user1@domain.com'           ORDER BY priority

query2: SELECT id, groupname, attribute,           value, op           FROM radgroupreply           WHERE groupname = 'group1'           ORDER BY id

from the debug, it does not do this query

query3: SELECT id, groupname, attribute,           value, op           FROM radgroupreply           WHERE groupname = 'group2'           ORDER BY id

any idea why? 

i am very sure that query 1 returns more that one value (that is 2 groups, group1 and group2) 

thanks,

det