author | Pascal Volk <user@localhost.localdomain.org> |
Sat, 01 Feb 2014 20:29:23 +0000 | |
changeset 708 | 93b2f5859866 |
parent 707 | 19184d1265e5 |
permissions | -rw-r--r-- |
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 |
|
707
19184d1265e5
UPGRADE: Added a note about upgrading from 0.6.1.
Pascal Volk <user@localhost.localdomain.org>
parents:
624
diff
changeset
|
102 |
|
19184d1265e5
UPGRADE: Added a note about upgrading from 0.6.1.
Pascal Volk <user@localhost.localdomain.org>
parents:
624
diff
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:
624
diff
changeset
|
104 |
|
19184d1265e5
UPGRADE: Added a note about upgrading from 0.6.1.
Pascal Volk <user@localhost.localdomain.org>
parents:
624
diff
changeset
|
105 |
* execute upgrade.sh |
19184d1265e5
UPGRADE: Added a note about upgrading from 0.6.1.
Pascal Volk <user@localhost.localdomain.org>
parents:
624
diff
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 |