Comments on Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 12.04 LTS)
This document describes how to install a Postfix mail server that is based on virtual users and domains, i.e. users and domains that are in a MySQL database. I'll also demonstrate the installation and configuration of Courier, so that Courier can authenticate against the same MySQL database Postfix uses. The resulting Postfix server is capable of SMTP-AUTH and TLS and quota. Passwords are stored in encrypted form in the database. In addition to that, this tutorial covers the installation of Amavisd, SpamAssassin and ClamAV. I will also show how to install SquirrelMail as a webmail interface.
12 Comment(s)
Comments
Hi....
make: *** [maildir.o] Error 1
make: Leaving directory `/usr/src/postfix-2.9.1/src/smtpd'
make[1]: *** [update] Error 1
make[1]: Leaving directory `/usr/src/postfix-2.9.1'
make: *** [build] Error 2
dpkg-buildpackage: error: debian/rules build gave error exit status 2
help what to do?
I had the same problem with Ubuntu 12.04 and postfix 2.9.3 with vda-patch 2.9.1. German language breaks postfix compilation:
../../lib/libdns.a: undefined reference to `__res_search'
../../lib/libdns.a: undefined reference to `__dn_expand'
collect2: ld gab 1 als Ende-Status zurück
make: *** [smtpd] Fehler 1</pre>
The reason of this error: missing -lresolv
I found a problem in Postfix makedefs file.
gcc -print-search-dirs | sed -n '/^libraries: =/s/libraries: =//p' didn't work for me, because i have Ubuntu in german language.
The gcc -print-search-dirs output is "Bibliotheken", german word of "libraries".
After changing the sed command the SYSLIBS variable filled in correctly and Postfix compiles fine.
If you got that error above (format not a string literal and no format arguments), it's better to change the code like this:
dsb_simple(why, "5.2.2", limit_message) -> dsb_simple(why, (char*)"5.2.2", "%s", limit_message);
or
dsb_simple(why, "2.0.0", "delivers to maildir") -> dsb_simple(why, (char*)"2.0.0", (char*)"delivers to maildir");
I think it's more elegant than disable hardening build. :)
One more step is necessary to get phpMyAdmin running.
Either:
cat >> /etc/apache2/apache2.conf <<'EOF'
# Include the phpadmin config file
Include /etc/phpmyadmin/apache.conf
EOF
or
sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf.d/phpmyadmin.conf
After either of those (not both!), reload apache2:
/etc/init.d/apache2 reload
Before 'dpkg-buildpackage' don't we need to 'debchange -i' so that the compiled postfix package isn't reverted in next 'apt-get upgrade'?
Great tutorial Falko! Thank you!
Recent 12.04 brings postfix 2.9.6 at this time there is no quota patch for 2.9.6 available, but the patch for 2.9.5 can be applied.
update: patching and compiling works, but it seems to brake something as the chroot is being disabled for postfix and even if re-enabled it outputs errors like postfix/qmgr[1547]: warning: private/smtp socket: malformed response so i reverted back to the unpatched postfix.
To avoid the upgrade of the postfix package you can use the following command:
# echo "postfix hold" | dpkg --set-selections
I've been using this basic setup with Mysql for years on my mail server, so thank you! It's been great. But I have a problem now that I need to be able to specify a few mail forwardings that have multiple destinations for one source, so say the source would be [email protected] and the destination would be [email protected],[email protected]., [email protected] and the email would be delivered to all three. I've tried and it doesn't work with the current setup that is based on this tutorial (it only sends to the first address) - so how would you adapt this setup so that this one-to-many forwarding feature would work?
Try to separate the target addresses with newlines and not by comma. If it's a single line field in the database, then change it to a text field.
We installed and configured the mail server for this guide. How to change a mailbox limit is greater than 2 GB?