Members of two groups

[Andrew Paternoster]

Hi List

Sorry if this is a simple problem i have been pulling my hair out for 3 days. I running Freeradius 2.1.6 and its all working great. Ecept for my users that are members of 2 groups. I have been reading on the net and it looks like it can be done but for the life of me i can not get it to work The only grop that applies is the lowest priorty. The system just seems to ingor the rest of the list. The strange this is that if i run the SQL querys it looks like it pulling the right data back but not adding each attibute to the logon only the first one. I have moved the prioritys around and it works will all of them but only one at a time and only the lowest priority. 


Can anyone point out what i'm missing

Thanks
Andrew Paternoster

Mon Jun  1 22:24:46 2009 : Info: [sql]  expand: SELECT id, username, attribute, value, op           FROM radcheck           WHERE username = '%{SQL-User-Name}'           ORDER BY id -> SELECT id, username, attribute, value, op           FROM radcheck           WHERE username = 'andrew.home at gpknet.com.au'           ORDER BY id
Mon Jun  1 22:24:46 2009 : Info: [sql] User found in radcheck table
Mon Jun  1 22:24:46 2009 : Info: [sql]  expand: SELECT id, username, attribute, value, op           FROM radreply           WHERE username = '%{SQL-User-Name}'           ORDER BY id -> SELECT id, username, attribute, value, op           FROM radreply           WHERE username = 'andrew.home at gpknet.com.au'           ORDER BY id
Mon Jun  1 22:24:46 2009 : Info: [sql]  expand: SELECT groupname           FROM radusergroup           WHERE username = '%{SQL-User-Name}'           ORDER BY priority -> SELECT groupname           FROM radusergroup           WHERE username = 'andrew.home at gpknet.com.au'           ORDER BY priority
Mon Jun  1 22:24:46 2009 : Info: [sql]  expand: SELECT id, groupname, attribute,           Value, op           FROM radgroupcheck           WHERE groupname = '%{Sql-Group}'           ORDER BY id -> SELECT id, groupname, attribute,           Value, op           FROM radgroupcheck           WHERE groupname = '8M Download'           ORDER BY id
Mon Jun  1 22:24:46 2009 : Info: [sql] User found in group 8M Download
Mon Jun  1 22:24:46 2009 : Info: [sql]  expand: SELECT id, groupname, attribute,           value, op           FROM radgroupreply           WHERE groupname = '%{Sql-Group}'           ORDER BY id -> SELECT id, groupname, attribute,           value, op           FROM radgroupreply           WHERE groupname = '8M Download'           ORDER BY id