StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>If you want users to be able to create e-mail accounts in <a href="http://www.djangoproject.com/" rel="nofollow noreferrer">Django</a>, you need Django, your <a href="http://en.wikipedia.org/wiki/Mail_transfer_agent" rel="nofollow noreferrer">MTA</a> and your <a href="http://en.wikipedia.org/wiki/IMAP" rel="nofollow noreferrer">IMAP</a>/POP server to use the same user account database.</p> <p>I've successfully used the following setup:</p> <ul> <li><a href="http://www.postgresql.org/" rel="nofollow noreferrer">PostgreSQL</a> as the user database</li> <li><a href="http://www.postfix.org/" rel="nofollow noreferrer">Postfix</a> as the MTA</li> <li><a href="http://www.postfix.org/" rel="nofollow noreferrer">Dovecot</a> as the IMAP server</li> <li>a custom Django app as the user account management front-end</li> <li>virtual mail user accounts (not using Unix accounts)</li> </ul> <p>I've only used the Django admin interface to let administrators manage the mail accounts, but a management UI for users is trivial to implement as well.</p> <p>Some tips and sources of information for such a setup:</p> <ul> <li>Design your database schema carefully. I based mine on howtos mentioned below with modifications for easier Django integration.</li> <li>Take care that all components use the same encryption for user passwords.</li> <li>two howtos (<a href="http://www.lxtreme.nl/index.pl/docs/linux/dovecot_postfix_pam" rel="nofollow noreferrer">first</a>, <a href="http://www.gjdv.at/snippets/linux/virtual_mail_hosting" rel="nofollow noreferrer">second</a>) describing how Dovecot and Postfix can authenticate users using PAM and PostgreSQL as backend</li> <li>a <a href="http://www.tuxj0b.de/HOWTO_Mailserver_mit_Postfix_Dovecot_Antispam_und_PostgreSQL_Backend" rel="nofollow noreferrer">howto in German</a> for Dovecot/Postfix/PostgreSQL</li> <li>a <a href="http://wiki.dovecot.org/HowTo/DovecotPostgresql" rel="nofollow noreferrer">howto</a> for gluing together virtual user/domain support for Debian, Postfix 2 with SMTP AUTH, SASL2 with libpam-pgsql for Postfix, PostgreSQL and Dovecot </li> <li>the <a href="http://www.postfix.org/PGSQL_README.html" rel="nofollow noreferrer">Postfix PostgreSQL howto</a></li> </ul> <p>You might also want to check out the <a href="http://vmm.localdomain.org/" rel="nofollow noreferrer">Virtual Mail Manager</a> command line tool for managing domains, accounts and aliases with a Dovecot/Postfix/PostgreSQL setup.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload