UPGRADE
author "martin f. krafft" <madduck@debian.org>
Tue, 07 Aug 2012 21:54:39 +0000
changeset 583 a479c38931c4
parent 566 007786e58fb7
child 624 e1fc4a3075de
permissions -rw-r--r--
If an alias has multiple destinations, multiple records exist, due to the nature of the database. address_list would then return the same alias multiple times, which does not add any information, eats screen space and is potentially confusing. Therefore, we SELECT DISTINCTly from the alias table. Signed-off-by: martin f. krafft <madduck@debian.org> --- VirtualMailManager/common.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
566
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
     1
If you still have installed vmm 0.4.x you have to proceed this step first:
42
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
     2
566
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
     3
    * upgrade your vmm installation to version 0.5.2
42
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
     4
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
     5
566
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
     6
If you have installed vmm 0.5.2 you have to proceed this steps:
38
c44ea4526546 * 'VirtualMailManager/Alias.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     7
42
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
     8
    * stop Postfix and Dovecot
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
     9
    * backup/dump your database.
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
    10
    * backup/dump your database!
128
cf8116625866 Converted VirtualMailManager and Postconf to new-style classes.
Pascal Volk <neverseen@users.sourceforge.net>
parents: 127
diff changeset
    11
127
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    12
    * start psql and connect to the appropriate database
566
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    13
      (ex. psql mailsys vmm -W -h 127.0.0.1)
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    14
    * update the database,
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    15
      - Dovecot < 1.2.0
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    16
	\i vmm-x.y.z/pgsql/update_tables_0.5.x-0.6.pgsql
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    17
      - Dovecot >= 1.2.0, 2.0.0 and 2.1.0
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    18
	\i vmm-x.y.z/pgsql/update_tables_0.5.x-0.6-dovecot-1.2.x.pgsql
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    19
    * Set database permissions.
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    20
      (see python set-permissions.py -h for details)
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    21
      python vmm-x.y.z/pgsql/set-permissions.py -a -H 127.0.0.1 -U vmm
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    22
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    23
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    24
    /!\ Important note /!\
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    25
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    26
    All the views (dovecot_* and postfix_*) have been replaced by database
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    27
    functions. So you have to adjust all your postfix/pgsql-*.cf files and
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    28
    also your /etc/dovecot/dovecot-sql.conf or
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    29
    /etc/dovecot/dovecot-sql.conf.ext.
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    30
    (See the vmm-x.y.z postfix/pgsql-*.cf files and INSTALL/Configure.Dovecot_2
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    31
    files for the new query.)
42
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
    32
127
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    33
566
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    34
    * execute upgrade.sh
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    35
      This will also upgrade your vmm.cfg and apply the following modifications:
127
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    36
566
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    37
	     old			     new
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    38
	------------------------------------------------------------
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    39
	domdir.mode		->	domain.directory_mode
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    40
	domdir.delete		->	domain.delete_directory
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    41
	domdir.base		->	misc.base_directory
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    42
	domdir			->	_section domdir deleted_
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    43
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    44
	maildir.mode		->	account.directory_mode
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    45
	maildir.diskusage	->	account.disk_usage
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    46
	maildir.delete		->	account.delete_directory
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    47
	maildir.folders		->	mailbox.folders
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    48
	maildir.name		->	mailbox.root
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    49
	maildir			->	_section maildir deleted_
127
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    50
566
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    51
	misc.forcedel		->	domain.force_deletion
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    52
	misc.transport		->	domain.transport
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    53
	misc.passwdscheme	->	misc.password_scheme
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    54
	misc.dovecotvers	->	misc.dovecot_version (12 -> 1.2.11)
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    55
	misc.gid_mail		->	/dev/null
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    56
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    57
	services.smtp		->	domain.smtp
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    58
	services.pop3		->	domain.pop3
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    59
	services.imap		->	domain.imap
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    60
	services.sieve		->	domain.sieve
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    61
	services		->	_section services deleted_
127
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    62
566
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    63
	_NEW_.random_password	->	account.random_password
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    64
	_NEW_.password_length	->	account.password_length
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    65
	_NEW_.auto_postmaster	->	domain.auto_postmaster
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    66
	_NEW_.quota_bytes	->	domain.quota_bytes
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    67
	_NEW_.quota_messages	->	domain.quota_messages
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    68
	_NEW_.module		->	database.module
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    69
	_NEW_.port		->	database.port
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    70
	_NEW_.sslmode		->	database.sslmode
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    71
	_NEW_.format		->	mailbox.format
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    72
	_NEW_.crypt_blowfish_rounds ->	misc.crypt_blowfish_rounds
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    73
	_NEW_.crypt_sha256_rounds   ->	misc.crypt_sha256_rounds
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    74
	_NEW_.crypt_sha512_rounds   ->	misc.crypt_sha512_rounds
131
2b8154cc7ebe Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 128
diff changeset
    75
566
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    76
	config.done             ->	/dev/null
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    77
	config                  ->	_section config deleted_
42
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
    78
38
c44ea4526546 * 'VirtualMailManager/Alias.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
    79
566
007786e58fb7 UPGRADE: Updated documentation.
Pascal Volk <user@localhost.localdomain.org>
parents: 271
diff changeset
    80
    * start Dovecot and Postfix again
127
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    81
106
dc98cc162c66 Released vmm-0.5.1
Pascal Volk <neverseen@users.sourceforge.net>
parents: 67
diff changeset
    82
38
c44ea4526546 * 'VirtualMailManager/Alias.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
    83
else
c44ea4526546 * 'VirtualMailManager/Alias.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
    84
     * read INSTALL