Table of Contents:
[OpenBSD 4., postfix-2.3.2]
Customising the base Postfix installation to serve Virtual Accounts.
We’ve installed a few virtual user mail servers, through trial and error, even with the better guides out there, and hopefully these notes adds useful tests, log reviews during the install process to confidently reach a successful install every-time.
These guides will therefore install and test a
This installation exercise we are going to install three virtual domains on a single host, with three virtual accounts for each virtual domain:
Host | myhost.example.org |
Virtual Mail Base Directory | /var/spool/postfix/vmail |
Virtual Domain | alpha.example.org ~ users: alfred, bob, charlie |
Virtual Domain | beta.example.org ~ users: auntie, bill, chou |
Virtual Domain | gamma.example.org ~ users: alistair, ben, cinder |
Using OpenBSD’s Postfix configuration, we will store the virtual mailboxes in: /var/spool/postfix/vmail
[Ref: Postfix Virtual Domain Hosting Howto - VIRTUAL_README.html]
I’ve always had difficulty in getting the full featured database driven virtual email working, so we will go through a slow installation process of installing the non-database driven version first to make sure all other configuration items are correct within Postfix.
* Base Configuration for virtual hosting
* Main Configuration
* Virtual Mailbox
* Virtual Aliases (broken)
* Create system user account for managing virtual mail
* Virtual Mail Accounts
We’ll put in some basic configuration information for virtual hosting into Postfix’s main.cf
File Fragment: /etc/postfix/main.cf
mydestination = $myhostname, localhost.$mydomain, localhost, $mydomain, mail.$mydomain, www.$mydomain, ftp.$mydomain virtual_mailbox_base = /var/spool/postfix/vmail virtual_mailbox_domains = hash:/etc/postfix/virtual/mailbox/domains virtual_mailbox_maps = hash:/etc/postfix/virtual/mailbox/alpha.example.org, hash:/etc/postfix/virtual/mailbox/beta.example.org, hash:/etc/postfix/virtual/mailbox/gamma.example.org virtual_minimum_uid = 900 virtual_transport = virtual virtual_uid_maps = static:901 virtual_gid_maps = static:901
Notes:
We need to layout our files mentioned in the configuration file above and I have chosen the following which is hopefully scaleable if you want to use this as the basis (ignoring the simpler database solution reviewed later.)
* /etc/postfix/virtual - the base directory to store virtual related
configurations
* ./alias - for virtual alias files
* file: common
* ./mailbox - for virtual mailbox files
* file: domains
* file: alpha.example.org
* file: beta.example.org
* file: gamma.example.org
Screen Session
mv /etc/postfix/virtual /etc/postfix/virtual_aliases mkdir -p /etc/postfix/virtual/mailbox mkdir -p /etc/postfix/virtual/aliases mv /etc/postfix/virtual_aliases /etc/postfix/virtual/aliases/common touch /etc/postfix/virtual/mailbox/domains touch /etc/postfix/virtual/mailbox/alpha.example.org touch /etc/postfix/virtual/mailbox/beta.example.org touch /etc/postfix/virtual/mailbox/gamma.example.org
We move the current virtual alias file from /etc/postfix/virtual to /etc/postfix/virtual/aliases.
We specify for postfix which virtual domains we want it to receive email with the following configuration option:
File Fragment: /etc/postfix/main.cf
virtual_mailbox_domains = hash:/etc/postfix/virtual/domains
File:/etc/postfix/virtual/mailbox/domains
alpha.example.org IGNORED_PARAMETER beta.example.org IGNORED_PARAMETER gamma.example.org IGNORED_PARAMETER
After creating or making any changes to the above domains file, recreate the hash database using postmap
# /usr/local/sbin/postmap /etc/postfix/virtual/mailbox/domains
For OpenBSD, the default chroot’d postfix installation stores its files in /var/spool/postfix so we’ll specify the location for virtual email accounts within that structure.
File Fragment: /etc/postfix/main.cf
virtual_mailbox_base = /var/spool/postfix/vmail
When setting up virtual mailboxes (in this manner), it makes sense to structure the directories for scalability and to prevent clashing namespaces. Prior to setting up accounts we’ll consider that our mailbox accounts will be structured by domain.
For example:
We can now create some sample user accounts into our virtual mailbox
File Fragment: /etc/postfix/main.cf
virtual_mailbox_maps = hash:/etc/postfix/virtual/mailbox/alpha.example.org, hash:/etc/postfix/virtual/mailbox/beta.example.org, hash:/etc/postfix/virtual/mailbox/gamma.example.org
Obviously, each valid user needs a corresponding mailbox storage space. The mailbox file is specified relative to the virtual_mailbox_base shown above and since we already have our directory design structure above, we can go ahead and create some accounts.
File: /etc/postfix/virtual/mailbox/alpha.example.org
#account --> Storage location alfred@alpha.example.org alpha.example.org/alfred/ bob@alpha.example.org alpha.example.org/bob/ charlie@alpha.example.org alpha.example.org/charlie/
After creating or making any changes to the above alpha.example.org file, recreate the hash database using postmap
# /usr/local/sbin/postmap /etc/postfix/virtual/mailbox/alpha.example.org
#account --> Storage location auntie@beta.example.org beta.example.org/auntie/ bill@beta.example.org beta.example.org/bill/ chou@beta.example.org beta.example.org/chou/
After creating or making any changes to the above beta.example.org file, recreate the hash database using postmap
# /usr/local/sbin/postmap /etc/postfix/virtual/mailbox/beta.example.org
File: /etc/postfix/virtual/mailbox/gamma.example.org
#account --> Storage location alistair@gamma.example.org gamma.example.org/alistair/ ben@gamma.example.org gamma.example.org/ben/ cinder@gamma.example.org gamma.example.org/cinder/
After creating or making any changes to the above gamma.example.org file, recreate the hash database using postmap
# /usr/local/sbin/postmap /etc/postfix/virtual/mailbox/gamma.example.org
We must now tell postfix to re-read its configuration files, by using postfix reload.
# /usr/local/sbin/postfix reload
Mailbox files (above) can use either mbox or maildir format. To use maildir format, include a slash at the end of the filename. For a discussion of the relative differences you can follow the link to: Benchmarking mbox versus maildir, in short if your have a modern Unix OS (post 2004?) you should not have any problems using maildirs as an efficient scalable system. But read the benchmark and search the web for your own edification.
I have chosen for this example to use separate files per domain, merely for illustration of the flexibility of the system (and if you are insane enough to manage it manually you can at least let the file structure assist you in some manner.)
NOT WORKING YET.
NOT WORKING YET.
[Ref: virtual_uid_maps, virtual_gid_maps]
Mail delivery happens with the recipient’s UID/GID privileges specified with virtual_uid_maps and virtual_gid_maps, therefore the virtual mailbox files must be owned by a system user account and associated with a group on your system. Fortunately Postfix is flexible to allow each mailbox to be owned by a unique system user account or by a single system user account for all domains, and even one system user account per domain. This is set by using the virtual_uid_maps and virtual_gid_maps setting.
virtual_uid_maps = static:901 virtual_gid_maps = static:901
The ‘static’ map type tells Postfix that you want the uid/gid to be for all accounts.
We can now create the system user account to manage virtual email mailboxes.
Screen Session
useradd -d /var/spool/postfix/vmail -g=uid -u 901 \ -s /sbin/nologin -m -c 'Virtual Mailbox Owner' _vmail chmod -R 770 /var/spool/postfix/vmail
A by-product of the user/group creation is that the ‘base’ directory will also be created with the correct permissions.
If we wanted to use different users, groups for managing mailboxes, then we could have used a lookup file instead.
virtual_uid_maps = hash:/etc/postfix/virtual_uids virtual_gid_maps = hash:/etc/postfix/virtual_gids
Ensure the standard (non-virtual) alias file is built by using Postfix’s newaliases.
/usr/local/sbin/newaliases
Restart Postfix
/usr/local/sbin/postfix stop /usr/local/sbin/postfix start
Use postconf -n to compare whether what we expect in virtual_* parameter settings is what is running on the system.
Screen Session
postconf | grep ^virtual
virtual_alias_domains = $virtual_alias_maps virtual_alias_expansion_limit = 1000 virtual_alias_maps = $virtual_maps virtual_alias_recursion_limit = 1000 virtual_destination_concurrency_limit = $default_destination_concurrency_limit virtual_destination_recipient_limit = $default_destination_recipient_limit virtual_gid_maps = static:901 virtual_mailbox_base = /var/spool/postfix/vmail virtual_mailbox_domains = hash:/etc/postfix/virtual/domains virtual_mailbox_limit = 51200000 virtual_mailbox_lock = fcntl virtual_mailbox_maps = hash:/etc/postfix/virtual/mailbox/alpha.tbu.to, hash:/etc/postfix/virtual/mailbox/beta.tbu.to, hash:/etc/postfix/virtual/mailbox/gamma.tbu.to virtual_minimum_uid = 900 virtual_transport = virtual virtual_uid_maps = static:901
Remember to use the /var/log/maillog file to validate postfix has started without errors. You can also repeat the above ’telnet localhost smtp’ to review nothing has drastically broken.
Screen Session
$ telnet localhost smtp
Trying ::1... Connected to localhost. Escape character is '^]'. 220 myhost.example.org ESMTP Postfix (2.3.2) ehlo example.org 250-myhost.example.org 250-PIPELINING 250-SIZE 10240000 250-VRFY 250-ETRN 250-ENHANCEDSTATUSCODES 250-8BITMIME 250 DSN
mail from: <samt@example.org>
250 2.1.0 Ok
rcpt to: <alfred@alpha.example.org>
250 2.1.5 Ok
rcpt to: <auntie@beta.example.org>
250 2.1.5 Ok
rcpt to: <alistair@gamma.example.org>
250 2.1.5 Ok
data
354 End data with <CR><LF>.<CR><LF>
Subject: Welcome Virtual Users Hopefully you are all virtually OK. Welcome to email .
250 2.0.0 Ok: queued as BA1FC5A950
quit
221 2.0.0 Bye Connection closed by foreign host.
The corresponding /var/log/maillog entry should look something like the following
File: /var/log/maillog
connect from unknown[::1] client=unknown[::1] message-id=<20070208214647.BA1FC5A950@myhost.example.org> from=<samt@example.org>, size=393, nrcpt=3 (queue active) to=<alfred@alpha.example.org>, relay=virtual, delay=69, delays=67/0.05/0/1.8, dsn=2.0.0, status=sent (delivered to maildir) to=<auntie@beta.example.org>, relay=virtual, delay=69, delays=67/0.05/0/1.9, dsn=2.0.0, status=sent (delivered to maildir) to=<alistair@gamma.example.org>, relay=virtual, delay=69, delays=67/0.14/0/1.9, dsn=2.0.0, status=sent (delivered to maildir) removed disconnect from unknown[::1]
We should also be able to see evidence of the virtual account mails in the file system such as has occurred on this installation.
Screen Session
# ls -l /var/spool/postfix/vmail/alpha.example.org/alfred/new/
total 4 -rw------- 1 _vmail _vmail 481 Feb 9 10:47 1170971257.V5I5a95aM294234.myhost.example.org
cat /var/spool/postfix/vmail/alpha.example.org/alfred/new/1170971257.V5I5a95aM294234.myhost.example.org
Return-Path: <samt@example.org> X-Original-To: alfred@alpha.example.org Delivered-To: alfred@alpha.example.org Received: from example.org (unknown [IPv6:::1]) by myhost.example.org (Postfix) with ESMTP id BA1FC5A950; Fri, 9 Feb 2007 10:46:30 +1300 (TOT) Subject: Welcome Virtual Users Message-Id: <20070208214647.BA1FC5A950@myhost.example.org> Date: Fri, 9 Feb 2007 10:46:30 +1300 (TOT) From: samt@example.org To: undisclosed-recipients:; Hopefully you are all virtually OK. Welcome to email
We can likewise confirm the same message was received for aunti@beta.example.org and alistair@gamma.example.org.
Mischa Peters at high5.net has created a great tool for managing virtual user email accounts based on Postfix. We will look at installing and testing the foundation database configuration here.
To minimise tools being reviewed for debugging, we’re going to attempt installing MySQL support, using the postfixadmin data tables, but without installing or using postfixadmin.
The following notes differs from a standard postfixadmin install in how it uses usernames, largely because it simplifies things for my understanding. The whole process has helped me to better understand the interactions between these different applications, finding methods for debugging installation problems. I hope it also simplifies for our understanding.
Please refer to our MySQL notes for how to install MySQL for OpenBSD.
Following Mischa’s instructions at Postfix Wiki, Virtual Users and Domains we’ll take a look at:
Much of these database settings are straight out of the postfixadmin/DATABASE_MYSQL.TXT file with slight/inane modifications where it helps me find things more legible.
The key differentiators between these database instructions than the default install are as follows:
* database name is: mail instead of postfix
* postfix user account is: postfixserver instead of postfix
* populated sample data: username is different, password is different
Minor quibbles but makes the install instructions slightly more legible?
We will first log into the mysql server with an account that has root/administrator privileges and insert (copy/paste) sql commands below.
Screen Session
$ mysql -u root -p
Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 41 to server version: 5.0.24a-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql>
The rest of the ‘greyed’ instructions can be copy/pasted into your MySQL monitor above. Be sure to change your usernames and passwords as appropriate.
The first thing we want is to tell mysql that we want to modify the records relating to user accounts for the database server.
mysql client session
USE mysql;
Next, we want to create some new settings for a new user ‘postfixserver’ that we want to designate for use by the postfix server.
mysql client session
INSERT INTO user (Host, User, Password) VALUES ('localhost','postfixserver', password('postfixserver')); INSERT INTO db (Host, Db, User, Select_priv) VALUES ('localhost','mail','postfixserver','Y');
Next, we want to create a new user ‘postfixadmin’ that we want to designate for use by the postfixadmin application.
mysql client session
INSERT INTO user (Host, User, Password) VALUES ('localhost','postfixadmin', password('postfixadmin')); INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv) VALUES ('localhost', 'mail', 'postfixadmin', 'Y', 'Y', 'Y', 'Y');
To ensure that these new user settings have been loaded into use, we flush the settings.
mysql client session
FLUSH PRIVILEGES;
Now, we want to set privileges for the database that we will be using.
mysql client session
GRANT USAGE ON mail.* TO postfixserver@localhost; GRANT SELECT, INSERT, DELETE, UPDATE ON mail.* TO postfixserver@localhost; GRANT USAGE ON mail.* TO postfixadmin@localhost; GRANT SELECT, INSERT, DELETE, UPDATE ON mail.* TO postfixadmin@localhost;
Next, we create the database itself.
mysql client session
CREATE DATABASE mail;
The next stage is to create the relevant tables and some dummy/sample data.
The alias table will store/retrieve our virtual aliases (which I have not yet
mysql client session
USE mail; CREATE TABLE `alias` ( `address` varchar(255) NOT NULL default '', `goto` text NOT NULL, `domain` varchar(255) NOT NULL default '', `created` datetime NOT NULL default '0000-00-00 00:00:00', `modified` datetime NOT NULL default '0000-00-00 00:00:00', `active` tinyint(1) NOT NULL default '1', PRIMARY KEY (address), KEY address (`address`) ) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Aliases';
The domain table will store/retrieve our virtual domains
mysql client session
CREATE TABLE `domain` ( `domain` varchar(255) NOT NULL default '', `description` varchar(255) NOT NULL default '', `aliases` int(10) NOT NULL default '0', `mailboxes` int(10) NOT NULL default '0', `maxquota` int(10) NOT NULL default '0', `quota` int(10) NOT NULL default '0', `transport` varchar(255) default NULL, `backupmx` tinyint(1) NOT NULL default '0', `created` datetime NOT NULL default '0000-00-00 00:00:00', `modified` datetime NOT NULL default '0000-00-00 00:00:00', `active` tinyint(1) NOT NULL default '1', PRIMARY KEY (`domain`), KEY domain (`domain`) ) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Domains';
The mailbox table will store/retrieve the usernames, passwords, and file directories
mysql client session
USE mail;
CREATE TABLE `mailbox` ( `username` varchar(255) NOT NULL default '', `password` varchar(255) NOT NULL default '', `name` varchar(255) NOT NULL default '', `maildir` varchar(255) NOT NULL default '', `quota` int(10) NOT NULL default '0', `domain` varchar(255) NOT NULL default '', `created` datetime NOT NULL default '0000-00-00 00:00:00', `modified` datetime NOT NULL default '0000-00-00 00:00:00', `active` tinyint(1) NOT NULL default '1', PRIMARY KEY (`username`), KEY username (`username`) ) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Mailboxes';
The database is now created, and we might as well configure the other tables used by postfixadmin
mysql client session
USE mail;
CREATE TABLE `admin` ( `username` varchar(255) NOT NULL default '', `password` varchar(255) NOT NULL default '', `created` datetime NOT NULL default '0000-00-00 00:00:00', `modified` datetime NOT NULL default '0000-00-00 00:00:00', `active` tinyint(1) NOT NULL default '1', PRIMARY KEY (`username`), KEY username (`username`) ) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Admins';
mysql client session
USE mail;
CREATE TABLE `domain_admins` ( `username` varchar(255) NOT NULL default '', `domain` varchar(255) NOT NULL default '', `created` datetime NOT NULL default '0000-00-00 00:00:00', `active` tinyint(1) NOT NULL default '1', KEY username (`username`) ) TYPE=MyISAM COMMENT='Postfix Admin - Domain Admins';
USE mail;
CREATE TABLE `log` ( `timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `username` varchar(255) NOT NULL default '', `domain` varchar(255) NOT NULL default '', `action` varchar(255) NOT NULL default '', `data` varchar(255) NOT NULL default '', KEY timestamp (`timestamp`) ) TYPE=MyISAM COMMENT='Postfix Admin - Log';
mysql client session
USE mail;
# # Table structure for table vacation # CREATE TABLE `vacation` ( `email` varchar(255) NOT NULL default '', `subject` varchar(255) NOT NULL default '', `body` text NOT NULL default '', `cache` text NOT NULL default '', `domain` varchar(255) NOT NULL default '', `created` datetime NOT NULL default '0000-00-00 00:00:00', `active` tinyint(1) NOT NULL default '1', PRIMARY KEY (`email`), KEY email (`email`) ) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Vacation';
We will populate our database with some test data that you can easily remove later using GUI Admin. By using our sample data below we avoid having to configure postfixadmin to have a working test server.
We will replicate our virtual user system used with the above hash files into our MySQL database.
This is largely relevant only if you will be installing postfixadmin, and can be skipped.
Now, here’s one part where the standard documentation always got me lost. The standard instructions provides the below image which will work for logging into the system, but will cause other problems. Instead of the following instructions
superadmin user & password (login: admin@domain.tld, password: admin)
INSERT INTO domain_admins (username, domain, active) VALUES ('admin@domain.tld','ALL','1'); INSERT INTO admin (username, password, active) VALUES ('admin@domain.tld','$1$0fec9189$bgI6ncWrldPOsXnkUBIjl1','1');
We will be using the following instructions which uses CRYPT instead of postfixadmin’s md5crypt for encrypting the password to:
mysql client session
USE mail;
INSERT INTO admin (username, password, active) VALUES ('admin','6dwLx9NTxhTjU','1'); INSERT INTO domain_admins (username, domain, active) VALUES ('admin','ALL','1');
When installing postfixadmin, from the above settings, we set:
File: /var/www/htdocs/postfixadmin/config.inc.php
$CONF['encrypt'] = 'system';
We will be creating virtual domains for our three sample domains:
Creating our virtual domains<
mysql client session
USE mail;
INSERT INTO domain (domain,description,aliases,mailboxes,maxquota, quota,transport,backupmx,active) VALUES ('alpha.example.org', 'Alpha Tester','10','10', '0','0','virtual', '0','1'); INSERT INTO domain (domain,description,aliases,mailboxes,maxquota, quota,transport,backupmx,active) VALUES ('beta.example.org', 'Beta Site','10','10', '0','0','virtual', '0','1'); INSERT INTO domain (domain,description,aliases,mailboxes,maxquota, quota,transport,backupmx,active) VALUES ('gamma.example.org', 'Gamma Born','10','10', '0','0','virtual', '0','1');
We can verify that the data has been entered correctly with the following simple test. From the command prompt, start mysql.
Screen Session
# mysql -u root -p
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 94 to server version: 5.0.24a-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use mail;
Database changed
mysql> select domain, transport from domain;
+--------------+-----------+ | domain | transport | +--------------+-----------+ | alpha.example.org | virtual | | beta.example.org | virtual | | gamma.example.org | virtual | +--------------+-----------+ 3 rows in set (0.00 sec)
As from our example above, we will be creating virtual mailboxes (virtual user accounts) for our above three sample domains:
Creating our virtual users for alpha.example.org : password is username
mysql client session
USE mail; INSERT INTO mailbox (username,password,name,maildir,quota,domain,active) VALUES ('alfred@alpha.example.org', '82fU0EHEzA6wo', 'Alfred', 'alpha.example.org/alfred@alpha.example.org/', '0','alpha.example.org','1' ); INSERT INTO mailbox (username,password,name,maildir,quota,domain,active) VALUES ('bob@alpha.example.org','1bdyGcAE/JC0I', 'Bob','alpha.example.org/bob@alpha.example.org/', '0','alpha.example.org','1' ); INSERT INTO mailbox (username,password,name,maildir,quota,domain,active) VALUES ('charlie@alpha.example.org','048qvFjqS3zBc', 'Charlie','alpha.example.org/charlie@alpha.example.org/', '0','alpha.example.org','1' );
Creating our virtual users for beta.example.org : password is username
mysql client session
USE mail; INSERT INTO mailbox (username,password,name,maildir, quota,domain,active) VALUES ('auntie@beta.example.org', '3336RmmvRQ0NU', 'Auntie','beta.example.org/auntie@beta.example.org/', '0','beta.example.org','1' ); INSERT INTO mailbox (username,password,name,maildir, quota,domain,active) VALUES ('bill@beta.example.org', 'fbVsBHcPJVVjU', 'Bill','beta.example.org/bill@beta.example.org/', '0','beta.example.org','1' ); INSERT INTO mailbox (username,password,name,maildir, quota,domain,active) VALUES ('chou@beta.example.org', '359nFQg1J.8nc', 'Chou','beta.example.org/chou@beta.example.org/', '0','beta.example.org','1' );
Creating our virtual users for gamma.example.org : password is username
mysql client session
USE mail; INSERT INTO mailbox (username,password,name, maildir,quota,domain,active) VALUES ('alistair@gamma.example.org', '12XeQqcTNk3YU', 'Alistair','gamma.example.org/alistair@gamma.example.org/', '0','gamma.example.org','1' ); INSERT INTO mailbox (username,password,name, maildir,quota,domain,active) VALUES ('ben@gamma.example.org', '1bKpSqtESjdck', 'Ben','gamma.example.org/ben@gamma.example.org/', '0','gamma.example.org','1' ); INSERT INTO mailbox (username,password,name, maildir,quota,domain,active) VALUES ('cinder@gamma.example.org', '19rP1zls.evZQ', ' Cinder','gamma.example.org/cinder@gamma.example.org/', '0','gamma.example.org','1' );
Remember to change the user domains in the above to your specific virtual domain(s). You can use an sql query such as the below to help verify that you are not using the *.example. domains from this document.
mysql client session
use mail; select username from mailbox; select domain from domain;
[Ref: http://www.postfix.org/postconf.5.html#virtual_uid_maps, http://www.postfix.org/postconf.5.html#virtual_gid_maps]
If you’ve skipped the hash virtual user instructions, then you will need to create the System user Account for Postfix to use for delivering ‘virtual’ mail.
Mail delivery happens with the recipient’s UID/GID privileges specified with virtual_uid_maps and virtual_gid_maps, therefore the virtual mailbox files must be owned by a system user account and associated with a group on your system. Fortunately Postfix is flexible to allow each mailbox to be owned by a unique system user account or by a single system user account for all domains, and even one system user account per domain. This is set by using the virtual_uid_maps and virtual_gid_maps setting.
virtual_uid_maps = static:901 virtual_gid_maps = static:901
The ‘static’ map type tells Postfix that you want the uid/gid to be for all accounts.
We can now create the system user account to manage virtual email mailboxes.
useradd -d /var/spool/postfix/vmail -g=uid -u 901 \ -s /sbin/nologin -m -c 'Virtual Mailbox Owner' _vmail chmod -R 770 /var/spool/postfix/vmail
A by-product of the user/group creation is that the ‘base’ directory will also be created with the correct permissions.
If we wanted to use different users, groups for managing mailboxes, then we could have used a lookup file instead.
virtual_uid_maps = hash:/etc/postfix/virtual_uids virtual_gid_maps = hash:/etc/postfix/virtual_gids
Ensure the standard (non-virtual) alias file is built by using Postfix’s newaliases.
/usr/local/sbin/newaliases
Restart Postfix
/usr/local/sbin/postfix stop /usr/local/sbin/postfix start
Postfix can read it’s configuration data from hash files, text files, and from databases. To tell Postfix that data will be obtained from a MySQL database, we use the ‘mysql:’ prefix to a text file that contains the relevant information for postfix to extract that data.
For our example, modify the above /etc/postfix/main.cf. We can work by just removing the additions made above and replacing them with the following.
File Fragment: /etc/postfix/main.cf
virtual_alias_maps = mysql:/etc/postfix/mysql/alias_maps.cf virtual_gid_maps = static:901 virtual_mailbox_base = /var/spool/postfix/vmail virtual_mailbox_domains = mysql:/etc/postfix/mysql/domains_maps.cf virtual_mailbox_maps = mysql:/etc/postfix/mysql/mailbox_maps.cf virtual_minimum_uid = 900 virtual_transport = virtual virtual_uid_maps = static:901 parent_domain_matches_subdomains =
The /etc/postfix/mysql/*.cf files contain the login information for postfix to access and retrieve the MySQL database/table.
Verify that what we’ve set above is actually what postfix will recognise.
Screen Session
/usr/local/sbin/postfix reload /usr/local/sbin/postconf -n | grep ^virtual
virtual_alias_maps = mysql:/etc/postfix/mysql/alias_maps.cf virtual_gid_maps = static:901 virtual_mailbox_base = /var/spool/postfix/vmail virtual_mailbox_domains = mysql:/etc/postfix/mysql/domains_maps.cf virtual_mailbox_maps = mysql:/etc/postfix/mysql/mailbox_maps.cf virtual_minimum_uid = 900 virtual_transport = virtual virtual_uid_maps = static:901
Key things to watch out for is that we are using the file type: ‘mysql’ and that the file locations specified above will be correct to what we are creating below.
Before we create our text *.cf files, we’ll need to make the directory.
mkdir -p /etc/postfix/mysql
Create the current mysql instruction/configuration files for postfix.
virtual_mailbox_domains = mysql:/etc/postfix/mysql/domains_maps.cf
domains_maps.cf will be used for virtual_mailbox_domains
File:/etc/postfix/mysql/domains_maps.cf
user = postfixserver password = postfixserver hosts = 127.0.0.1 dbname = mail table = domain select_field = domain where_field = domain additional_conditions = and backupmx = '0' and active = '1'
virtual_mailbox_maps = mysql:/etc/postfix/mysql/mailbox_maps.cf
mailbox_maps.cf will be used for virtual_mailbox_maps
File:/etc/postfix/mysql/mailbox_maps.cf
user = postfixserver password = postfixserver hosts = 127.0.0.1 dbname = mail table = mailbox select_field = maildir where_field = username additional_conditions = and active = '1'
virtual_alias_maps = mysql:/etc/postfix/mysql/alias_maps.cf
alias_maps.cf will be used for virtual_alias_maps
File: /etc/postfix/mysql/alias_maps.cf
user = postfixserver password = postfixserver hosts = 127.0.0.1 dbname = mail table = alias select_field = goto where_field = address
Once you’ve created all these mysql files, we can stop and restart postfix and should be working together with postfixadmin for managing virtual user accounts.
/usr/local/sbin/postfix stop /usr/local/sbin/postfix start
We can now provide some sample testing of mail routing through to our virtual accounts, using MySQL as the database.
Screen Session
$ telnet localhost smtp
Trying ::1... Connected to localhost. Escape character is '^]'. 220 myhost.example.org ESMTP Postfix (2.3.2)
ehlo example.org
250-myhost.example.org 250-PIPELINING 250-SIZE 10240000 250-VRFY 250-ETRN 250-ENHANCEDSTATUSCODES 250-8BITMIME 250 DSN
mail from: <samt@example.org>
250 2.1.0 Ok
rcpt to: <charlie@alpha.example.org>
250 2.1.5 Ok
rcpt to: <chou@beta.example.org>
250 2.1.5 Ok
rcpt to: <cinder@gamma.example.org>
250 2.1.5 Ok
data
354 End data with <CR><LF>.<CR><LF>
Subject: Welcome MySQL based virtual users Hopefully you've received this email message without fault ? . 250 2.0.0 Ok: queued as 357E65A950 quit 221 2.0.0 Bye Connection closed by foreign host.
With the following results showing in our log file: /var/log/maillog File: /var/log/maillog
connect from unknown[::1] # client=unknown[::1] # message-id=<20070209010215.45BCC5A956@myhost.example.org> # from=<samt@example.org>, size=402, nrcpt=3 (queue active) # disconnect from unknown[::1] # to=<charlie@alpha.example.org>, relay=virtual, delay=54, delays=52/0.01/0/1.6, dsn=2.0.0, status=sent (delivered to maildir) # to=<chou@beta.example.org>, relay=virtual, delay=54, delays=52/0.03/0/1.7, dsn=2.0.0, status=sent (delivered to maildir) # to=<cinder@gamma.example.org>, relay=virtual, delay=54, delays=52/0.04/0/1.8, dsn=2.0.0, status=sent (delivered to maildir) # removed
We should now have email in the user directories
with the same content as below:
File: /var/spool/postfix/vmail/alpha.example.org/charlie@alpha.example.org
59984.myhost.example.org < Return-Path: <samt@example.org> X-Original-To: charlie@alpha.example.org Delivered-To: charlie@alpha.example.org Received: from example.org (unknown [IPv6:::1]) by myhost.example.org (Postfix) with ESMTP id 45BCC5A956; Fri, 9 Feb 2007 14:02:08 +1300 (TOT) Subject: Welcome MySQL based virtual users Message-Id: <20070209010215.45BCC5A956@myhost.example.org> Date: Fri, 9 Feb 2007 14:02:08 +1300 (TOT) From: samt@example.org To: undisclosed-recipients:;
Hopefully you've received this email message without fault ?
If you’re having problems then you can also take a look at the sql log files at /var/mysql/myhost.log
File: /var/mysql/myhost.log
20 Connect postfixserver@localhost on mail 20 Query SELECT goto FROM alias WHERE address='example.org' 21 Connect postfixserver@localhost on mail 21 Query SELECT domain FROM domain WHERE domain='example.org' 070209 13:50:37 20 Query SELECT goto FROM alias WHERE address='alpha.example.org' 21 Query SELECT domain FROM domain WHERE domain='alpha.example.org' 22 Connect postfixserver@localhost on mail 22 Query SELECT goto FROM alias WHERE address='charlie@alpha.example.org' 22 Query SELECT goto FROM alias WHERE address='@alpha.example.org' 23 Connect postfixserver@localhost on mail 23 Query SELECT maildir FROM mailbox WHERE username='charlie@alpha.example.org' and active = '1' 24 Connect postfixserver@localhost on mail 24 Query SELECT goto FROM alias WHERE address='charlie@alpha.example.org' 24 Query SELECT goto FROM alias WHERE address='@alpha.example.org'070209 13:50:44 20 Query SELECT goto FROM alias WHERE address='beta.example.org' 21 Query SELECT domain FROM domain WHERE domain='beta.example.org' 22 Query SELECT goto FROM alias WHERE address='chou@beta.example.org' 22 Query SELECT goto FROM alias WHERE address='@beta.example.org' 23 Query SELECT maildir FROM mailbox WHERE username='chou@beta.example.org' and active = '1' 24 Query SELECT goto FROM alias WHERE address='chou@beta.example.org' 24 Query SELECT goto FROM alias WHERE address='@beta.example.org' 070209 13:50:55 20 Query SELECT goto FROM alias WHERE address='gamma.example.org' 21 Query SELECT domain FROM domain WHERE domain='gamma.example.org' 22 Query SELECT goto FROM alias WHERE address='cinder@gamma.example.org' 22 Query SELECT goto FROM alias WHERE address='@gamma.example.org' 23 Query SELECT maildir FROM mailbox WHERE username='cinder@gamma.example.org' and active = '1' 24 Query SELECT goto FROM alias WHERE address='cinder@gamma.example.org' 24 Query SELECT goto FROM alias WHERE address='@gamma.example.org' 070209 13:51:24 20 Query SELECT goto FROM alias WHERE address='alpha.example.org' 21 Query SELECT domain FROM domain WHERE domain='alpha.example.org' 20 Query SELECT goto FROM alias WHERE address='beta.example.org' 21 Query SELECT domain FROM domain WHERE domain='beta.example.org' 20 Query SELECT goto FROM alias WHERE address='gamma.example.org' 21 Query SELECT domain FROM domain WHERE domain='gamma.example.org' 25 Connect postfixserver@localhost on mail 25 Query SELECT maildir FROM mailbox WHERE username='charlie@alpha.example.org' and active = '1' 26 Connect postfixserver@localhost on mail 26 Query SELECT maildir FROM mailbox WHERE username='chou@beta.example.org' and active = '1' 27 Connect postfixserver@localhost on mail 27 Query SELECT maildir FROM mailbox WHERE username='cinder@gamma.example.org' and active = '1'
So, if some of the above are not working properly then you at least can get some clues from the above two log files of where you can begin debugging your installation.
Remember that postconf returns what Postfix actually understands from your changes to the ./postfix/main.cf file so it is always a good point to start here to ensure that what you thought you typed in, is actually what postfix is reading.
The next logical step in configuring your email server with Postfix, is to set up an imap/pop3 server. For this exercise, we’ve reviewed instructions to use dovecot.
Below are just collections from other people’s notes, since I haven’t got a ‘high load’ server for testing as yet (otherwise known as machines and ram are dealing well currently.)
You can improve performance in high load environments by sharing database/mysql connections among Postfix smtpd connections.
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql/alias_maps.cf virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql/domains_maps.cf virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql/mailbox_maps.cf
There is a plethora of documentation out there using Postfix with Virtual Accounts, likewise there is also quite a few with OpenBSD as the server operating system.
Postfix Documentation