Mercurial > dovecot > original-hg > dovecot-1.2
changeset 3258:4fb1a08bfa11 HEAD
Added information about "user" column.
author | Timo Sirainen <tss@iki.fi> |
---|---|
date | Sun, 03 Apr 2005 01:38:14 +0300 |
parents | 92c16e82b806 |
children | 9ea318f232e0 |
files | doc/dovecot-sql.conf |
diffstat | 1 files changed, 5 insertions(+), 4 deletions(-) [+] |
line wrap: on
line diff
--- a/doc/dovecot-sql.conf Sun Apr 03 01:00:49 2005 +0300 +++ b/doc/dovecot-sql.conf Sun Apr 03 01:38:14 2005 +0300 @@ -56,9 +56,10 @@ # Query to retrieve the password. # -# This query must return only one row with "password" column. The query can -# also return other fields which have a special meaning, see -# http://wiki.dovecot.org/AuthSpecials +# This query must return only one row with "user" and "password" columns. The +# "user" column is needed to make sure the username gets used with exactly the +# same casing as it's in database. The query can also return other fields +# which have a special meaning, see http://wiki.dovecot.org/AuthSpecials # # Available substitutions: # %u = entire userid @@ -69,7 +70,7 @@ # password_query = SELECT password FROM users WHERE userid = '%n' AND domain = '%d' # password_query = SELECT pw AS password FROM users WHERE userid = '%u' AND active = 'Y' # -#password_query = SELECT password FROM users WHERE userid = '%u' +#password_query = SELECT userid as user, password FROM users WHERE userid = '%u' # Query to retrieve the user information. #