| author | Pascal Volk <neverseen@users.sourceforge.net> | 
| Tue, 22 Apr 2008 07:34:02 +0000 | |
| changeset 22 | 576a4709a44f | 
| parent 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:  | 
| 21 | 11  | 
* user_query = \  | 
12  | 
SELECT home, uid, gid, 'maildir:'||mail AS mail FROM dovecot_user WHERE userid = '%u'  | 
|
| 
20
 
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  |