UPGRADE
author "martin f. krafft" <madduck@debian.org>
Tue, 07 Aug 2012 21:53:41 +0000
changeset 582 605f8c115711
parent 566 007786e58fb7
child 624 e1fc4a3075de
permissions -rw-r--r--
Due to the UNION query in address_list, the assumption that the list of gids received from the database would be continuous does not hold. To prevent addresses for domains with multiple entry types from being listed, it is necessary to check the list of domain gids for every entry. Signed-off-by: martin f. krafft <madduck@debian.org> --- VirtualMailManager/common.py | 4 +--- 1 file changed, 1 insertion(+), 3 deletions(-)

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

    * upgrade your vmm installation to version 0.5.2


If you have installed vmm 0.5.2 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 vmm -W -h 127.0.0.1)
    * update the database,
      - Dovecot < 1.2.0
	\i vmm-x.y.z/pgsql/update_tables_0.5.x-0.6.pgsql
      - Dovecot >= 1.2.0, 2.0.0 and 2.1.0
	\i vmm-x.y.z/pgsql/update_tables_0.5.x-0.6-dovecot-1.2.x.pgsql
    * Set database permissions.
      (see python set-permissions.py -h for details)
      python vmm-x.y.z/pgsql/set-permissions.py -a -H 127.0.0.1 -U vmm


    /!\ Important note /!\

    All the views (dovecot_* and postfix_*) have been replaced by database
    functions. So you have to adjust all your postfix/pgsql-*.cf files and
    also your /etc/dovecot/dovecot-sql.conf or
    /etc/dovecot/dovecot-sql.conf.ext.
    (See the vmm-x.y.z postfix/pgsql-*.cf files and INSTALL/Configure.Dovecot_2
    files for the new query.)


    * execute upgrade.sh
      This will also upgrade your vmm.cfg and apply the following modifications:

	     old			     new
	------------------------------------------------------------
	domdir.mode		->	domain.directory_mode
	domdir.delete		->	domain.delete_directory
	domdir.base		->	misc.base_directory
	domdir			->	_section domdir deleted_

	maildir.mode		->	account.directory_mode
	maildir.diskusage	->	account.disk_usage
	maildir.delete		->	account.delete_directory
	maildir.folders		->	mailbox.folders
	maildir.name		->	mailbox.root
	maildir			->	_section maildir deleted_

	misc.forcedel		->	domain.force_deletion
	misc.transport		->	domain.transport
	misc.passwdscheme	->	misc.password_scheme
	misc.dovecotvers	->	misc.dovecot_version (12 -> 1.2.11)
	misc.gid_mail		->	/dev/null

	services.smtp		->	domain.smtp
	services.pop3		->	domain.pop3
	services.imap		->	domain.imap
	services.sieve		->	domain.sieve
	services		->	_section services deleted_

	_NEW_.random_password	->	account.random_password
	_NEW_.password_length	->	account.password_length
	_NEW_.auto_postmaster	->	domain.auto_postmaster
	_NEW_.quota_bytes	->	domain.quota_bytes
	_NEW_.quota_messages	->	domain.quota_messages
	_NEW_.module		->	database.module
	_NEW_.port		->	database.port
	_NEW_.sslmode		->	database.sslmode
	_NEW_.format		->	mailbox.format
	_NEW_.crypt_blowfish_rounds ->	misc.crypt_blowfish_rounds
	_NEW_.crypt_sha256_rounds   ->	misc.crypt_sha256_rounds
	_NEW_.crypt_sha512_rounds   ->	misc.crypt_sha512_rounds

	config.done             ->	/dev/null
	config                  ->	_section config deleted_


    * start Dovecot and Postfix again


else
     * read INSTALL