|      1 If you still have installed vmm 0.3.x you have to proceed this step first: |      1 If you still have installed vmm 0.4.x you have to proceed this step first: | 
|      2  |      2  | 
|      3     * upgrade your vmm installation to version 0.4-r41 |      3     * upgrade your vmm installation to version 0.5.2 | 
|      4  |      4  | 
|      5  |      5  | 
|      6 If you have installed vmm 0.4/0.4-r41 you have to proceed this steps: |      6 If you have installed vmm 0.5.2 you have to proceed this steps: | 
|      7  |      7  | 
|      8     * stop Postfix and Dovecot |      8     * stop Postfix and Dovecot | 
|      9     * backup/dump your database. |      9     * backup/dump your database. | 
|     10     * backup/dump your database! |     10     * backup/dump your database! | 
|     11  |     11  | 
|     12     * start psql and connect to the appropriate database |     12     * start psql and connect to the appropriate database | 
|     13       (ex. psql mailsys mailsys vmm -W -h localhost) |     13       (ex. psql mailsys vmm -W -h 127.0.0.1) | 
|     14     * update the database: \i update_tables_0.4.x-0.5.pgsql |     14     * update the database, | 
|     15     * GRANT SELECT ON postfix_alias TO postfix; |     15       - Dovecot < 1.2.0 | 
|     16                                        ^^^^^^^^ <- your Postfix db user |     16 	\i vmm-x.y.z/pgsql/update_tables_0.5.x-0.6.pgsql | 
|         |     17       - Dovecot >= 1.2.0, 2.0.0 and 2.1.0 | 
|         |     18 	\i vmm-x.y.z/pgsql/update_tables_0.5.x-0.6-dovecot-1.2.x.pgsql | 
|         |     19     * Set database permissions. | 
|         |     20       (see python set-permissions.py -h for details) | 
|         |     21       python vmm-x.y.z/pgsql/set-permissions.py -a -H 127.0.0.1 -U vmm | 
|     17  |     22  | 
|     18  |     23  | 
|     19   Dovecot v1.2.x |     24     /!\ Important note /!\ | 
|     20     -> Are you already using Dovecot v1.2.x? |         | 
|     21        * update the database for Dovecot v1.2.x: |         | 
|     22          \i update_tables_0.5.x_for_dovecot-1.2.x.pgsql |         | 
|     23        * GRANT SELECT ON dovecot_password TO dovecot; |         | 
|     24                                              ^^^^^^^^ <- your Dovecot db user |         | 
|     25  |     25  | 
|     26        * When you are using the SQL function »dovecotpassword()« in your |     26     All the views (dovecot_* and postfix_*) have been replaced by database | 
|     27          dovecot-sql.conf, update it also: |     27     functions. So you have to adjust all your postfix/pgsql-*.cf files and | 
|     28          \i update_types_and_functions_0.5.x_for_dovecot-1.2.x.pgsql |     28     also your /etc/dovecot/dovecot-sql.conf or | 
|         |     29     /etc/dovecot/dovecot-sql.conf.ext. | 
|         |     30     (See the vmm-x.y.z postfix/pgsql-*.cf files and INSTALL/Configure.Dovecot_2 | 
|         |     31     files for the new query.) | 
|     29  |     32  | 
|     30        * You have also to adjust the permissions of the set-uid deliver copy: |         | 
|     31          on BSD: |         | 
|     32            chgrp nobody /usr/local/lib/dovecot/deliver |         | 
|     33          on Linux: |         | 
|     34            chgrp nogroup /usr/local/lib/dovecot/deliver |         | 
|     35          chmod u+s,o-rwx /usr/local/lib/dovecot/deliver |         | 
|     36  |         | 
|     37        * Check the master.cf from Postfix. |         | 
|     38          In prior setups the service dovecot was configured slightly different. |         | 
|     39          If you have set the command attribute 'user' to 'nobody:mail', so |         | 
|     40          either remove the group mail or replace it with the group nobody |         | 
|     41          or nogroup. |         | 
|     42  |         | 
|     43          e.g.: flags=DRhu user=nobody argv=/usr/local/lib/dovecot/deliver … |         | 
|     44  |     33  | 
|     45     * execute upgrade.sh |     34     * execute upgrade.sh | 
|         |     35       This will also upgrade your vmm.cfg and apply the following modifications: | 
|     46  |     36  | 
|     47     * start Dovecot and Postfix |     37 	     old			     new | 
|         |     38 	------------------------------------------------------------ | 
|         |     39 	domdir.mode		->	domain.directory_mode | 
|         |     40 	domdir.delete		->	domain.delete_directory | 
|         |     41 	domdir.base		->	misc.base_directory | 
|         |     42 	domdir			->	_section domdir deleted_ | 
|         |     43  | 
|         |     44 	maildir.mode		->	account.directory_mode | 
|         |     45 	maildir.diskusage	->	account.disk_usage | 
|         |     46 	maildir.delete		->	account.delete_directory | 
|         |     47 	maildir.folders		->	mailbox.folders | 
|         |     48 	maildir.name		->	mailbox.root | 
|         |     49 	maildir			->	_section maildir deleted_ | 
|         |     50  | 
|         |     51 	misc.forcedel		->	domain.force_deletion | 
|         |     52 	misc.transport		->	domain.transport | 
|         |     53 	misc.passwdscheme	->	misc.password_scheme | 
|         |     54 	misc.dovecotvers	->	misc.dovecot_version (12 -> 1.2.11) | 
|         |     55 	misc.gid_mail		->	/dev/null | 
|         |     56  | 
|         |     57 	services.smtp		->	domain.smtp | 
|         |     58 	services.pop3		->	domain.pop3 | 
|         |     59 	services.imap		->	domain.imap | 
|         |     60 	services.sieve		->	domain.sieve | 
|         |     61 	services		->	_section services deleted_ | 
|         |     62  | 
|         |     63 	_NEW_.random_password	->	account.random_password | 
|         |     64 	_NEW_.password_length	->	account.password_length | 
|         |     65 	_NEW_.auto_postmaster	->	domain.auto_postmaster | 
|         |     66 	_NEW_.quota_bytes	->	domain.quota_bytes | 
|         |     67 	_NEW_.quota_messages	->	domain.quota_messages | 
|         |     68 	_NEW_.module		->	database.module | 
|         |     69 	_NEW_.port		->	database.port | 
|         |     70 	_NEW_.sslmode		->	database.sslmode | 
|         |     71 	_NEW_.format		->	mailbox.format | 
|         |     72 	_NEW_.crypt_blowfish_rounds ->	misc.crypt_blowfish_rounds | 
|         |     73 	_NEW_.crypt_sha256_rounds   ->	misc.crypt_sha256_rounds | 
|         |     74 	_NEW_.crypt_sha512_rounds   ->	misc.crypt_sha512_rounds | 
|         |     75  | 
|         |     76 	config.done             ->	/dev/null | 
|         |     77 	config                  ->	_section config deleted_ | 
|     48  |     78  | 
|     49  |     79  | 
|     50  |     80     * start Dovecot and Postfix again | 
|     51 If you have installed vmm 0.5.x: |         | 
|     52  |         | 
|     53     * execute upgrade.sh |         | 
|     54  |         | 
|     55     -> Are you already using Dovecot v1.2.x? |         | 
|     56        See a few lines above. |         | 
|     57  |     81  | 
|     58  |     82  | 
|     59 else |     83 else | 
|     60      * read INSTALL |     84      * read INSTALL |