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

Sat Feb 8 23:44:04 CET 2014

The ODD part is I have a list here set up as  mailtest and its working fine.
I don't see any differences in setup.

-----Original Message-----
From: Mailman-Users
[mailto:mailman-users-bounces+gkasica=netwrx1.com at python.org] On Behalf Of
George Kasica
Sent: Saturday, February 08, 2014 4:39 PM
To: Mark Sapiro; mailman-users at python.org
Subject: Re: [Mailman-Users] Help needed Mailman, Postfix with MySQL and
Virtual Domain Lists

Mark

Thanks,  sorry on the idiot mistake - OK...I can't read :) Too many hours in
front of the screen....

I corrected the aliases and other items you mentioned here and actually
deleted and remade the list completely. No more not found errors in the logs
BUT....

I can send out messages to the list and they don't show as bouncing in the
logs below but I also don't ever see them come back to the list here....

I'm set for get received notice here in outlook

So I see it got there

Your message has been delivered to the following groups:
skunk-works at netwrx1.org
Subject: Test Message

Feb  8 16:12:34 eagle postgrey[16312]: action=pass, reason=triplet found,
client_name=mail-bn1lp0149.outbound.protection.outlook.com,
client_address=207.46.163.
149, sender=gkasica at netwrx1.com, recipient=skunk-works at netwrx1.org Feb  8
16:12:34 eagle postgrey[16312]: action=pass, reason=triplet found,
client_name=mail-bn1lp0149.outbound.protection.outlook.com,
client_address=207.46.163.
149, sender=gkasica at netwrx1.com, recipient=skunk-works at netwrx1.org Feb  8
16:12:37 eagle postfix/pipe[21348]: 44236121652:
to=<skunk-works at lists.ne
twrx1.org>, orig_to=<skunk-works at netwrx1.org>, relay=spamassassin, delay=30,
delays=27/0.01/0/3.1, dsn=2.0.0, status=sent (delivered via spamassassin
service)
Feb  8 16:12:38 eagle postfix/pipe[21355]: B85CD121CCD:
to=<skunk-works at lists.netwrx1.org>, relay=mailman, delay=0.54,
delays=0.19/0.01/0/0.35, dsn=2.0.0, status=sent (delivered via mailman
service)

Looking at the mailman logs the only one with any activity at the time I
sent a test message is one called vette # cat vette Feb 08 16:12:39 2014
(20887) Message discarded, msgid:
<8ec65c559e294241ba9cb4bfa98b6d75 at BN1PR05MB188.namprd05.prod.outlook.com>

Can you assist?

George

-----Original Message-----
From: Mailman-Users
[mailto:mailman-users-bounces+gkasica=netwrx1.com at python.org] On Behalf Of
Mark Sapiro
Sent: Saturday, February 08, 2014 12:21 PM
To: mailman-users at python.org
Subject: Re: [Mailman-Users] Help needed Mailman, Postfix with MySQL and
Virtual Domain Lists

On 02/07/2014 01:59 PM, George Kasica wrote:> Hello:
>
> Currently I've got Postfix running with virtual domains with a MySQL 
> database and am trying to get Mailman to do so as well.
>
> I can get one domain to work mailtest at netwrx1.org but anything else is 
> failing as below. Can someone assist? I've loaded the aliases as shown 
> in to mysql and the snip of the mm_cfg.py is below as well.
> I've looked at varius on line FAQs and other references but am still 
> stuck - have bounced all the relevant iitems postfix and mailman.
...
> Feb  7 15:09:56 eagle postfix/smtpd[5953]: NOQUEUE: reject: RCPT from
> mail-by2lp0235.outbound.protection.outlook.com[207.46.163.235]: 550
> 5.1.1
> <skunk-works at netwrx1.org>: Recipient address rejected: User unknown in 
> virtual mailbox table; from=<gkasica at netwrx1.com> 
> to=<skunk-works at netwrx1.org> proto=ESMTP 
> helo=<na01-by2-obe.outbound.protection.outlook.com>
...
> Aliases
> ======
> INSERT  INTO aliases (mail,destination) VALUES 
> ('skunkworks at netwrx1.org','skunkworks at lists.netwrx1.org'),

skunk-works or skunkworks? Is that the problem?

> /etc/mm_cfg.py
> =============
...
> VIRTUAL_HOSTS =
> {'netwrx1.com','netwrx1.net','netwrx1.org','mke-skywarn.org','petdiabe
> tes.ne
> t','skywarn.biz','skywarn.tv','skywarn.us','twmbfelinerescue.org'}

The above is wrong!

VIRTUAL_HOSTS is a python dictionary with keys = URL hosts and values = the
corresponding email hosts. (The above syntax creates something entirely
different.) It is maintained by add_virtualhost directives as below. It
should never be assigned a value in mm_cfg.py because this creates an entity
mm_cfg.VIRTUAL_HOSTS distinct from Defaults.VIRTUAL_HOSTS, but the
add_virtualhost directives still maintain Defaults.VIRTUAL_HOSTS which is
not referenced in Mailman.

The only direct reference th VIRTUAL_HOSTS that should ever be in mm_cfg.py
is

VIRTUAL_HOSTS.clear()

if needed to remove the default entry set in Defaults.py if it is erroneous,
and if needed, it must be VIRTUAL_HOSTS.clear() and not VIRTUAL_HOSTS = {}
to avoid creating mm_cfg.VIRTUAL_HOSTS distinct from Defaults.VIRTUAL_HOSTS.

> # Required when setting any of its arguments.
> #add_virtualhost(DEFAULT_URL_HOST, DEFAULT_EMAIL_HOST)
> add_virtualhost('www.netwrx1.com','netwrx1.com')
> add_virtualhost('www.netwrx1.net','netwrx1.net')
> add_virtualhost('www.netwrx1.org','netwrx1.org')
> add_virtualhost('www.mke-skywarn.org','mke-skywarn.org')
> add_virtualhost('www.petdiabetes.net','petdiabetes.net')
> add_virtualhost('www.skywarn.biz','skywarn.biz')
> add_virtualhost('www.skywarn.tv','skywarn.tv')
> add_virtualhost('www.skywarn.us','skywarn.us')
> add_virtualhost('www.twmbfelinerescue.org','twmbfelinerescue.org')
>
> POSTFIX_STYLE_VIRTUAL_DOMAINS =
> ['netwrx1.com','netwrx1.net','netwrx1.org','mke-skywarn.org','petdiabe
> tes.ne
> t','skywarn.biz','skywarn.tv','skywarn.us','twmbfelinerescue.org']

This does nothing if you don't also have

MTA = 'Postfix'

to cause Mailman to generate data/aliases and data/virtual-mailman to be
referenced by Postfix.

-- 
Mark Sapiro <mark at msapiro.net>        The highway is for gamblers,
San Francisco Bay Area, California    better use your sense - B. Dylan
------------------------------------------------------
Mailman-Users mailing list Mailman-Users at python.org
https://mail.python.org/mailman/listinfo/mailman-users
Mailman FAQ: http://wiki.list.org/x/AgA3 Security Policy:
http://wiki.list.org/x/QIA9 Searchable Archives:
http://www.mail-archive.com/mailman-users%40python.org/
Unsubscribe:
https://mail.python.org/mailman/options/mailman-users/gkasica%40netwrx1.com
------------------------------------------------------
Mailman-Users mailing list Mailman-Users at python.org
https://mail.python.org/mailman/listinfo/mailman-users
Mailman FAQ: http://wiki.list.org/x/AgA3 Security Policy:
http://wiki.list.org/x/QIA9 Searchable Archives:
http://www.mail-archive.com/mailman-users%40python.org/
Unsubscribe:
https://mail.python.org/mailman/options/mailman-users/gkasica%40netwrx1.com