UPGRADE
author Pascal Volk <neverseen@users.sourceforge.net>
Fri, 21 Aug 2009 11:25:14 +0000
changeset 127 97a9f6dd954b
parent 106 dc98cc162c66
child 128 cf8116625866
permissions -rw-r--r--
Updated documentation
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
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: 38
diff changeset
     2
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
     3
    * upgrade your vmm installation to version 0.4-r41
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
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff 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: 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!
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
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
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    13
      (ex. psql mailsys mailsys vmm -W -h localhost)
42
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff 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: 42
diff changeset
    15
    * GRANT SELECT ON postfix_alias TO postfix;
e4d25f50164d * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 42
diff changeset
    16
                                       ^^^^^^^^ <- your Postfix db user
42
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
    17
127
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    18
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    19
  Dovecot v1.2.x
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    20
    -> Are you already using Dovecot v1.2.x?
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    21
       * update the database for Dovecot v1.2.x:
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    22
         \i update_tables_0.5.x_for_dovecot-1.2.x.pgsql
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    23
       * GRANT SELECT ON dovecot_password TO dovecot;
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    24
                                             ^^^^^^^^ <- your Dovecot db user
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    25
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    26
       * When you are using the SQL function »dovecotpassword()« in your
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    27
         dovecot-sql.conf, update it also:
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff 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: 106
diff changeset
    29
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    30
       * You have also to adjust the permissions of the set-uid deliver copy:
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    31
         chgrp nogroup /usr/local/lib/dovecot/deliver
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    32
	 chmod u+s,o-rwx /usr/local/lib/dovecot/deliver
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    33
42
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
    34
    * execute upgrade.sh
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
    35
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
    36
    * start Dovecot and Postfix
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
    37
38
c44ea4526546 * 'VirtualMailManager/Alias.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
    38
127
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    39
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    40
If you have installed vmm 0.5.x:
106
dc98cc162c66 Released vmm-0.5.1
Pascal Volk <neverseen@users.sourceforge.net>
parents: 67
diff changeset
    41
dc98cc162c66 Released vmm-0.5.1
Pascal Volk <neverseen@users.sourceforge.net>
parents: 67
diff changeset
    42
    * execute upgrade.sh
dc98cc162c66 Released vmm-0.5.1
Pascal Volk <neverseen@users.sourceforge.net>
parents: 67
diff changeset
    43
127
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    44
    -> Are you already using Dovecot v1.2.x?
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    45
       See a few lines above.
97a9f6dd954b Updated documentation
Pascal Volk <neverseen@users.sourceforge.net>
parents: 106
diff changeset
    46
106
dc98cc162c66 Released vmm-0.5.1
Pascal Volk <neverseen@users.sourceforge.net>
parents: 67
diff changeset
    47
38
c44ea4526546 * 'VirtualMailManager/Alias.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
    48
else
c44ea4526546 * 'VirtualMailManager/Alias.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
    49
     * read INSTALL