From: Alan T. DeKok <aland@freeradius.org>
Date: Thu, 11 Nov 2010 08:37:04 +0000 (+0100)
Subject: Add group membership query
X-Git-Tag: release_3_0_0_beta0~1170
X-Git-Url: http://www.project-moonshot.org/gitweb/?p=freeradius.git;a=commitdiff_plain;h=20acc86c988f79f4e65fbc9caaf12f0772b081f5

Add group membership query

Closes bug #120
---

diff --git a/raddb/sql/mssql/dialup.conf b/raddb/sql/mssql/dialup.conf
index 313fc51..0d824c0 100644
--- a/raddb/sql/mssql/dialup.conf
+++ b/raddb/sql/mssql/dialup.conf
@@ -51,6 +51,10 @@
 	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 = '%{SQL-User-Name}' AND ${usergroup_table}.GroupName = ${groupcheck_table}.GroupName 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 = '%{SQL-User-Name}' AND ${usergroup_table}.GroupName = ${groupreply_table}.GroupName ORDER BY ${groupreply_table}.id"
 
+	group_membership_query = "SELECT groupname \
+          FROM ${usergroup_table} \
+          WHERE username = '%{SQL-User-Name}' \
+          ORDER BY priority"
 
 	#######################################################################
 	#  Accounting Queries