[dovecot-cvs] dovecot/doc dovecot-sql.conf,1.4,1.5

[cras at dovecot.org]

Update of /var/lib/cvs/dovecot/doc
In directory talvi:/tmp/cvs-serv18954

Modified Files:
	dovecot-sql.conf 
Log Message:
Added information about "user" column.



Index: dovecot-sql.conf
===================================================================
RCS file: /var/lib/cvs/dovecot/doc/dovecot-sql.conf,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- dovecot-sql.conf	7 Jan 2005 14:07:13 -0000	1.4
+++ dovecot-sql.conf	2 Apr 2005 22:38:14 -0000	1.5
@@ -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.
 #