Loading ...
Sorry, an error occurred while loading the content.

Re: Integrating Postfix, SQL, and Mailman with Virtual hosts

Expand Messages
  • Robert Moskowitz
    ... Only for a year and a month for me. I am getting ready to update with a new server and add mailman as well and THEREIN is the challenge. How mailman
    Message 1 of 3 , Dec 1, 2010
    • 0 Attachment
      On 12/01/2010 04:51 PM, Curtis Maurand wrote:
      >
      > 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
      > well.

      Only for a year and a month for me. I am getting ready to update with a
      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:
      >>
      >> http://wiki.amahi.org/index.php/Amahi_Mail_System
      >>
      >> That was created using the instructions at:
      >>
      >> http://www.howtoforge.com/virtual-users-domains-postfix-courier-mysql-squirrelmail-fedora-12-x86_64
      >>
      >>
      >> 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 =
      >> proxy:mysql:/etc/postfix/mysql-virtual_domains.cf'
      >>
      >> 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!
      >>
      >>
      >
      >
    Your message has been successfully submitted and would be delivered to recipients shortly.