[Mailman-Users] Mailman, Postfix and MySQL-based virtual domains

[lkolchin at univ.haifa.ac.il]

Hi,

You could check the "Web-Cyradm and Mailman Integration HOWTO" - http://archives.free.net.ph/message/20050828.134201.19d55b0e.en.html
I've wrote some time ago.

This should solve your problem.

Best Regards,
Leon Kolchinsky

-----Original Message-----
From: Mark Sapiro [mailto:msapiro at value.net] 
Sent: Thursday, January 26, 2006 4:49 AM
To: werner_schalk at gmx.de; mailman-users at python.org
Subject: Re: [Mailman-Users] Mailman, Postfix and MySQL-based virtual domains

Werner Schalk wrote:

>I created some mailing lists. But when I try to 
>send a mail to one of them I get the following error message in my log file:
>
>NOQUEUE: reject: RCPT from unknown[62.8.A.B]: 550 <testlist at domain.tld>: 
>Recipient address rejected: User unknown in virtual mailbox table; 
>from=<me at domain.tld> to=<testlist at domain.tld> proto=ESMTP 
>helo=<mysystem.network.localnet>
>Jan 25 22:52:54 myserver postfix/smtpd[6906]: > unknown[62.8.A.B]: 550 
><testlist at domain.tld>: Recipient address rejected: User unknown in virtual 
>mailbox table
>
>My Postfix config file is as follows (digest):
>
>owner_request_special = no
>recipient_delimiter = +
>
>virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf, 
>hash:/usr/local/mailman/data/virtual-mailman
>virtual_gid_maps = static:211
>virtual_mailbox_base = /home/virtmail
>virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains_maps.cf
>virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
>virtual_transport = virtual
>virtual_uid_maps = static:211
>
>So according to http://www.list.org/mailman-install/postfix-virtual.html and 
>what I have found on the web, Postfix should consult 
>both /etc/postfix/mysql_virtual_alias_maps.cf 
>and /usr/local/mailman/data/virtual-mailman in order to handle the mail (the 
>*.db file does exist in /usr/local/mailman/data/virtual-mailman.db). 


I am not a Postfix user and I know little about it, but I think in
addition to the virtual_alias_maps above, you also need alias_maps
with at least hash:/usr/local/mailman/data/aliases. See
<http://www.list.org/mailman-install/node13.html>. (Sec 6.1.2 is in
addition to 6.1.1, not instead of)

-- 
Mark Sapiro <msapiro at value.net>       The highway is for gamblers,
San Francisco Bay Area, California    better use your sense - B. Dylan