Re: Integrating Postfix, SQL, and Mailman with Virtual hosts
- On 12/01/2010 04:51 PM, Curtis Maurand wrote:
>Only for a year and a month for me. I am getting ready to update with a
> I've been doing it with postfix and dbmail for several years. It
> works very well. I also have it running amavisd-new/spamassassin,
> clam anti-virus as well as the fuzzyocr plugin for spamassassin.
> Along with additional rule set and bayes database in MySQL, it works
new server and add mailman as well and THEREIN is the challenge. How
mailman works with postfix...
> On 12/1/2010 4:02 PM, Robert Moskowitz wrote:
>> This is on Fedora 12.
>> I have been running Postfix with SQL, CourierMail, and Squirelmail
>> for over a year. I did this using the setup from:
>> That was created using the instructions at:
>> It works well. I have been running 4 virtual domains with a couple
>> handful of users.
>> Now I want to add Mailman.
>> Amahi runs any new web app in a virtual host. So Squirrelmail is
>> running as https://webmail.foo.com and Mailman will run as
>> http://mailman.foo.com/mailman (supposedly I will be able to reduce
>> this to mailman.foo.com, but one thing at a time).
>> Challenge is that Mailman runs all of its processes as commands via
>> /etc/aliases (or so it seems). For example there are aliases now like:
>> mailman: "|/usr/lib/mailman/mail/mailman post mailman"
>> For the main mailman list. A user subscribed to the list gets have
>> that the user mailman@... does not exist.
>> So I am trying to figure out how to work this integration. The SQL
>> approach with a domains table overrides the 'standard' postfix
>> virtual-domains approach:
>> cat /etc/postfix/mysql-virtual_domains.cf
>> user = mail_admin
>> password = mail_admin_password
>> dbname = mail
>> query = SELECT domain AS virtual FROM domains WHERE domain='%s'
>> hosts = 127.0.0.1
>> postconf -e 'virtual_mailbox_domains =
>> So how do I get the virtual mailman domain to work? I DO have to add
>> mailman.foo.com to the domain table. Without this, postfix responds
>> that mailman@... loops back to itself. With it I get the
>> domain table entry I get mailman@... does not exist. And
>> /etc/aliases can only have local addresses in it, I have learned. I
>> have looked up the transport table, but I can't use that to run
>> commands like what is in the aliases file. What about the forward
>> table? Do I put some form of the command into it? I cannot find any
>> manpage or other on how to work with the forwarding setup.
>> So help here would be greatly appreciated!