--- 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