| author | Pascal Volk <neverseen@users.sourceforge.net> |
| Mon, 21 Apr 2008 04:56:01 +0000 | |
| changeset 20 | 55146c78b3fb |
| parent 15 | 1607f7b2dba9 |
| child 21 | 6feb31787a66 |
| permissions | -rw-r--r-- |
|
14
ebc9b864bc9a
* 'update_config_0.3.x-0.4.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff
changeset
|
1 |
If you have installed vmm 0.3.x you have to proceed this steps: |
|
ebc9b864bc9a
* 'update_config_0.3.x-0.4.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff
changeset
|
2 |
|
|
ebc9b864bc9a
* 'update_config_0.3.x-0.4.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff
changeset
|
3 |
* stop Postfix and Dovecot |
|
ebc9b864bc9a
* 'update_config_0.3.x-0.4.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff
changeset
|
4 |
* backup/dump your database. |
|
ebc9b864bc9a
* 'update_config_0.3.x-0.4.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff
changeset
|
5 |
* backup/dump your database! |
|
15
1607f7b2dba9
* 'update_config_0.3.x-0.4.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
14
diff
changeset
|
6 |
* execute upgrade.sh |
|
1607f7b2dba9
* 'update_config_0.3.x-0.4.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
14
diff
changeset
|
7 |
* set permissions for replaced views: |
|
20
55146c78b3fb
* 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
15
diff
changeset
|
8 |
GRANT SELECT ON dovecot_user, dovecot_password TO your_dovecot_dbuser; |
|
15
1607f7b2dba9
* 'update_config_0.3.x-0.4.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
14
diff
changeset
|
9 |
GRANT SELECT ON postfix_transport TO your_postfix_dbuser; |
|
1607f7b2dba9
* 'update_config_0.3.x-0.4.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
14
diff
changeset
|
10 |
* update user_query in /etc/dovecot/dovecot-sql.conf: |
|
1607f7b2dba9
* 'update_config_0.3.x-0.4.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
14
diff
changeset
|
11 |
user_query = \ |
|
20
55146c78b3fb
* 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
15
diff
changeset
|
12 |
SELECT home, uid, gid, mail FROM dovecot_user WHERE userid='%u' |
|
55146c78b3fb
* 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
15
diff
changeset
|
13 |
* update password_query in /etc/dovecot/dovecot-sql.conf: |
|
55146c78b3fb
* 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
15
diff
changeset
|
14 |
password_query = \ |
|
55146c78b3fb
* 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
15
diff
changeset
|
15 |
SELECT "user", password FROM dovecot_password WHERE "user"='%u' AND %Ls |
|
14
ebc9b864bc9a
* 'update_config_0.3.x-0.4.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff
changeset
|
16 |
* edit the pgsql parameters hosts, user, password and dbname in: |
|
ebc9b864bc9a
* 'update_config_0.3.x-0.4.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff
changeset
|
17 |
$(postconf -h config_directory)/pgsql-smtpd_sender_login_maps.cf |
|
ebc9b864bc9a
* 'update_config_0.3.x-0.4.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff
changeset
|
18 |
$(postconf -h config_directory)/pgsql-transport.cf |
|
ebc9b864bc9a
* 'update_config_0.3.x-0.4.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff
changeset
|
19 |
$(postconf -h config_directory)/pgsql-virtual_mailbox_domains.cf |
|
ebc9b864bc9a
* 'update_config_0.3.x-0.4.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff
changeset
|
20 |
* check the value of option transport in section misc in |
|
ebc9b864bc9a
* 'update_config_0.3.x-0.4.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff
changeset
|
21 |
/usr/local/etc/vmm.cfg |
|
ebc9b864bc9a
* 'update_config_0.3.x-0.4.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff
changeset
|
22 |
* start Dovecot and Postfix |
|
ebc9b864bc9a
* 'update_config_0.3.x-0.4.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff
changeset
|
23 |
|
|
ebc9b864bc9a
* 'update_config_0.3.x-0.4.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff
changeset
|
24 |
else: |
|
ebc9b864bc9a
* 'update_config_0.3.x-0.4.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff
changeset
|
25 |
|
|
ebc9b864bc9a
* 'update_config_0.3.x-0.4.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff
changeset
|
26 |
* read INSTALL |