equal
deleted
inserted
replaced
6 * execute upgrade.sh |
6 * execute upgrade.sh |
7 * set permissions for replaced views: |
7 * set permissions for replaced views: |
8 GRANT SELECT ON dovecot_user, dovecot_password TO your_dovecot_dbuser; |
8 GRANT SELECT ON dovecot_user, dovecot_password TO your_dovecot_dbuser; |
9 GRANT SELECT ON postfix_transport TO your_postfix_dbuser; |
9 GRANT SELECT ON postfix_transport TO your_postfix_dbuser; |
10 * update user_query in /etc/dovecot/dovecot-sql.conf: |
10 * update user_query in /etc/dovecot/dovecot-sql.conf: |
11 user_query = \ |
11 * user_query = \ |
12 SELECT home, uid, gid, mail FROM dovecot_user WHERE userid='%u' |
12 SELECT home, uid, gid, 'maildir:'||mail AS mail FROM dovecot_user WHERE userid = '%u' |
13 * update password_query in /etc/dovecot/dovecot-sql.conf: |
13 * update password_query in /etc/dovecot/dovecot-sql.conf: |
14 password_query = \ |
14 password_query = \ |
15 SELECT "user", password FROM dovecot_password WHERE "user"='%u' AND %Ls |
15 SELECT "user", password FROM dovecot_password WHERE "user"='%u' AND %Ls |
16 * edit the pgsql parameters hosts, user, password and dbname in: |
16 * edit the pgsql parameters hosts, user, password and dbname in: |
17 $(postconf -h config_directory)/pgsql-smtpd_sender_login_maps.cf |
17 $(postconf -h config_directory)/pgsql-smtpd_sender_login_maps.cf |