[dovecot-cvs] dovecot/doc dovecot-sql.conf,1.9.2.2,1.9.2.3

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


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

Modified Files:
      Tag: branch_1_0
	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.9.2.2
retrieving revision 1.9.2.3
diff -u -d -r1.9.2.2 -r1.9.2.3
--- dovecot-sql.conf	5 Nov 2006 16:38:58 -0000	1.9.2.2
+++ dovecot-sql.conf	4 Feb 2007 22:13:41 -0000	1.9.2.3
@@ -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