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