[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