DBMail Wiki

This Wiki can be used to document and discuss the use and development of DBMail.

Please do not use the wiki for support requests. Use it for manuals, how-tos, design-proposals, or to explain your new ideas.

Before you can add or edit pages you will need to create a wiki account. Or Login

If you haven't registered for the DBMail mailing lists yet, please do so before adding content here.

• The Big Picture of DBMail
• DBMail Entity Relationship Model

• DBMail 2.0: old stable production series from 2004-2006
• DBMail 2.2: old stable production series from 2006-2012
• DBMail 2.3: unstable development series with releases from 2007-2009
• DBMail 3.0: current stable production series, first released 2012-01-30

Follow these links to find available documentation and installation notes about:

• What do you need?
• Getting dbmail
• Setup the database backend
• Configuring your MTA
  • Using DBMail with Postfix
  • Using DBMail with Exim
  • Using DBMail with Sendmail
  • Using DBMail with Qmail
• Managing users
  • Creating public/shared mailboxes
• Sieve filtering
• Upgrading from DBMail 2.0 to the 2.2 series
• Notes for getting the best results from MySQL
• How to get DBMail from git
• A sample Mailserver from the scratch with DBMail 3.0
• DBMail 3.0.x on Debian with SSL, Postfix and Postgresql and crypt Passwords

• Using SMTP AUTH with Postfix 2.2-SASL2-DBMail-MySQL
• Using SMTP AUTH with Sendmail
• CentOS 4.2 SMTP AUTH with Postfix 2.1.5-SASL2-DBMail-MySQL-DBMA
• Some other SMTP AUTH stuff that needs to be categorized
• Sys V style startup scripts for DBMail
• How to setup SSL connections with DBMail using Stunnel Updated
• How to setup Postfix - DSPAM - DBMAIL Updated
• Postfix - sasl/tls - MailScanner - DBMail
• Sendmail: Howto configure sendmail with dbmail
• Debian/exim4/Spamassassin/clamAV with DBMail 2.x
• CentOS Exim + DBMail
• Mailing lists with Mailman
• FreeBSD Qmail+DBMAIL Installation Guide
• How to setup DBMail + MySQL + LDAP
• How to Setup DBmail + Postfix + ActiveDirectory
• Debian Stable DBMail 2.1xx
• Setup DBMail 2.1xx under xinetd
• Compiling from SVN
• Setting up postfix + procmail + DBmail sans local users
• train bogofilter on a per user level
• Enhancing the speed of dbmail 2.2 with PostgreSQL: CLUSTER and two unneeded indices removed
• DBMAIL, MySQL, Postfix and SMTP-Auth under Debian (GERMAN)
• Integreate DBMail in iRedMail

• Shared Mailboxes with DBMail
• Logging in DBMail
• Auto Responder in DBMAIL 2.0
• Domain Alias & Spam Bounce with Postfix & DBMAIL
• Setting up DBMail on OpenBSD
• Archiving with Postfix and DBMail
• Setting up per-user filters in the Debian builds of DBMail 2.0
• SQL to add user for developers
• Restoring a dbmail dump
• Semantics of folder permissions
• Using IMAPSYNC to transport from some IMAP server into dbmail

• Migrating from Qmail/Vpopmail/SQL
• Exporting DBMail users to maildir format. (ver 1.x)
• Exporting DBMail users to maildir format. (ver 2.0.x)
• Migration from Sendmail+Dovecot

Here are some Logo ideas and Tagline ideas. Might have been good to hit 2.2.0 with a strong brand identity, but better late than never – we should come up with something we like!

Follow these links to go to information on new proposals. If you have any worked-out proposals, please feel free to add them here. Please do not post things that have not yet been discussed and some general consensus reached on the dbmail-dev mailing list yet. The wiki is not a discussion board!

• Mailing lists

• Organizing users in groups

• Having (most of the) configuration in the Database
• Configuration Daemon
• Support SQL standard schemas (a.k.a. namespaces)
• IP based traffic control

• Broad goals for clustering
• Token passing algorithm

• How to provide guarantees with privilege separation
• Stopping denial of service attacks, resource exhaustion, and other kinds of mischief

These are some ideas for the future – without any promise of implementation, of course.

• IMAP V-Folders - finally, true server-side virtual folders
• More flexible Auto Replies, Auto Notifications
• Mail Client Settings on DBMail: a proposal for keeping per-user mail client configuration settings inside the DBMail system
• Blacklisting Individualized for User
• Individualized Message Filters
• Split the deliver_to field of the aliases table
• Make default accounts for RFC required addresses, such as POSTMASTER, etc.
• Better options for controlling daemonizing
• Indexed bodysearches in IMAP
• Ability to delete mail older than n days
• Ability to alter the main SQL queries in the config file
• Ability to set daemon response messages
• workgroup features
• message stored as files over http with failover - option to store messages as files on multiple servers via http.
• Mysql S3 Storage Plug-in for hugely scalable message store.
• Store Exchange message envelope journal info in different field or table.

• Reserved words in SQL standards
• Reserved characters in email addresses

If there's a feature that you'd like to help along, but lack the available time or coding skill to write it, consider sponsoring a Code Bounty!

• Completion of Sieve functionality, 100% compatible with Cyrus implementation. $500 kbaker at missionvi dot c0m

• Re-write existing MySQL table creation script to work with MySQL Cluster (fk and other non-NDB-friendly portions) with negligible performance and relaibility impact. $500 patrick.cheong at xanadu dot com dot my

• DBMailAdmin, web-based admin panel, free and open source, under active development. http://dbmailadmin.org/
• SimpleDBMailAdmin, PHP, AJAX, MySQL and PostgreSQL, web-based admin panel for DBMail 3.0.x . Simple GUI, simple to install, free and open source. http://code.google.com/p/simple-dbmail-admin/
• DBMail Admin, PHP web based DBMAIL User/Mailbox Adminstrator. Currently this is for SQL based authentication. Full LDAP support is being investigated. This tool can run on a separate web server provided that PHP has the correct DB support, network access to the dbmail database, a copy of the dbmail.conf, and the dbmail binaries+libraries installed. Current version is 0.1.1b Download Here
• DBMail-QuotaCheck, PERL Script (runs perfectly via cron e.g. once per day) which does check usage of quota, sends warning mails and empties mailboxes that are full. Download Here
• dbmail-export - PHP script to export a user's email into mbox format. Has capability to specify date range for backup and individual mailbox. Currently only supports PostgreSQL, but should be easy to convert to MySQL. This script is only for 2.0.x train, as 2.1 will have its own version.
• train_dspam.sh - Shell Script to extract messages from dbmail Shared Folders and to post them into the dspam system to train as either spam or ham. Requires that the DSPAM ID is added to the headers - Set Preference “signatureLocation=headers” in dspam.conf.
• dbmail_acl.sh - Bash script to manage ACLs for shared mailboxes.
• mysql_backup.sh - MySQL incremental backup script, run by cron (e.g. every 20 minutes). Uses binary logs, rotates them, archives unused logs, makes full backup (gzipped dump) at a specified time, deletes old archives due to defined policy.
• DBMail Auto Delete - SQL code and discussion regarding the task of marking messages older than n days for deletion.