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.h...@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.h...@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.h...@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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html