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  |