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(a)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(a)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(a)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
