← Back to branch summary

~ubuntu-branches/ubuntu/natty/freeradius/natty-updates

« back to all changes in this revision

Viewing changes to raddb/sql.conf

  • Committer: Bazaar Package Importer
  • Author(s): Paul Hampson
  • Date: 2006-01-15 13:34:13 UTC
  • mto: (3.1.3 dapper) (4.1.3 sid) (1.1.14 upstream)
  • mto: This revision was merged to the branch mainline in revision 4.
  • Revision ID: james.westby@ubuntu.com-20060115133413-zo1dslttvdoalqym
Tags: upstream-1.1.0
Import upstream version 1.1.0

Show diffs side-by-side

added added

removed removed

Lines of Context:
raddb/sql.conf
9
9
#  If you are using Oracle, please use 'oracle.conf', instead.
10
10
#  If you are using MS-SQL, please use 'mssql.conf', instead.
11
11
#
12
 
#       $Id: sql.conf,v 1.41.2.2 2005/08/24 17:02:04 nbk Exp $
 
12
#       $Id: sql.conf,v 1.41.2.2.2.1 2005/12/09 14:47:03 nbk Exp $
13
13
#
14
14
sql {
15
15
        # Database type
126
126
        #  3. Item Attr Value
127
127
        #  4. Item Attr Operation
128
128
        #######################################################################
129
 
        # Use these for case insensitive usernames. WARNING: Slower queries!
 
129
        # Use these for case sensitive usernames.
130
130
#       authorize_check_query = "SELECT id, UserName, Attribute, Value, op \
131
131
#         FROM ${authcheck_table} \
132
 
#         WHERE LOWER(Username) = LOWER('%{SQL-User-Name}') \
 
132
#         WHERE Username = BINARY '%{SQL-User-Name}' \
133
133
#         ORDER BY id"
134
134
#       authorize_reply_query = "SELECT id, UserName, Attribute, Value, op \
135
135
#         FROM ${authreply_table} \
136
 
#         WHERE LOWER(Username) = LOWER('%{SQL-User-Name}') \
 
136
#         WHERE Username = BINARY '%{SQL-User-Name}' \
137
137
#         ORDER BY id"
138
138
 
 
139
        # The default queries are case insensitive. (for compatibility with
 
140
        # older versions of FreeRADIUS)
139
141
        authorize_check_query = "SELECT id, UserName, Attribute, Value, op \
140
142
          FROM ${authcheck_table} \
141
143
          WHERE Username = '%{SQL-User-Name}' \
145
147
          WHERE Username = '%{SQL-User-Name}' \
146
148
          ORDER BY id"
147
149
 
148
 
        # Use these for case insensitive usernames. WARNING: Slower queries!
149
 
#       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 LOWER(${usergroup_table}.Username) = LOWER('%{SQL-User-Name}') AND ${usergroup_table}.GroupName = ${groupcheck_table}.GroupName ORDER BY ${groupcheck_table}.id"
150
 
#       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 LOWER(${usergroup_table}.Username) = LOWER('%{SQL-User-Name}') AND ${usergroup_table}.GroupName = ${groupreply_table}.GroupName ORDER BY ${groupreply_table}.id"
 
150
        # Use these for case sensitive usernames.
 
151
#       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 = BINARY '%{SQL-User-Name}' AND ${usergroup_table}.GroupName = ${groupcheck_table}.GroupName ORDER BY ${groupcheck_table}.id"
 
152
#       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 = BINARY '%{SQL-User-Name}' AND ${usergroup_table}.GroupName = ${groupreply_table}.GroupName ORDER BY ${groupreply_table}.id"
151
153
 
152
154
        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"
153
155
        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"