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
|