diff -r bf9a03c476fc -r 55146c78b3fb UPGRADE --- 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