==========================

Installation Prerequisites

==========================

You already should have installed and configured Postfix and Dovecot with

PostgreSQL support. You also need access to a local or remote PostgreSQL

server.

Check for pgsql support in Dovecot and Postfix

----------------------------------------------

To verify that your Dovecot and Postfix installation has support for

PostgreSQL use the :command:`postconf` and :command:`dovecot` commands as

shown below:

.. code-block:: console

  root@host:~# postconf -m | grep pgsql

  pgsql

  root@host:~# postconf -a | grep dovecot

  dovecot

  root@host:~# dovecot --build-options | grep postgresql

  SQL drivers: mysql postgresql sqlite

vmm depends on Python (≥ 2.4.0) and Psycopg_ (≥ 2.0) or pyPgSQL_ (≥ 2.5.1)

[#]_. Psycopg and pyPgSQL are depending on parts of the *eGenix.com mx Base

Distribution* (mxDateTime_ and mxTools_).

If you are using Python ≤ 2.5.0:

 ‣ if you want to store your users' passwords as ``PLAIN-MD4`` digest in

   the database, vmm will try to use ``Crypto.Hash.MD4`` from PyCrypto_

 ‣ if you are using Dovecot ≥ v1.1.0 and you want to store your users'

   passwords as ``SHA256`` or ``SSHA256`` hashes, vmm will try to use

   ``Crypto.Hash.SHA256`` from PyCrypto. For ``SHA256``/``SSHA256`` you

   should have installed PyCrypto, at least in version 2.1.0alpha1.

 When the Crypto.Hash module couldn't be imported, vmm will use

 dovecotpw/doveadm, if  the *misc.password_scheme* setting in your

 :file:`vmm.cfg` is set to ``PLAIN-MD4``, ``SHA256`` or ``SSHA256``.

If your Dovecot and/or Postfix installation shouldn't support PostgreSQL you

could possibly fix this by installing the missing package (see below) or by

recompiling the corresponding part.

Package names by OS/Distribution

--------------------------------

Debian GNU/Linux (Squeeze/Wheezy)

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

 ‣ `postfix <http://packages.debian.org/postfix>`_ and

   `postfix-pgsql <http://packages.debian.org/postfix-pgsql>`_

 ‣ Squeeze:

   * `dovecot-common <http://packages.debian.org/dovecot-common>`_

 ‣ Wheezy (and Squeeze backports):

   * `dovecot-core <http://packages.debian.org/dovecot-core>`_ and

     `dovecot-lmtpd <http://packages.debian.org/dovecot-lmtpd>`_

 ‣ `dovecot-imapd <http://packages.debian.org/dovecot-imapd>`_ and/or

   `dovecot-pop3d <http://packages.debian.org/dovecot-pop3d>`_

 ‣ `postgresql-client <http://packages.debian.org/postgresql-client>`_

   (or `postgresql <http://packages.debian.org/postgresql>`_ , if you do not

   have a dedicated PostgreSQL server.)

 ‣ `python <http://packages.debian.org/python>`_,

   `python-egenix-mxdatetime \

   <http://packages.debian.org/python-egenix-mxdatetime>`_

   and `python-psycopg2 <http://packages.debian.org/python-psycopg2>`_

   optionally `python-crypto <http://packages.debian.org/python-crypto>`_

 ‣ `gettext <http://packages.debian.org/gettext>`_

FreeBSD

^^^^^^^

Packages or build from ports:

 ‣ dovecot

 ‣ postfix

 ‣ postgresql-client (and postgresql-server, if you do not have a dedicated

   PostgreSQL server.)

 ‣ python25, py25-mx-base and py25-pyPgSQL optionally py25-pycrypto

Gentoo Linux

^^^^^^^^^^^^

 ‣ `dev-python/pypgsql <http://gentoo-portage.com/dev-python/pypgsql>`_

 ‣ `mail-mta/postfix <http://gentoo-portage.com/mail-mta/postfix>`_

 ‣ `net-mail/dovecot <http://gentoo-portage.com/net-mail/dovecot>`_

 ‣ `dev-db/postgresql-base <http://gentoo-portage.com/dev-db/postgresql-base>`_

 ‣ `dev-db/postgresql-server \

   <http://gentoo-portage.com/dev-db/postgresql-server>`_

Applied use-Flags (/etc/portage/package.use)::

 mail-mta/postfix dovecot-sasl postgres -pam sasl

 net-mail/dovecot postgres -pam pop3d sieve

 dev-db/postgresql-server -perl

OpenBSD (5.x)

^^^^^^^^^^^^^

Packages

 ‣ postfix-2.x.y-pgsql

 ‣ dovecot-2.x.y and dovecot-postgresql-2.x.y

 ‣ postgresql-client

 ‣ python-2.7.x, py-psycopg2 and optionally py-crypto

Or build the above mentioned software from ports.

openSUSE Linux

^^^^^^^^^^^^^^

 ‣ postfix and postfix-postgresql

 ‣ postgresql-server and postgresql

 ‣ dovecot

 ‣ python and pyPgSQL optionally python-crypto

.. rubric:: Footnotes

.. [#] Beginning with version 0.7.0 of vmm support for pyPgSQL will be dropped.

.. include:: ../ext_references.rst