4.1 Setup for PostgreSQL

First, you must login as a user who has permissions to create databases and users for postgres. This is usually 'postgres' or 'pgsql'.
$ su postgres

Now you must create the user which dbmail will use:
$ createuser dbmail
CREATE USER
Do not allow this user to create new users or databases.

Now set a password for this user:
$ psql template1
postgres=# ALTER USER dbmail WITH PASSWORD 'secret';
ALTER USER
postgres=# \q.

Now create the database:
$ createdb dbmail

Finally, you need to create the tables:
$ psql -U dbmail dbmail < sql/postgresql/create_tables.pgsql

If you are using a large installation, you may wish to use InnoDB as the mysql database backend. To enable InnoDB support in MySQL, you must edit your my.cnf file. Please refer to the MySQL documentation for details. Once InnoDB is installed, you can create the dbmail database as follows:

If using InnoDB:

$ mysql -u root -p < sql/mysql/create_tables_innoDB.mysql

If you choose to use MySQL without InnoDB, use the following instead:
$ mysql -u root -p < sql/mysql/create_tables.mysql

This will create a database called 'dbmail', and all the required tables. Now, you should create a user to access the database as follows:
# mysql -u root mysql
mysql> GRANT ALL PRIVILEGES ON dbmail.* TO dbmail@localhost IDENTIFIED BY 'secret';

This will add a user dbmail, with password 'secret', and grant access to the dbmail database for that user.

N.B At present (dbmail 1.2.1) the 'auto_replies' and 'auto_notifications' are not created for InnoDB. If you wish to use these, you will also need to create the tables as follows:
$ mysql -u root -p dbmail < sql/mysql/add_auto_notification.mysql
$ mysql -u root -p dbmail < sql/mysql/add_auto_reply.mysql

7.1 [DBMAIL]

This section determines how DBMail connects to the database

7.2 [SMTP]

7.3 [POP]

7.4 [IMAP]

9.1 Sendmail

9.2 Postfix

In the master.cf file for postfix add the following:

dbmail    unix  -       n       n       -       -       pipe    flags=  user=dbmail:dbmail argv=/usr/local/sbin/dbmail-smtp -d ${recipient}

The user= field should be the username and groupname under which dbmail runs - usually dbmail and dbmail

<example.com>    dbmail:

Next run:
# postmap /etc/postfix/transport

Edit /etc/postfix/main.cf and add the following:

transport_maps = hash:/etc/postfix/transport

Finally, a postfix reload and if everything goes well mail should be delivered to dbmail. If not, try running postfix with the -v option to see what's going on. If the problem seems to be in dbmail, try changing the tracelevel in dbmail.conf. Tracelevel 5 will return a lot of debugging information.

9.3 Qmail

First, add your domain to /var/qmail/control/rcpthosts:

example.com

Next, add your domain and the dbmail username to /var/qmail/control/virtualdomains

example.com:dbmail

Make sure the file /var/qmail/control/locals exists and is empty! Now create a file in the dbmail user's home directory called .qmail:

|/usr/local/sbin/dbmail-smtp -d ${RECIPIENT:7}

The pipe tells qmail to pipe the email through a command. The ${RECIPIENT:7} takes the Environement Variable $RECIPIENT and chops off the first seven characters. This is needed because the value of RECIPIENT is dbmail-the_email_address. If your dbmail user is not dbmail, you'll need to change the 7 to the number of characters in your dbmail users's name plus one.

The other approach would just be to add a dbmail alias of the form dbmail-bill@example.com for each user...