Comments on Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Debian Squeeze)

Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Debian Squeeze) 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 (Courier-POP3, Courier-IMAP), 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 so that emails will be scanned for spam and viruses. I will also show how to install SquirrelMail as a webmail interface so that users can read and send emails and change their passwords.

5 Comment(s)

Add comment

Please register in our forum first to comment.

Comments

By:

Would love to see PostfixAdmin included in this how-to.

Thanks for the great job, you've saved my butt plenty of times!!!

By: Luciano Talarico

Hi,

I'm working to build a test lab mailserver based on this guide but with postfixadmin for backend. I'm writing some notes so, when I finish, will try to give my contribute. Best regards.

By: Patricio

Dear

 

I see that  you are using  mysql ENCRYPT function to encrypt the password. Can encrypt using  another hashing function like SHA512 or MD5?

 how can I do that?

 I just search a lot and I did not found nothig

Thanks

 

regards

By:

I had a problem with creating these tables due to an error similar to this:-

 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 4

This apparently is because TYPE is now depracated and you should use ENGINE instead.

 

By: Anonymous

to download the good patch version, go to http://vda.sourceforge.net/VDA/ , copy the url of your version and replace the url of the wget line.

 Sorry for my english, i speak french :)