[Mailman-Users] Help needed Mailman, Postfix with MySQL and Virtual Domain Lists

[George Kasica]

Mark:

Answers to questions below:

As to your comment about using hashes for mailman...I'm thinking that might
be the best course, and for postfix in general, this s a REALLY small
installation as I mentioned and very low traffic realistically. We're not
running YahooGroups here :)



Yes, it uses is postfix_to_mailman.py thought I had that in the other
message.

The directory /var/lib/mailman/lists/skunk-works does exist

Error
====
 is empty

Post
====
Jan 31 02:42:41 2014 (13402) post to mailtest from gkasica at netwrx1.com,
size=15798,
message-id=<1ed525c0d0004e7e8e015c332b0c1cbe at BL2PR05MB177.namprd05.prod.outl
ook.com>, success

Qrunner
=======
Feb 08 15:22:01 2014 (20887) IncomingRunner qrunner started.
Feb 08 15:22:02 2014 (20891) RetryRunner qrunner started.
Feb 08 15:22:02 2014 (20884) ArchRunner qrunner started.
Feb 08 15:22:02 2014 (20890) VirginRunner qrunner started.
Feb 08 15:22:02 2014 (20886) CommandRunner qrunner started.
Feb 08 15:22:02 2014 (20889) OutgoingRunner qrunner started.
Feb 08 15:22:02 2014 (20888) NewsRunner qrunner started.
Feb 08 15:22:02 2014 (20885) BounceRunner qrunner started.

Smtp
====
Feb 08 15:24:41 2014 (20889)
<mailman.0.1391894679.20937.skunk-works at netwrx1.org> smtp to skunk-works for
1 recips, completed in 0.162 seconds
Feb 08 15:45:34 2014 (20889)
<mailman.0.1391895934.21132.skunk-works at netwrx1.org> smtp to skunk-works for
1 recips, completed in 0.085 seconds
Feb 08 15:45:35 2014 (20889)
<mailman.1.1391895934.21132.skunk-works at netwrx1.org> smtp to skunk-works for
1 recips, completed in 0.099 seconds

Vette
=====
Feb 08 16:12:39 2014 (20887) Message discarded, msgid:
<8ec65c559e294241ba9cb4bfa98b6d75 at BN1PR05MB188.namprd05.prod.outlook.com>
Feb 08 16:52:49 2014 (20887) Message discarded, msgid:
<8b7df489fa54454e9c854e3441103899 at BN1PR05MB188.namprd05.prod.outlook.com>


I'm set to receive postings: 
cd /var/lib/mailman/bin

./list_members --regular --nomail=enabled skunk-works
gkasica at netwrx1.com

Not-meetoo is NOT checked

-----Original Message-----
From: Mark Sapiro [mailto:mark at msapiro.net] 
Sent: Sunday, February 09, 2014 10:53 AM
To: George Kasica
Cc: Mailman Users
Subject: Re: [Mailman-Users] Help needed Mailman, Postfix with MySQL and
Virtual Domain Lists

On 02/08/2014 05:24 PM, George Kasica wrote:
> Here you go sent to mailtest at netwrx1.org gets me
> 
> Feb  8 19:11:41 eagle postfix/pipe[25088]: 30CEE121CDE:
> to=<mailtest at lists.netwrx1.org>, relay=mailman, delay=0.51, 
> delays=0.15/0.01/0/0.35, dsn=2.0.0, status=sent (delivered via mailman
> service)
> 
> 
> And a short time later I have a message in my inbox (and 4 other users 
> test IDs do as well)


So the 'mailman' service can deliver to mailtest at lists.netwrx1.org, but not
to skunk-works at lists.netwrx1.org. If this service is postfix_to_mailman.py
(You never confirmed that it was or wasn't), the only way this can happen is
if the $var-prefix/lists/skunk-works/ directory doesn't exist, but then
postfix_to_mailman should fail with an error message the would be in the
Postfix log message.

Therefore, it appears that the problem is not in the delivery of posts to
skunk-works at lists.netwrx1.org, but rather in the processing/delivery of the
post by Mailman.

Check Mailman's logs.

Also, are there any list members that would receive the post (Mailman's
'bin/list_members --regular --nomail=enabled skunk-works' will tell you). If
the only eligible recipient is you, is your 'not metoo' setting off?

> From what I'm reading in the FAQ this is not a supported method by 
> Mailman but I'm not seeing where its pointing me to any help in 
> getting this working. Would I be better off with the official Postfix 
> -> Mailman integration mentioned and if so how would I do this in the 
> current MySQL environment or would I need to start over? Starting from 
> zero concerns me a bit as this is currently handing mail traffic just not
lists.
> 
> Currently the Postfix/Mailman setup is set for MySQL simply because 
> that's the FAQ I followed but this is a VERY small environment...would 
> I be better served to go the route of hash.db tables and rebuild this to
work that way?


If you want help from this list, we are best able to help you if you
configure Postfix to use hashes for Postfix's alias_maps and
virtual_alias_maps for Mailman list addresses as discussed at
<http://www.list.org/mailman-install/postfix-integration.html> and
<http://www.list.org/mailman-install/postfix-virtual.html>. I don't think
this is necessarily incompatible with using MySQL for other addresses.


> (I'm not a huge MySQL fan personally for this it seems like overkill) 
> We're talking 10 lists with maybe 1000 users total between them and 
> about the same number of virtual domains to handle mail.


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