[dovecot-cvs] dovecot/doc dovecot-sql.conf,1.11,1.12

tss at dovecot.org tss at dovecot.org
Sun Feb 4 22:13:45 UTC 2007


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

Modified Files:
	dovecot-sql.conf 
Log Message:
Added an example of how to concat() user and domain.



Index: dovecot-sql.conf
===================================================================
RCS file: /var/lib/cvs/dovecot/doc/dovecot-sql.conf,v
retrieving revision 1.11
retrieving revision 1.12
diff -u -d -r1.11 -r1.12
--- dovecot-sql.conf	5 Nov 2006 16:39:00 -0000	1.11
+++ dovecot-sql.conf	4 Feb 2007 22:13:43 -0000	1.12
@@ -83,7 +83,7 @@
 # difficult to have eg. usernames containing '%' characters.
 #
 # Example:
-#   password_query = SELECT password FROM users WHERE userid = '%n' AND domain = '%d'
+#   password_query = SELECT concat(userid, '@', domain) AS user, 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 userid as user, password FROM users WHERE userid = '%u'



More information about the dovecot-cvs mailing list