Subversion Repositories ALCASAR

Rev

Rev 2476 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log

Rev 2476 Rev 2706
Line 44... Line 44...
44
	# DEFAULT	Service-Type == Outbound-User, User-Profile := "outbound"
44
	# DEFAULT	Service-Type == Outbound-User, User-Profile := "outbound"
45
	# DEFAULT	Service-Type == Framed-User, User-Profile := "framed"
45
	# DEFAULT	Service-Type == Framed-User, User-Profile := "framed"
46
	#
46
	#
47
	# By default the default_user_profile is not set
47
	# By default the default_user_profile is not set
48
	#
48
	#
49
	default_user_profile = "ldap"
49
	#default_user_profile = "DEFAULT"
50
 
50
 
51
	#######################################################################
51
	#######################################################################
52
	#  NAS Query
52
	#  NAS Query
53
	#######################################################################
53
	#######################################################################
54
	#  This query retrieves the radius clients
54
	#  This query retrieves the radius clients
Line 97... Line 97...
97
#          FROM ${authreply_table} \
97
#          FROM ${authreply_table} \
98
#          WHERE username = '%{SQL-User-Name}' \
98
#          WHERE username = '%{SQL-User-Name}' \
99
#          ORDER BY id"
99
#          ORDER BY id"
100
 
100
 
101
	# Use these for case sensitive usernames.
101
	# Use these for case sensitive usernames.
102
	group_membership_query = "SELECT groupname \
102
#	group_membership_query = "SELECT groupname \
103
         FROM ${usergroup_table} \
103
#         FROM ${usergroup_table} \
104
         WHERE username = BINARY '%{SQL-User-Name}' \
104
#         WHERE username = BINARY '%{SQL-User-Name}' \
105
         ORDER BY priority"
105
#         ORDER BY priority"
106
 
106
 
107
#	group_membership_query = "SELECT groupname \
107
#	group_membership_query = "SELECT groupname \
108
#          FROM ${usergroup_table} \
108
#          FROM ${usergroup_table} \
109
#          WHERE username = '%{SQL-User-Name}' \
109
#          WHERE username = '%{SQL-User-Name}' \
110
#          ORDER BY priority"
110
#          ORDER BY priority"
111
 
111
 
-
 
112
	group_membership_query = "SELECT '%{SQL-User-Name}'"
-
 
113
 
112
	authorize_group_check_query = "SELECT id, groupname, attribute, \
114
#	authorize_group_check_query = "SELECT id, groupname, attribute, \
113
          Value, op \
115
#          Value, op \
114
          FROM ${groupcheck_table} \
116
#          FROM ${groupcheck_table} \
115
          WHERE groupname = '%{Sql-Group}' \
117
#          WHERE groupname = '%{Sql-Group}' \
116
          ORDER BY id"
118
#          ORDER BY id"
117
	authorize_group_reply_query = "SELECT id, groupname, attribute, \
119
#	authorize_group_reply_query = "SELECT id, groupname, attribute, \
118
          value, op \
120
#          value, op \
119
          FROM ${groupreply_table} \
121
#          FROM ${groupreply_table} \
120
          WHERE groupname = '%{Sql-Group}' \
122
#          WHERE groupname = '%{Sql-Group}' \
121
          ORDER BY id"
123
#          ORDER BY id"
-
 
124
	authorize_group_check_query = "SELECT id, '%{SQL-User-Name}', attribute, value, op FROM ( \
-
 
125
           ( SELECT id, attribute, value, op FROM ${groupcheck_table} gr LEFT JOIN radusergroup ug ON gr.groupname = ug.groupname WHERE username = '%{SQL-User-Name}' ORDER BY ug.priority) UNION \
-
 
126
           ( SELECT id, attribute, value, op FROM ${groupcheck_table} WHERE groupname = '%{control:Tmp-String-0}') UNION \
-
 
127
           ( SELECT id, attribute, value, op FROM ${groupcheck_table} WHERE groupname = 'default') \
-
 
128
         ) attrs GROUP BY attribute"
-
 
129
	authorize_group_reply_query = "SELECT id, '%{SQL-User-Name}', attribute, value, op FROM ( \
-
 
130
           ( SELECT id, attribute, value, op FROM ${groupreply_table} gr LEFT JOIN radusergroup ug ON gr.groupname = ug.groupname WHERE username = '%{SQL-User-Name}' ORDER BY ug.priority) UNION \
-
 
131
           ( SELECT id, attribute, value, op FROM ${groupreply_table} WHERE groupname = '%{control:Tmp-String-0}') UNION \
-
 
132
           ( SELECT id, attribute, value, op FROM ${groupreply_table} WHERE groupname = 'default') \
-
 
133
         ) attrs GROUP BY attribute"
122
 
134
 
123
	#######################################################################
135
	#######################################################################
124
	#  Accounting Queries
136
	#  Accounting Queries
125
	#######################################################################
137
	#######################################################################
126
	# accounting_onoff_query	- query for Accounting On/Off packets
138
	# accounting_onoff_query	- query for Accounting On/Off packets