| author | Pascal Volk <neverseen@users.sourceforge.net> | 
| Wed, 30 Apr 2008 04:05:13 +0000 | |
| changeset 26 | 668951708f2f | 
| 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: 
14diff
changeset | 6 | * execute upgrade.sh | 
| 
1607f7b2dba9
* 'update_config_0.3.x-0.4.py'
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
14diff
changeset | 7 | * set permissions for replaced views: | 
| 20 
55146c78b3fb
* 'create_tables.pgsql'
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
15diff
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: 
14diff
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: 
14diff
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: 
15diff
changeset | 13 | * update password_query in /etc/dovecot/dovecot-sql.conf: | 
| 
55146c78b3fb
* 'create_tables.pgsql'
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
15diff
changeset | 14 | password_query = \ | 
| 
55146c78b3fb
* 'create_tables.pgsql'
 Pascal Volk <neverseen@users.sourceforge.net> parents: 
15diff
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 |