> This looks like my radgroupcheck -- is that what you are using?
>> +-----------+-----------+----+--------+-----------+
>> | GroupName | Attribute | op | Value | HuntGroup |
>> +-----------+-----------+----+--------+-----------+
Yes, this is the standard MySQL table layout but with the addition of the
HuntGroup column.
> This looks like my radgroupreply -- is that what you are using?
>> +-----------+------------------+----+------------------+-----------+
>> | GroupName | Attribute | op | Value | HuntGroup |
>> +-----------+------------------+----+------------------+-----------+
Ditto.
> Can you post the changes you made to the sql.conf queries?
authorize_group_check_query =
"SELECT ${groupcheck_table}.id,${groupcheck_table}.GroupName,
${groupcheck_table}.Attribute,${groupcheck_table}.Value,
${groupcheck_table}.op FROM ${groupcheck_table},${usergroup_table}
WHERE ${usergroup_table}.Username = trim('%{SQL-User-Name}') AND
${usergroup_table}.GroupName = ${groupcheck_table}.GroupName AND
(${groupcheck_table}.HuntGroup = '%{request:Huntgroup-Name}' OR
${groupcheck_table}.HuntGroup IS NULL) ORDER BY ${groupcheck_table}.id"
authorize_group_reply_query =
"SELECT ${groupreply_table}.id,${groupreply_table}.GroupName,
${groupreply_table}.Attribute,${groupreply_table}.Value,
${groupreply_table}.op FROM ${groupreply_table},${usergroup_table}
WHERE ${usergroup_table}.Username = trim('%{SQL-User-Name}') AND
${usergroup_table}.GroupName = ${groupreply_table}.GroupName AND
(${groupreply_table}.HuntGroup = '%{request:Huntgroup-Name}' OR
${groupreply_table}.HuntGroup IS NULL) ORDER BY ${groupreply_table}.id"
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
