PUBLIC MARKS with tags postfix & mysql

The configuration described here is not very complicated but still needs to be done carefully. You are expected to have at least basic knowledge of: * MySQL (creating a database, granting access to users, basic SQL queries) * SMTP (what it is and what a basic SMTP dialog looks like) * POP3, IMAP (what they do and what the differences are) * basic Postfix configuration (understand the default settings in your main.cf, have read through the basic configuration document and know that your mail log file is at /var/log/mail.log) * Debian/Linux (general system administration, using a text editor, reading log files)

his document is derived from Christoph Haas’ tutorial “Howto: ISP-style Email Server with Debian-Etch and Postfix” (http://workaround.org) and Falko Timme’s tutorial “Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 8.04 LTS)” (http://www.howtoforge.com). The associated Mailfix Drupal module must be installed as part of this tutorial. It will guide you through the necessary steps to configure a Drupal driven Mail server. Provided features: * Drupal managed email accounts * Support for virtual domains * Automatic forwarding * Postfix quota support * Silent BCC monitoring * Other features: anti-spam, anti-virus

Convert Vpopmail to Postfix MySQL

This HOWTO enables you to build a complete open source turn-key email server in a matter of hours (instead of days or weeks). In one sense it is more like one big script that requires intervention. It can be considered a howto if one reads the contents of each patch and script I provide.

This document describes how to integrate ASSP (Anti-Spam SMTP Proxy) with embedded ClamAV into a mail server based on Postfix featuring virtual users and domains, i.e. users and domains that are in a MySQL database.

This tutorial shows how to set up a Debian Etch (Debian 4.0) based server that offers all services needed by ISPs and hosters: Apache web server (SSL-capable), Postfix mail server with SMTP-AUTH and TLS, BIND DNS server, Proftpd FTP server, MySQL server, Courier POP3/IMAP, Quota, Firewall, etc. This tutorial is written for the 32-bit version of Debian Etch, but should apply to the 64-bit version with very little modifications as well.

Domain Technologie Control (DTC) is a GPL control panel for hosting. Using a web GUI for admin and accounting all hosting services, DTC can delegate the task of creating subdomains, email, and FTP accounts to users for the domain names they own. DTC manages a MySQL database containing all the hosting information. It has support for many programs (bind 8 and 9 and compatibles, MySQL, Apache 1.3, php4, qmail, postfix 2, courier, dovecot, proftpd, webalizer, mod-log-sql, etc.) through config files and/or MySQL plugins (when the service is non-critical). It can also generate backup scripts, calculation scripts, and config files using a single system UID/GID and monitor all traffic accounting per user and per service. Since version 0.12, DTC is fully skinable and translated into several languages (Chinese, English, Spanish, French, Dutch, German, Italian, Russian, Hungarian, Romanian and Polish).

This document describes how to install a mail server based on Postfix that is based on virtual users and domains, i.e. users and domains that are in a MySQL database. I'll also demonstrate the installation and configuration of Courier (Courier-POP3, Courier-IMAP), so that Courier can authenticate against the same MySQL database Postfix uses.