3 * stop Postfix and Dovecot |
3 * stop Postfix and Dovecot |
4 * backup/dump your database. |
4 * backup/dump your database. |
5 * backup/dump your database! |
5 * backup/dump your database! |
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 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, mail FROM dovecot_user WHERE userid='%u' |
|
13 * update password_query in /etc/dovecot/dovecot-sql.conf: |
|
14 password_query = \ |
|
15 SELECT "user", password FROM dovecot_password WHERE "user"='%u' AND %Ls |
13 * edit the pgsql parameters hosts, user, password and dbname in: |
16 * edit the pgsql parameters hosts, user, password and dbname in: |
14 $(postconf -h config_directory)/pgsql-smtpd_sender_login_maps.cf |
17 $(postconf -h config_directory)/pgsql-smtpd_sender_login_maps.cf |
15 $(postconf -h config_directory)/pgsql-transport.cf |
18 $(postconf -h config_directory)/pgsql-transport.cf |
16 $(postconf -h config_directory)/pgsql-virtual_mailbox_domains.cf |
19 $(postconf -h config_directory)/pgsql-virtual_mailbox_domains.cf |
17 * check the value of option transport in section misc in |
20 * check the value of option transport in section misc in |