You already should have installed and configured Postfix and Dovecot ≥ 2.0.0 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 postconf and dovecot commands as shown below:
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 (≥ 3.2) and Psycopg (≥ 2.0).
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 (bullseye)¶
If you want to install vmm from source, you will also have to install the following both packages:
- Packages or build from ports:
postgresql-client (and postgresql-server, if you do not have a dedicated PostgreSQL server.)
python25, py25-mx-base and py25-pyPgSQL optionally py25-pycrypto
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
dovecot-2.x.y and dovecot-postgresql-2.x.y
- Build from source
Or build the above mentioned software from ports.
postfix and postfix-postgresql
postgresql-server and postgresql
python and pyPgSQL optionally python-crypto