On 16 November 2011 16:18, /dev/rob0 <r...@gmx.co.uk> wrote: > On Wednesday 16 November 2011 03:03:42 Frank Bonnet wrote: > > I have to setup a "virtual" postfix server and I wonder what would > > be the best / most efficient choice for the DB backend ? > > "Best" is subjective. All choices have good and bad points. Local > files, however, have the advantage of not relying on another running > process. > > My small server has a few virtual(8) domains with a sqlite backend. > I'm also keeping other maps, including virtual(5), aliases(5), and > access(5) lookups in sqlite. I'm very pleased with it. > > The one "gotcha" to watch for is that sqlite does not have the > sophisticated access control that a real RDBMS would have. I had to > rely on filesystem permissions. I have the file as root:root 644, but > hardlinked in directories which are restricted: > drwxr-x--- 2 root dovecot 4096 Jul 16 00:14 /etc/dovecot/private/ > drwxr-x--- 2 root postfix 4096 Jul 16 00:14 /etc/postfix/private/ > /etc/postfix/private: > -rw-r--r-- 2 root root 46080 Nov 15 03:21 mail.sqlite > Yes, that one file contains all the Postfix and Dovecot data, other > than local_recipient_maps. > > No, I do not know of a ready-made GUI frontend, but surely there are > generic sqlite frontends which might meet your needs. I'm just typing > SQL commands in sqlite3(1) in a shell. > -- > Offlist mail to this address is discarded unless > "/dev/rob0" or "not-spam" is in Subject: header >
I've been using MySQL as I think it's sufficient for the job. You might also want to check out postfixadmin for creating/destroying mail accounts.
