equal
deleted
inserted
replaced
1 Installation Prerequisites |
1 Installation Prerequisites |
2 You should already have installed and configured Postfix, Dovecot and |
2 You should already have installed and configured Postfix, Dovecot and |
3 PostgreSQL. |
3 PostgreSQL. |
4 You have to install Python and pyPgSQL* to use the Virtual Mail Manager. |
4 You have to install Python and pyPgSQL* to use the Virtual Mail Manager. |
|
5 If you want to store the passwords as PLAIN-MD4 digest you have also to install |
|
6 python-crypto <http://www.amk.ca/python/code/crypto.html>. |
5 |
7 |
6 * = http://pypgsql.sourceforge.net/ (Debian: python-pgsql) |
8 * = http://pypgsql.sourceforge.net/ (Debian: python-pgsql) |
7 |
9 |
8 |
10 |
9 Configuring PostgreSQL |
11 Configuring PostgreSQL |
89 |
91 |
90 * /etc/dovecot/dovecot-sql.conf |
92 * /etc/dovecot/dovecot-sql.conf |
91 driver = pgsql |
93 driver = pgsql |
92 connect = host=localhost dbname=mailsys user=dovecot password=$Dovecot_PASS |
94 connect = host=localhost dbname=mailsys user=dovecot password=$Dovecot_PASS |
93 default_pass_scheme = HMAC-MD5 |
95 default_pass_scheme = HMAC-MD5 |
94 password_query = SELECT "user", password FROM dovecot_password WHERE "user"= '%u' |
96 password_query = SELECT "user", password FROM dovecot_password WHERE "user"='%u' |
95 user_query = SELECT home, uid, gid, mail FROM dovecot_user WHERE userid='%u' |
97 user_query = SELECT home, uid, gid, 'maildir:'||mail AS mail FROM dovecot_user WHERE userid = '%u' |
96 |
98 |
97 Provide a root SETUID copy of Dovecot's deliver agent for Postfix |
99 Provide a root SETUID copy of Dovecot's deliver agent for Postfix |
98 |
100 |
99 mkdir -p /usr/local/lib/dovecot |
101 mkdir -p /usr/local/lib/dovecot |
100 chmod 700 /usr/local/lib/dovecot |
102 chmod 700 /usr/local/lib/dovecot |