UPGRADE
changeset 20 55146c78b3fb
parent 15 1607f7b2dba9
child 21 6feb31787a66
--- a/UPGRADE	Fri Apr 18 03:46:11 2008 +0000
+++ b/UPGRADE	Mon Apr 21 04:56:01 2008 +0000
@@ -5,11 +5,14 @@
     * backup/dump your database!
     * execute upgrade.sh
     * set permissions for replaced views:
-        GRANT SELECT ON dovecot_user TO your_dovecot_dbuser;
+        GRANT SELECT ON dovecot_user, dovecot_password TO your_dovecot_dbuser;
         GRANT SELECT ON postfix_transport TO your_postfix_dbuser;
     * update user_query in /etc/dovecot/dovecot-sql.conf:
         user_query = \
-            SELECT home, uid, gid, mail FROM dovecot_user WHERE userid='%u'
+         SELECT home, uid, gid, mail FROM dovecot_user WHERE userid='%u'
+    * update password_query in /etc/dovecot/dovecot-sql.conf:
+        password_query = \
+         SELECT "user", password FROM dovecot_password WHERE "user"='%u' AND %Ls
     * edit the pgsql parameters hosts, user, password and dbname in:
         $(postconf -h config_directory)/pgsql-smtpd_sender_login_maps.cf
         $(postconf -h config_directory)/pgsql-transport.cf