UPGRADE
author martin f. krafft <madduck@madduck.net>
Sat, 07 Apr 2012 00:45:57 +0200
branchv0.6.x
changeset 492 e5c2b3647971
parent 271 e915d4725706
child 566 007786e58fb7
permissions -rw-r--r--
Modify address check query to obtain well-defined result The way in which UNION does not yield the desired result, because (a) UNION merges results and (b) the result order is undefined. This patch changes the query to select the counts as columns and hence provides a well-defined order.

If you still have installed vmm 0.3.x you have to proceed this step first:

    * upgrade your vmm installation to version 0.4-r41


If you have installed vmm 0.4/0.4-r41 you have to proceed this steps:

    * stop Postfix and Dovecot
    * backup/dump your database.
    * backup/dump your database!

    * start psql and connect to the appropriate database
      (ex. psql mailsys mailsys vmm -W -h localhost)
    * update the database: \i update_tables_0.4.x-0.5.pgsql
    * GRANT SELECT ON postfix_alias TO postfix;
                                       ^^^^^^^^ <- your Postfix db user


  Dovecot v1.2.x
    -> Are you already using Dovecot v1.2.x?
       * update the database for Dovecot v1.2.x:
         \i update_tables_0.5.x_for_dovecot-1.2.x.pgsql
       * GRANT SELECT ON dovecot_password TO dovecot;
                                             ^^^^^^^^ <- your Dovecot db user

       * When you are using the SQL function »dovecotpassword()« in your
         dovecot-sql.conf, update it also:
         \i update_types_and_functions_0.5.x_for_dovecot-1.2.x.pgsql

       * You have also to adjust the permissions of the set-uid deliver copy:
         on BSD:
           chgrp nobody /usr/local/lib/dovecot/deliver
         on Linux:
           chgrp nogroup /usr/local/lib/dovecot/deliver
         chmod u+s,o-rwx /usr/local/lib/dovecot/deliver

       * Check the master.cf from Postfix.
         In prior setups the service dovecot was configured slightly different.
         If you have set the command attribute 'user' to 'nobody:mail', so
         either remove the group mail or replace it with the group nobody
         or nogroup. (see command output from: id -ng nobody)

         e.g.: flags=DRhu user=nobody argv=/usr/local/lib/dovecot/deliver 

    * execute upgrade.sh

    * start Dovecot and Postfix



If you have installed vmm 0.5.x:

    * execute upgrade.sh

    -> Are you already using Dovecot v1.2.x?
       See a few lines above.


else
     * read INSTALL