| author | Pascal Volk <user@localhost.localdomain.org> | 
| Sat, 07 Apr 2012 20:38:48 +0000 | |
| branch | v0.6.x | 
| changeset 496 | 17f2c5b5098e | 
| parent 271 | e915d4725706 | 
| child 566 | 007786e58fb7 | 
| permissions | -rw-r--r-- | 
| 38 
c44ea4526546
* 'VirtualMailManager/Alias.py'
 Pascal Volk <neverseen@users.sourceforge.net> parents: diff
changeset | 1 | If you still have installed vmm 0.3.x you have to proceed this step first: | 
| 42 
9d10877e1c10
* 'create_tables.pgsql'
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
38diff
changeset | 2 | |
| 
9d10877e1c10
* 'create_tables.pgsql'
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
38diff
changeset | 3 | * upgrade your vmm installation to version 0.4-r41 | 
| 
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 | |
| 
9d10877e1c10
* 'create_tables.pgsql'
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
38diff
changeset | 6 | If you have installed vmm 0.4/0.4-r41 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 | 
| 
97a9f6dd954b
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
106diff
changeset | 13 | (ex. psql mailsys mailsys vmm -W -h localhost) | 
| 42 
9d10877e1c10
* 'create_tables.pgsql'
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
38diff
changeset | 14 | * update the database: \i update_tables_0.4.x-0.5.pgsql | 
| 67 
e4d25f50164d
* 'create_tables.pgsql'
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
42diff
changeset | 15 | * GRANT SELECT ON postfix_alias TO postfix; | 
| 
e4d25f50164d
* 'create_tables.pgsql'
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
42diff
changeset | 16 | ^^^^^^^^ <- your Postfix db user | 
| 42 
9d10877e1c10
* 'create_tables.pgsql'
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
38diff
changeset | 17 | |
| 127 
97a9f6dd954b
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
106diff
changeset | 18 | |
| 
97a9f6dd954b
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
106diff
changeset | 19 | Dovecot v1.2.x | 
| 
97a9f6dd954b
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
106diff
changeset | 20 | -> Are you already using Dovecot v1.2.x? | 
| 
97a9f6dd954b
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
106diff
changeset | 21 | * update the database for Dovecot v1.2.x: | 
| 
97a9f6dd954b
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
106diff
changeset | 22 | \i update_tables_0.5.x_for_dovecot-1.2.x.pgsql | 
| 
97a9f6dd954b
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
106diff
changeset | 23 | * GRANT SELECT ON dovecot_password TO dovecot; | 
| 
97a9f6dd954b
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
106diff
changeset | 24 | ^^^^^^^^ <- your Dovecot db user | 
| 
97a9f6dd954b
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
106diff
changeset | 25 | |
| 
97a9f6dd954b
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
106diff
changeset | 26 | * When you are using the SQL function »dovecotpassword()« in your | 
| 
97a9f6dd954b
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
106diff
changeset | 27 | dovecot-sql.conf, update it also: | 
| 
97a9f6dd954b
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
106diff
changeset | 28 | \i update_types_and_functions_0.5.x_for_dovecot-1.2.x.pgsql | 
| 
97a9f6dd954b
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
106diff
changeset | 29 | |
| 
97a9f6dd954b
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
106diff
changeset | 30 | * You have also to adjust the permissions of the set-uid deliver copy: | 
| 135 
32ad0c79a6ef
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
131diff
changeset | 31 | on BSD: | 
| 
32ad0c79a6ef
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
131diff
changeset | 32 | chgrp nobody /usr/local/lib/dovecot/deliver | 
| 
32ad0c79a6ef
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
131diff
changeset | 33 | on Linux: | 
| 
32ad0c79a6ef
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
131diff
changeset | 34 | chgrp nogroup /usr/local/lib/dovecot/deliver | 
| 128 
cf8116625866
Converted VirtualMailManager and Postconf to new-style classes.
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
127diff
changeset | 35 | chmod u+s,o-rwx /usr/local/lib/dovecot/deliver | 
| 127 
97a9f6dd954b
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
106diff
changeset | 36 | |
| 131 
2b8154cc7ebe
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
128diff
changeset | 37 | * Check the master.cf from Postfix. | 
| 
2b8154cc7ebe
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
128diff
changeset | 38 | In prior setups the service dovecot was configured slightly different. | 
| 
2b8154cc7ebe
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
128diff
changeset | 39 | If you have set the command attribute 'user' to 'nobody:mail', so | 
| 135 
32ad0c79a6ef
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
131diff
changeset | 40 | either remove the group mail or replace it with the group nobody | 
| 271 
e915d4725706
INSTALL: dropped group mail related stuff.
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
135diff
changeset | 41 | or nogroup. (see command output from: id -ng nobody) | 
| 131 
2b8154cc7ebe
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
128diff
changeset | 42 | |
| 
2b8154cc7ebe
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
128diff
changeset | 43 | e.g.: flags=DRhu user=nobody argv=/usr/local/lib/dovecot/deliver … | 
| 
2b8154cc7ebe
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
128diff
changeset | 44 | |
| 42 
9d10877e1c10
* 'create_tables.pgsql'
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
38diff
changeset | 45 | * execute upgrade.sh | 
| 
9d10877e1c10
* 'create_tables.pgsql'
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
38diff
changeset | 46 | |
| 
9d10877e1c10
* 'create_tables.pgsql'
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
38diff
changeset | 47 | * start Dovecot and Postfix | 
| 
9d10877e1c10
* 'create_tables.pgsql'
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
38diff
changeset | 48 | |
| 38 
c44ea4526546
* 'VirtualMailManager/Alias.py'
 Pascal Volk <neverseen@users.sourceforge.net> parents: diff
changeset | 49 | |
| 127 
97a9f6dd954b
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
106diff
changeset | 50 | |
| 
97a9f6dd954b
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
106diff
changeset | 51 | If you have installed vmm 0.5.x: | 
| 106 
dc98cc162c66
Released vmm-0.5.1
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
67diff
changeset | 52 | |
| 
dc98cc162c66
Released vmm-0.5.1
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
67diff
changeset | 53 | * execute upgrade.sh | 
| 
dc98cc162c66
Released vmm-0.5.1
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
67diff
changeset | 54 | |
| 127 
97a9f6dd954b
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
106diff
changeset | 55 | -> Are you already using Dovecot v1.2.x? | 
| 
97a9f6dd954b
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
106diff
changeset | 56 | See a few lines above. | 
| 
97a9f6dd954b
Updated documentation
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
106diff
changeset | 57 | |
| 106 
dc98cc162c66
Released vmm-0.5.1
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
67diff
changeset | 58 | |
| 38 
c44ea4526546
* 'VirtualMailManager/Alias.py'
 Pascal Volk <neverseen@users.sourceforge.net> parents: diff
changeset | 59 | else | 
| 
c44ea4526546
* 'VirtualMailManager/Alias.py'
 Pascal Volk <neverseen@users.sourceforge.net> parents: diff
changeset | 60 | * read INSTALL |