![\"Postfix\"](\"http:\/\/tom.scholten.nu\/weblog\/wp-content\/uploads\/2007\/03\/postfix1.gif\" "\\"Postfix\\"")
<\/td>\n![\"logo_250x80\"](\"http:\/\/tom.scholten.nu\/weblog\/wp-content\/uploads\/2013\/02\/logo_250x80.jpg\"){kind=logo}
<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/p>\n
<\/p>\n
As my\u00c2\u00a0PostfixLDAP howto<\/a> is getting agy and less used with a request from a fellow web-company and one of the main CT<\/a> customers I’ve decided to write down a comprehensive guide on how to install a mailserver using Postfix based on MySQL – obviously with all the things I think you’ll need with that!<\/p>\n This howto will \u00c2\u00a0– if succesfully deployed – give you an (FreeBSD) Postfix MySQL ViMbAdmin setup with Dovecot, RoundCube and MailScanner. Say what?<\/p>\n Rules of engagement<\/b><\/p>\n This only describes how to build a mail-host on a secure, trusted, local network. We are not dealing with some of the things you should have in place first<\/p>\n We do not take any responsibility for your setup – this howto serves as a recipe on how you could do it. Read it and interpret it but create your own secure<\/strong> solution!<\/span><\/p>\n Documentation sources<\/b><\/p>\n FreeBSD 9.1 base install<\/b><\/p>\n install \u00e2\u20ac\u02dcplain\u00e2\u20ac\u2122 (no lib32\/games\/doc) with ports Add to \/etc\/rc.conf<\/p>\n sendmail_enable=”NO”<\/em><\/span> Edit \/etc\/make.conf Prepare ports<\/strong><\/p>\n Fetch the below \/var\/db\/ports contents Build the following<\/strong><\/p>\n # portmaster mail\/postfix databases\/mysql55-server mail\/roundcube mail\/dovecot2 mail\/dovecot2-pigeonhole www\/apache22 lang\/php5 lang\/php5-extensions devel\/git devel\/subversion www\/smarty3 www\/zend-framework databases\/pear-Doctrine12 ftp\/wget shells\/bash mail\/mailscanner databases\/p5-DBD-mysql<\/em><\/span><\/p>\n Note; do not<\/strong> build MailScanner with bdc<\/span><\/em>!<\/p>\n Prepare database environment<\/strong> > use mysql;<\/span><\/em> # mysql -uroot -p<\/span><\/em><\/p>\n > create database webmail;<\/span><\/em> # mkdir -p \/home\/vmail<\/span><\/em> > \u00e2\u20ac\u0153vmail\u00e2\u20ac\u009d as username<\/span><\/em> # chown -R vmail:mail \/home\/vmail<\/span><\/em><\/p>\n Dovecot:<\/strong><\/p>\n # cp -pfr \/usr\/local\/share\/doc\/dovecot\/example-configs\/* \/usr\/local\/etc\/dovecot\/<\/span><\/p>\n Adjust according to Postfix:<\/strong><\/p>\n Add to \/usr\/local\/etc\/postfix\/master.cf Add the contents of http:\/\/www.compa.nl\/tmp\/mailserver.postfix.main.cf.add.txt<\/a>\u00c2\u00a0to main.cf<\/p>\n\n
\n
\n
\n
\n# freebsd-update fetch
\n<\/i># portsnap fetch
\n<\/i># cd \/usr\/ports\/ports-mgmt\/portmaster
\n<\/i># make install<\/i><\/span><\/p>\n
\n sendmail_submit_enable=”NO”<\/em><\/span>
\n sendmail_outbound_enable=”NO”<\/em><\/span>
\n sendmail_msp_queue_enable=”NO”<\/em><\/span>
\n mysql_enable=”YES”<\/em><\/span>
\n apache22_enable=”YES”<\/em><\/span>
\n postfix_enable=”YES”<\/em><\/span>
\n dovecot_enable=”YES”<\/em><\/span><\/p>\n
\nWITHOUT_X11=yes<\/em><\/span><\/p>\n
\nhttp:\/\/www.compa.nl\/tmp\/mailserver.ports.tgz<\/a><\/p>\n
\n# mysql -uroot<\/span><\/em><\/p>\n
\n > update user SET password=password(\u00e2\u20ac\u02dcmastersecret0\u00e2\u20ac\u2122) where user=\u00e2\u20ac\u02dcroot\u00e2\u20ac\u2122;<\/span><\/em>
\n > flush privileges;<\/span><\/em>
\n > quit;<\/span><\/em><\/p>\n
\n > grant ALL ON webmail.* to \u00e2\u20ac\u02dcroundcube\u00e2\u20ac\u2122@localhost IDENTIFIED by \u00e2\u20ac\u02dcsecret0\u00e2\u20ac\u2122;<\/span><\/em>
\n > create database mailscanner;<\/span><\/em>
\n > grant ALL ON mailscanner.* to \u00e2\u20ac\u02dcmailwatch\u00e2\u20ac\u2122@localhost IDENTIFIED by \u00e2\u20ac\u02dcsecrety\u00e2\u20ac\u2122;<\/span><\/em>
\n > grant file on *.* to mailwatch@localhost identified by \u00e2\u20ac\u02dcsecrety\u00e2\u20ac\u2122;<\/span><\/em>
\n > create database postfixmail;<\/span><\/em>
\n > grant ALL ON postfixmail.* to \u00e2\u20ac\u02dcvimbadmin\u00e2\u20ac\u2122@localhost IDENTIFIED by \u00e2\u20ac\u02dcsecret1\u00e2\u20ac\u2122;<\/span><\/em>
\n > grant SELECT ON postfixmail.* to ‘dovecot’@’localhost’ IDENTIFIED by ‘secret2’;<\/span><\/em>
\n > grant SELECT ON postfixmail.* to ‘postfix’@’localhost’ IDENTIFIED by ‘secret3’;<\/span><\/em>
\n > grant SELECT, RELOAD, LOCK TABLES ON *.* to ‘backup’@’localhost’ IDENTIFIED by ‘secret4’;<\/span><\/em>
\n > flush privileges;<\/span><\/em>
\n > quit;<\/span><\/em><\/p>\n
\n# chmod 770 \/home\/vmail<\/span><\/em>
\n# vi \/etc\/group<\/span><\/em>
\nAdd a group \u00e2\u20ac\u02dcvmail\u00e2\u20ac\u2122 with id 2000<\/span>
\n# useradd<\/span><\/em><\/p>\n
\n > \u00e2\u20ac\u0153Virtual Mailbox\u00e2\u20ac\u009d as description
\n> id 2000
\n<\/span><\/em>> \/home\/vmail as directory
\n<\/span><\/em>> group = vmail
\n<\/span><\/em>> additional groups = mail
\n<\/span><\/em><\/em><\/em>> nologin<\/span><\/em><\/em><\/em><\/em><\/p>\n
\nhttp:\/\/www.compa.nl\/tmp\/mailserver.dovecott.diff.txt<\/a><\/p>\n
\n# Dovecot LDA<\/em><\/span>
\n dovecot unix – n n – – pipe<\/em><\/span>
\n flags=DRhu user=vmail:mail argv=\/usr\/local\/libexec\/dovecot\/deliver -d ${recipient}<\/em><\/span><\/p>\n