INSTALL
changeset 16 3388b96fd3ed
parent 15 1607f7b2dba9
child 20 55146c78b3fb
--- a/INSTALL	Thu Apr 10 03:24:12 2008 +0000
+++ b/INSTALL	Mon Apr 14 02:21:46 2008 +0000
@@ -2,6 +2,8 @@
 You should already have installed and configured Postfix, Dovecot and
 PostgreSQL.
 You have to install Python and pyPgSQL* to use the Virtual Mail Manager.
+If you want to store the passwords as PLAIN-MD4 digest you have also to install
+python-crypto <http://www.amk.ca/python/code/crypto.html>.
 
 * = http://pypgsql.sourceforge.net/ (Debian: python-pgsql)
 
@@ -91,8 +93,8 @@
     driver = pgsql
     connect = host=localhost dbname=mailsys user=dovecot password=$Dovecot_PASS
     default_pass_scheme = HMAC-MD5
-    password_query = SELECT "user", password FROM dovecot_password WHERE "user"= '%u'
-    user_query = SELECT home, uid, gid, mail FROM dovecot_user WHERE userid='%u'
+    password_query = SELECT "user", password FROM dovecot_password WHERE "user"='%u'
+    user_query = SELECT home, uid, gid, 'maildir:'||mail AS mail FROM dovecot_user WHERE userid = '%u'
 
 Provide a root SETUID copy of Dovecot's deliver agent for Postfix