Comments on Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 10.04)

This document describes how to install a mail server based on Postfix 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.

5 Comment(s)

Add comment

Please register in our forum first to comment.

Comments

By: Rick Stanley

I wish people would stop tagging every posting with Ubuntu! Most of the postings involved with the installation and configuration of software I have seen tagged with "Ubuntu" can also be done with MANY different Distros, including this one! You would think that there is only ONE Distro available! NOT!!!

Take a look at the top ten Distributions: DistroWatch

By: Anonymous

Did you not notice that distro-specific how-to's are what's created here for some topics? Calm down. This article, and in fact no post on this site claims Ubuntu is the end-all of linux.

By: Mohamed Elsayed

Dear Falko:

 many thanks for this great effort; actually I have installed my mail server before based on Christoph Haas tutorial at http://workaround.org. it was very helpful, and works 100%.

but for my need, there was something missing which is the mailing lists; I wanted to integrate mailman or any of mailing list management SW to be able to create mailing lists (for example [email protected]) and add the sales users to this list.

it will be perfect if you could complete this part in your great  tutorial which is (as I think) is very important for a many people.

I sent a comment like this to Christoph Haas on http://workaround.org and I noticed that another people also were interested to add this feature to their implementation. 

 

thanks again for you and I hope you can find a time to complete it soon.

 

By:

you could use the forward table, create a user and add all the emails to it

example: create user [email protected]

and add  the users [email protected]

                               [email protected]

and etc, this would be all done in the sql table forwards

I would use phpadmin much easier

By: eric.ni

I follow this,and the tables like this:

mysql> select * from forwardings;
+------------------+----------------------------------+
| source           | destination                      |
+------------------+----------------------------------+
| @test.com     | [email protected]                 |
| [email protected] | [email protected],[email protected] |
+------------------+----------------------------------+
 then i sent a email to [email protected], only test usr can receive this email. but when i sent a email to a invalid user,eric user can receive a email.

Anyone can help me?