1 If you have installed vmm 0.3.x you have to proceed this steps:

     2 

     3     * stop Postfix and Dovecot

     4     * backup/dump your database.

     5     * backup/dump your database!

     6     * execute upgrade.sh

     7     * set permissions for replaced views:

     8         GRANT SELECT ON dovecot_user, dovecot_password 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, 'maildir:'||mail AS 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

    16     * edit the pgsql parameters hosts, user, password and dbname in:

    17         $(postconf -h config_directory)/pgsql-smtpd_sender_login_maps.cf

    18         $(postconf -h config_directory)/pgsql-transport.cf

    19         $(postconf -h config_directory)/pgsql-virtual_mailbox_domains.cf

    20     * check the value of option transport in section misc in

    21       /usr/local/etc/vmm.cfg

    22     * start Dovecot and Postfix

    23 

    24 else:

    25 

    26     * read INSTALL