Lines Matching refs:auth

3  * This is an example configuration for the mysql auth module.
26 $conf['auth']['mysql']['server']   = '';
27 $conf['auth']['mysql']['user']     = '';
28 $conf['auth']['mysql']['password'] = '';
29 $conf['auth']['mysql']['database'] = '';
34 $conf['auth']['mysql']['debug'] = 0;
41 $conf['auth']['mysql']['forwardClearPass'] = 0;
48 $conf['auth']['mysql']['TablesToLock']= array("users", "users AS u","groups", "groups AS g", "userg…
66 $conf['auth']['mysql']['checkPass']   = "SELECT pass
85 $conf['auth']['mysql']['getUserInfo'] = "SELECT pass, CONCAT(firstname,' ',lastname) AS name, email…
97 $conf['auth']['mysql']['getGroups']   = "SELECT name as `group`
121 $conf['auth']['mysql']['getUsers']    = "SELECT DISTINCT login AS user
125 $conf['auth']['mysql']['FilterLogin'] = "login LIKE '%{user}'";
126 $conf['auth']['mysql']['FilterName']  = "CONCAT(firstname,' ',lastname) LIKE '%{name}'";
127 $conf['auth']['mysql']['FilterEmail'] = "email LIKE '%{email}'";
128 $conf['auth']['mysql']['FilterGroup'] = "name LIKE '%{group}'";
129 $conf['auth']['mysql']['SortOrder']   = "ORDER BY login";
144 $conf['auth']['mysql']['addUser']     = "INSERT INTO users
154 $conf['auth']['mysql']['addGroup']    = "INSERT INTO groups (name)
165 $conf['auth']['mysql']['addUserGroup']= "INSERT INTO usergroup (uid, gid)
173 $conf['auth']['mysql']['delGroup']    = "DELETE FROM groups
182 $conf['auth']['mysql']['getUserID']   = "SELECT uid AS id
195 $conf['auth']['mysql']['delUser']     = "DELETE FROM users
203 $conf['auth']['mysql']['delUserRefs'] = "DELETE FROM usergroup
221 $conf['auth']['mysql']['updateUser']  = "UPDATE users SET";
222 $conf['auth']['mysql']['UpdateLogin'] = "login='%{user}'";
223 $conf['auth']['mysql']['UpdatePass']  = "pass='%{pass}'";
224 $conf['auth']['mysql']['UpdateEmail'] = "email='%{email}'";
225 $conf['auth']['mysql']['UpdateName']  = "firstname=SUBSTRING_INDEX('%{name}',' ', 1),
227 $conf['auth']['mysql']['UpdateTarget']= "WHERE uid=%{uid}";
238 $conf['auth']['mysql']['delUserGroup']= "DELETE FROM usergroup
249 $conf['auth']['mysql']['getGroupID']  = "SELECT gid AS id