| author | Pascal Volk <user@localhost.localdomain.org> | 
| Mon, 17 Feb 2014 23:19:01 +0000 | |
| branch | v0.7.x | 
| changeset 734 | 8167ba72235c | 
| parent 707 | 19184d1265e5 | 
| permissions | -rw-r--r-- | 
| 566 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
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: 
38diff
changeset | 2 | |
| 566 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 3 |     * upgrade your vmm installation to version 0.5.2 | 
| 42 
9d10877e1c10
* 'create_tables.pgsql'
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
38diff
changeset | 4 | |
| 
9d10877e1c10
* 'create_tables.pgsql'
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
38diff
changeset | 5 | |
| 566 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
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: 
38diff
changeset | 8 |     * stop Postfix and Dovecot | 
| 
9d10877e1c10
* 'create_tables.pgsql'
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
38diff
changeset | 9 |     * backup/dump your database. | 
| 
9d10877e1c10
* 'create_tables.pgsql'
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
38diff
changeset | 10 |     * backup/dump your database! | 
| 128 
cf8116625866
Converted VirtualMailManager and Postconf to new-style classes.
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
127diff
changeset | 11 | |
| 127 
97a9f6dd954b
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
106diff
changeset | 12 |     * start psql and connect to the appropriate database | 
| 566 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 13 | (ex. psql mailsys vmm -W -h 127.0.0.1) | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 14 |     * update the database, | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 15 |       - Dovecot < 1.2.0 | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
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: 
271diff
changeset | 17 |       - Dovecot >= 1.2.0, 2.0.0 and 2.1.0 | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
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: 
271diff
changeset | 19 |     * Set database permissions. | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 20 | (see python set-permissions.py -h for details) | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
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: 
271diff
changeset | 22 | |
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 23 | |
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 24 | /!\ Important note /!\ | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 25 | |
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 26 | All the views (dovecot_* and postfix_*) have been replaced by database | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
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: 
271diff
changeset | 28 | also your /etc/dovecot/dovecot-sql.conf or | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 29 | /etc/dovecot/dovecot-sql.conf.ext. | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
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: 
271diff
changeset | 31 | files for the new query.) | 
| 42 
9d10877e1c10
* 'create_tables.pgsql'
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
38diff
changeset | 32 | |
| 127 
97a9f6dd954b
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
106diff
changeset | 33 | |
| 566 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 34 |     * execute upgrade.sh | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
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: 
106diff
changeset | 36 | |
| 566 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 37 | old new | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 38 | ------------------------------------------------------------ | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 39 | domdir.mode -> domain.directory_mode | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 40 | domdir.delete -> domain.delete_directory | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 41 | domdir.base -> misc.base_directory | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 42 | 	domdir			->	_section domdir deleted_ | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 43 | |
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 44 | maildir.mode -> account.directory_mode | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 45 | maildir.diskusage -> account.disk_usage | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 46 | maildir.delete -> account.delete_directory | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 47 | maildir.folders -> mailbox.folders | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 48 | maildir.name -> mailbox.root | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 49 | 	maildir			->	_section maildir deleted_ | 
| 127 
97a9f6dd954b
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
106diff
changeset | 50 | |
| 566 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 51 | misc.forcedel -> domain.force_deletion | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 52 | misc.transport -> domain.transport | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 53 | misc.passwdscheme -> misc.password_scheme | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 54 | misc.dovecotvers -> misc.dovecot_version (12 -> 1.2.11) | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 55 | misc.gid_mail -> /dev/null | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 56 | |
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 57 | services.smtp -> domain.smtp | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 58 | services.pop3 -> domain.pop3 | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 59 | services.imap -> domain.imap | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 60 | services.sieve -> domain.sieve | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 61 | 	services		->	_section services deleted_ | 
| 127 
97a9f6dd954b
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
106diff
changeset | 62 | |
| 566 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 63 | 	_NEW_.random_password	->	account.random_password | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 64 | 	_NEW_.password_length	->	account.password_length | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 65 | 	_NEW_.auto_postmaster	->	domain.auto_postmaster | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 66 | 	_NEW_.quota_bytes	->	domain.quota_bytes | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 67 | 	_NEW_.quota_messages	->	domain.quota_messages | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 68 | 	_NEW_.module		->	database.module | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 69 | 	_NEW_.port		->	database.port | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 70 | 	_NEW_.sslmode		->	database.sslmode | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 71 | 	_NEW_.format		->	mailbox.format | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 72 | 	_NEW_.crypt_blowfish_rounds ->	misc.crypt_blowfish_rounds | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 73 | 	_NEW_.crypt_sha256_rounds   ->	misc.crypt_sha256_rounds | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 74 | 	_NEW_.crypt_sha512_rounds   ->	misc.crypt_sha512_rounds | 
| 131 
2b8154cc7ebe
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
128diff
changeset | 75 | |
| 566 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 76 | config.done -> /dev/null | 
| 
007786e58fb7
UPGRADE: Updated documentation.
 Pascal Volk <user@localhost.localdomain.org> parents: 
271diff
changeset | 77 | 	config                  ->	_section config deleted_ | 
| 42 
9d10877e1c10
* 'create_tables.pgsql'
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
38diff
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: 
271diff
changeset | 80 |     * start Dovecot and Postfix again | 
| 127 
97a9f6dd954b
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
106diff
changeset | 81 | |
| 106 
dc98cc162c66
Released vmm-0.5.1
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
67diff
changeset | 82 | |
| 624 
e1fc4a3075de
UPGRADE: Added procedure for updating from v0.6.0.
 Pascal Volk <user@localhost.localdomain.org> parents: 
566diff
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: 
566diff
changeset | 84 | |
| 
e1fc4a3075de
UPGRADE: Added procedure for updating from v0.6.0.
 Pascal Volk <user@localhost.localdomain.org> parents: 
566diff
changeset | 85 |     * Database fixes: | 
| 
e1fc4a3075de
UPGRADE: Added procedure for updating from v0.6.0.
 Pascal Volk <user@localhost.localdomain.org> parents: 
566diff
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: 
566diff
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: 
566diff
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: 
566diff
changeset | 89 | the following SQL statement: | 
| 
e1fc4a3075de
UPGRADE: Added procedure for updating from v0.6.0.
 Pascal Volk <user@localhost.localdomain.org> parents: 
566diff
changeset | 90 | |
| 
e1fc4a3075de
UPGRADE: Added procedure for updating from v0.6.0.
 Pascal Volk <user@localhost.localdomain.org> parents: 
566diff
changeset | 91 | UPDATE users SET tid = NULL | 
| 
e1fc4a3075de
UPGRADE: Added procedure for updating from v0.6.0.
 Pascal Volk <user@localhost.localdomain.org> parents: 
566diff
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: 
566diff
changeset | 93 | |
| 
e1fc4a3075de
UPGRADE: Added procedure for updating from v0.6.0.
 Pascal Volk <user@localhost.localdomain.org> parents: 
566diff
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: 
566diff
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: 
566diff
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: 
566diff
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: 
566diff
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: 
566diff
changeset | 99 | |
| 
e1fc4a3075de
UPGRADE: Added procedure for updating from v0.6.0.
 Pascal Volk <user@localhost.localdomain.org> parents: 
566diff
changeset | 100 |     * execute upgrade.sh | 
| 
e1fc4a3075de
UPGRADE: Added procedure for updating from v0.6.0.
 Pascal Volk <user@localhost.localdomain.org> parents: 
566diff
changeset | 101 | |
| 707 
19184d1265e5
UPGRADE: Added a note about upgrading from 0.6.1.
 Pascal Volk <user@localhost.localdomain.org> parents: 
624diff
changeset | 102 | |
| 
19184d1265e5
UPGRADE: Added a note about upgrading from 0.6.1.
 Pascal Volk <user@localhost.localdomain.org> parents: 
624diff
changeset | 103 | If you have installed vmm 0.6.1 you simply have to: | 
| 
19184d1265e5
UPGRADE: Added a note about upgrading from 0.6.1.
 Pascal Volk <user@localhost.localdomain.org> parents: 
624diff
changeset | 104 | |
| 
19184d1265e5
UPGRADE: Added a note about upgrading from 0.6.1.
 Pascal Volk <user@localhost.localdomain.org> parents: 
624diff
changeset | 105 |     * execute upgrade.sh | 
| 
19184d1265e5
UPGRADE: Added a note about upgrading from 0.6.1.
 Pascal Volk <user@localhost.localdomain.org> parents: 
624diff
changeset | 106 | |
| 38 
c44ea4526546
* 'VirtualMailManager/Alias.py'
 Pascal Volk <neverseen@users.sourceforge.net> parents: diff
changeset | 107 | else | 
| 
c44ea4526546
* 'VirtualMailManager/Alias.py'
 Pascal Volk <neverseen@users.sourceforge.net> parents: diff
changeset | 108 |      * read INSTALL |