1 If you have installed vmm 0.3.x you have to proceed this steps: |
1 If you have installed vmm 0.3.x you have to proceed this steps: |
2 |
2 |
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 update_0.3.x-0.4.sh |
6 * execute upgrade.sh |
|
7 * set permissions for replaced views: |
|
8 GRANT SELECT ON dovecot_user TO your_dovecot_dbuser; |
|
9 GRANT SELECT ON postfix_transport TO your_postfix_dbuser; |
|
10 * update user_query in /etc/dovecot/dovecot-sql.conf: |
|
11 user_query = \ |
|
12 SELECT home, uid, gid, mail FROM dovecot_user WHERE userid='%u' |
7 * edit the pgsql parameters hosts, user, password and dbname in: |
13 * edit the pgsql parameters hosts, user, password and dbname in: |
8 $(postconf -h config_directory)/pgsql-smtpd_sender_login_maps.cf |
14 $(postconf -h config_directory)/pgsql-smtpd_sender_login_maps.cf |
9 $(postconf -h config_directory)/pgsql-transport.cf |
15 $(postconf -h config_directory)/pgsql-transport.cf |
10 $(postconf -h config_directory)/pgsql-virtual_mailbox_domains.cf |
16 $(postconf -h config_directory)/pgsql-virtual_mailbox_domains.cf |
11 * check the value of option transport in section misc in |
17 * check the value of option transport in section misc in |