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

[George Kasica]

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.

Thanks in advance, I'm sure its something simple I'm missing.

George

Error:
=====
Feb  7 15:09:29 eagle postfix/smtpd[5953]: Anonymous TLS connection
established from
mail-by2lp0235.outbound.protection.outlook.com[207.46.163.235]: TLSv1 with
cipher AES128-SHA (128/128 bits)
Feb  7 15:09:55 eagle magicspam-postfix[5957]: Checking exemption lists...
Feb  7 15:09:56 eagle magicspam-postfix[5958]: Checking exemption lists...
Feb  7 15:09:56 eagle postgrey[16312]: action=pass, reason=triplet found,
client_name=mail-by2lp0235.outbound.protection.outlook.com,
client_address=207.46.163.235, sender=gkasica at netwrx1.com,
recipient=skunk-works at netwrx1.org
Feb  7 15:09:56 eagle postgrey[16312]: action=pass, reason=triplet found,
client_name=mail-by2lp0235.outbound.protection.outlook.com,
client_address=207.46.163.235, sender=gkasica at netwrx1.com,
recipient=skunk-works at netwrx1.org
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>
Feb  7 15:09:56 eagle postfix/smtpd[5953]: disconnect from
mail-by2lp0235.outbound.protection.outlook.com[207.46.163.235]

Aliases
======
INSERT  INTO aliases (mail,destination) VALUES
('skunkworks at netwrx1.org','skunkworks at lists.netwrx1.org'),
('skunkworks-admin at netwrx1.org','skunkworks-admin at lists.netwrx1.org'),
('skunkworks-bounces at netwrx1.org','skunkworks-bounces at lists.netwrx1.org'),
('skunkworks-confirm at netwrx1.org','skunkworks-confirm at lists.netwrx1.org'),
('skunkworks-join at netwrx1.org','skunkworks-join at lists.netwrx1.org'),
('skunkworks-leave at netwrx1.org','skunkworks-leave at lists.netwrx1.org'),
('skunkworks-owner at netwrx1.org','skunkworks-owner at lists.netwrx1.org'),
('skunkworks-request at netwrx1.org','skunkworks-request at lists.netwrx1.org'),
('skunkworks-subscribe at netwrx1.org','skunkworks-subscribe at lists.netwrx1.org'
),
('skunkworks-unsubscribe at netwrx1.org','skunkworks-unsubscribe at lists.netwrx1.
org');

/etc/mm_cfg.py
=============
#-------------------------------------------------------------
# Default domain for email addresses of newly created MLs
DEFAULT_EMAIL_HOST = 'netwrx1.org'
#-------------------------------------------------------------
# Default host for web interface of newly created MLs
DEFAULT_URL_HOST   = 'eagle.netwrx1.org'
#-------------------------------------------------------------
VIRTUAL_HOSTS =
{'netwrx1.com','netwrx1.net','netwrx1.org','mke-skywarn.org','petdiabetes.ne
t','skywarn.biz','skywarn.tv','skywarn.us','twmbfelinerescue.org'}
 
# 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','petdiabetes.ne
t','skywarn.biz','skywarn.tv','skywarn.us','twmbfelinerescue.org']


--- 
===[George R. Kasica]===        +1 262 677 0766
georgek at netwrx1.com             +1 206 374 6482 FAX 
http://www.netwrx1.com/georgek  Jackson, WI USA 
gkasica at netwrx1.com

("`-''-/").___..--''"`-._
`6_ 6  )   `-.  (     ).`-.__.`)
(_Y_.)'  ._   )  `._ `. ``-..-'
_..`--'_..-_/  /--'_.' ,'
(il),-''  (li),'  ((!.-'