Due to the UNION query in address_list, the assumption that the list of
gids received from the database would be continuous does not hold.
To prevent addresses for domains with multiple entry types from being
listed, it is necessary to check the list of domain gids for every
entry.
Signed-off-by: martin f. krafft <madduck@debian.org>
---
VirtualMailManager/common.py | 4 +---
1 file changed, 1 insertion(+), 3 deletions(-)
======================Upgrading to vmm 0.6.x======================This document describes the procedure to upgrade a vmm-0.5.2 installationto version 0.6.xIf you still have installed vmm-0.4/vmm-0.4-r41 you have to proceed thisstep first: ‣ :doc:`0.4.x-0.5`Upgrading from vmm-0.5.2------------------------Stop Postfix and Dovecot^^^^^^^^^^^^^^^^^^^^^^^^Before updating your database layout you have to stop Postfix and Dovecot...code-block::consoleroot@host:~# /etc/init.d/postfixstopStopping Postfix Mail Transport Agent: postfix.root@host:~# /etc/init.d/dovecotstopStopping IMAP/POP3 mail server: dovecot.Create a database backup^^^^^^^^^^^^^^^^^^^^^^^^It is always wise to back up your database from time to time.Particularly with regard to an impending structure modification.Example: Backing up the `mailsys` database with pg_dump_...code-block::consoleuser@host:~$ pg_dump-hlocalhost-Uvmm-Wmailsys>mailsys-0.5.2.sqlDatabase update^^^^^^^^^^^^^^^Connect as your `vmm` database user to your database...code-block::consoleuser@host:~$ psqlmailsysvmm-W-hlocalhostIn the PostgreSQL interactive terminal you have to run one of the followingcommands to perform the update.Dovecot v1.2.x/v2.0.x/v2.1.x""""""""""""""""""""""""""""..code-block::postgresql-consolemailsys=>\i/path/to/vmm-0.6.0/pgsql/update_tables_0.5.x-0.6-dovecot-1.2.x.pgsqlmailsys=>\qDovecot v1.0.x/v1.1.x"""""""""""""""""""""..code-block::postgresql-consolemailsys=>\i/path/to/vmm-0.6.0/pgsql/update_tables_0.5.x-0.6.pgsqlmailsys=>\qSet database permissions^^^^^^^^^^^^^^^^^^^^^^^^..include:: ../pgsql_set_permissionspermissions.rstStart Dovecot and Postfix again^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^..warning:: All the views (*dovecot_…* and *postfix_…*) have been replaced by database functions. So you have to adjust all your ``postfix/pgsql-*.cf`` files and also your``/etc/dovecot/dovecot-sql.conf`` or ``/etc/dovecot/dovecot-sql.conf.ext``. See the `vmm-0.6.0/postfix/pgsql-*.cf` files and:ref:`Dovecot configuration <dovecot-sql-conf-ext>`/`dovecot-sql.conf.ext` or :ref:`Dovecot configuration <dovecot-sql-conf>`/`dovecot-sql-conf`.After a successfully update start Dovecot and Postfix again...code-block::consoleroot@host:~# /etc/init.d/dovecotstartStarting IMAP/POP3 mail server: dovecot.root@host:~# /etc/init.d/postfixstartStarting Postfix Mail Transport Agent: postfix.Upgrade vmm^^^^^^^^^^^Finally execute the :file:`upgrade.sh` script.This will install the new code and also update your :file:`vmm.cfg`...code-block::consoleroot@host:~# cd/path/to/vmm-0.6.0root@host:/path/to/vmm-0.6.0# ./upgrade.shPlease have a look at your configuration: /usr/local/etc/vmm.cfgThis are your Modified/Renamed/New settings:R account.delete_directory = falseR account.directory_mode = 448R account.disk_usage = falseR domain.delete_directory = falseR domain.directory_mode = 504R domain.force_deletion = falseR domain.imap = trueR domain.pop3 = trueR domain.sieve = trueR domain.smtp = trueR domain.transport = dovecot:R mailbox.folders = Drafts:Sent:Templates:TrashR mailbox.root = MaildirR misc.base_directory = /srv/mailM misc.dovecot_version = 2.1.7R misc.dovecot_version = 2.1.7R misc.password_scheme = PLAINRemoved section "config" with option "done" (obsolte)Removed option "gid_mail" from section "misc" (obsolte)..include:: ../ext_references.rst