UPGRADE
author Pascal Volk <user@localhost.localdomain.org>
Mon, 01 Oct 2012 18:57:44 +0000
changeset 624 e1fc4a3075de
parent 566 007786e58fb7
child 707 19184d1265e5
permissions -rw-r--r--
UPGRADE: Added procedure for updating from v0.6.0.
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
624
e1fc4a3075de UPGRADE: Added procedure for updating from v0.6.0.
Pascal Volk <user@localhost.localdomain.org>
parents: 566
diff changeset
    83
If you have installed vmm 0.6.0 you have to proceed this steps:
e1fc4a3075de UPGRADE: Added procedure for updating from v0.6.0.
Pascal Volk <user@localhost.localdomain.org>
parents: 566
diff changeset
    84
e1fc4a3075de UPGRADE: Added procedure for updating from v0.6.0.
Pascal Volk <user@localhost.localdomain.org>
parents: 566
diff changeset
    85
    * Database fixes:
e1fc4a3075de UPGRADE: Added procedure for updating from v0.6.0.
Pascal Volk <user@localhost.localdomain.org>
parents: 566
diff changeset
    86
	- Due to an error in usertransport's argument parsing, it is
e1fc4a3075de UPGRADE: Added procedure for updating from v0.6.0.
Pascal Volk <user@localhost.localdomain.org>
parents: 566
diff changeset
    87
	  possible that some users' transport-ID points to the erroneous
e1fc4a3075de UPGRADE: Added procedure for updating from v0.6.0.
Pascal Volk <user@localhost.localdomain.org>
parents: 566
diff changeset
    88
	  transport 'domain'. To fix that error in your database, execute
e1fc4a3075de UPGRADE: Added procedure for updating from v0.6.0.
Pascal Volk <user@localhost.localdomain.org>
parents: 566
diff changeset
    89
	  the following SQL statement:
e1fc4a3075de UPGRADE: Added procedure for updating from v0.6.0.
Pascal Volk <user@localhost.localdomain.org>
parents: 566
diff changeset
    90
e1fc4a3075de UPGRADE: Added procedure for updating from v0.6.0.
Pascal Volk <user@localhost.localdomain.org>
parents: 566
diff changeset
    91
	   UPDATE users SET tid = NULL
e1fc4a3075de UPGRADE: Added procedure for updating from v0.6.0.
Pascal Volk <user@localhost.localdomain.org>
parents: 566
diff changeset
    92
   	    WHERE tid = (SELECT tid FROM transport WHERE transport = 'domain');
e1fc4a3075de UPGRADE: Added procedure for updating from v0.6.0.
Pascal Volk <user@localhost.localdomain.org>
parents: 566
diff changeset
    93
e1fc4a3075de UPGRADE: Added procedure for updating from v0.6.0.
Pascal Volk <user@localhost.localdomain.org>
parents: 566
diff changeset
    94
	- If you are using Dovecot < v1.2.0:
e1fc4a3075de UPGRADE: Added procedure for updating from v0.6.0.
Pascal Volk <user@localhost.localdomain.org>
parents: 566
diff changeset
    95
	  You have to replace the database FUNCTION dovecotpassword().
e1fc4a3075de UPGRADE: Added procedure for updating from v0.6.0.
Pascal Volk <user@localhost.localdomain.org>
parents: 566
diff changeset
    96
	  (see file: pgsql/create_tables.pgsql)
e1fc4a3075de UPGRADE: Added procedure for updating from v0.6.0.
Pascal Volk <user@localhost.localdomain.org>
parents: 566
diff changeset
    97
	  The service_set.ssid was selected unconditionally. This may cause
e1fc4a3075de UPGRADE: Added procedure for updating from v0.6.0.
Pascal Volk <user@localhost.localdomain.org>
parents: 566
diff changeset
    98
	  an empty result, which will make logins impossible.
e1fc4a3075de UPGRADE: Added procedure for updating from v0.6.0.
Pascal Volk <user@localhost.localdomain.org>
parents: 566
diff changeset
    99
e1fc4a3075de UPGRADE: Added procedure for updating from v0.6.0.
Pascal Volk <user@localhost.localdomain.org>
parents: 566
diff changeset
   100
    * execute upgrade.sh
e1fc4a3075de UPGRADE: Added procedure for updating from v0.6.0.
Pascal Volk <user@localhost.localdomain.org>
parents: 566
diff changeset
   101
38
c44ea4526546 * 'VirtualMailManager/Alias.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
   102
else
c44ea4526546 * 'VirtualMailManager/Alias.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
   103
     * read INSTALL