Re: About to Install MM3 -- Seeking clarification
by Stephen J. Turnbull
Onyeibo Oku writes:
> I am not sure I understand what you mean by apps. Is that Django apps
> (./manage.py startapp app)? Do you mean a Django Project instead
> (./manage.py startproject app)?
An app for my purpose is everything configured via the settings.py
used by the Django application created in a wsgi.py file. I guess you
would think of them as projects.
> What I have here is an active website project (live) done on Django
> framework. It runs from a different virtual environment (venv).
>
> hence:
> mailman --> /opt/mailman/venv
> website --> /srv/website/venv (has a running uwsgi instance)
The venvs isolate the Python code used by each app from the other.
But the apps can still have conflicts over ports (this is mentioned in
the Django docs), filesystem objects, and other resources. For
example, a lot of applications use the /static/ location as a place to
keep content that is supplied by your project and doesn't change.
This is problematic if two different apps each wants to install a
default.css, but they're different. One of the apps is going to look
funny.
Only the person who configures the apps can guess whether this kind of
conflict will arise. Neither Mailman nor Django itself tries to
protect you from such conflicts (I don't see how they could, in fact).
> > > In whichcase, it doesn't hurt to follow the doc to its logical
> > > conclusion?
> >
> > I don't understand what you mean by logical conclusion.
> >
>
> That is to follow the guide to the end of the page (disregarding
> the possibility of conflicts).
No, you can't disregard the possibility of conflicts. My
understanding from what you've posted so far is that you have an app
"website" that is already implemented and running. Most likely that
app has configured resources (specifically ports and website locations
in particular /static/) that are likely to conflict. You need to
manage those conflicts, most likely by changing the ports used by
Mailman, Postorius, and Hyperkitty and by mapping a different location
such as /mailman/static/ to the /var directory that actually contains
the static files managed by "manage.py collectstatic".
There may be other possible conflicts, but I can't help you with those
because they depend on your website code.
Steve
2 years
Re: user mail not accepted
by Christian Stalberg
From smtp.log
Apr 26 00:17:39 2021 (807) ('127.0.0.1', 38370) Data: b'DATA'
Apr 26 00:17:39 2021 (807) ('127.0.0.1', 38370) Data: b'QUIT'
Apr 26 00:17:39 2021 (807) ('127.0.0.1', 38370) connection lost
Apr 26 00:17:39 2021 (807) Connection lost during _handle_client()
Apr 26 00:18:11 2021 (809)
<019301d73a31$8e8e54e0$abaafea0$(a)ncboliviapartners.org> smtp to
ncpoa(a)lists.ccalternatives.org for 83 recips, completed in 29.13376259803772
seconds
Apr 26 00:18:11 2021 (809)
<019301d73a31$8e8e54e0$abaafea0$(a)ncboliviapartners.org> post to
ncpoa(a)lists.ccalternatives.org from christian(a)ncboliviapartners.org, 5811
bytes
Apr 26 00:18:11 2021 (809)
<161939626169.810.9530678025639681522(a)zarathustra.ccalternatives.org> smtp
to ncpoa(a)lists.ccalternatives.org for 1 recips, completed in
0.0420069694519043 seconds
Apr 26 00:18:11 2021 (809)
<161939626169.810.9530678025639681522(a)zarathustra.ccalternatives.org> post
to ncpoa(a)lists.ccalternatives.org from
ncpoa-bounces(a)lists.ccalternatives.org, 869 bytes
Apr 26 11:52:22 2021 (819)
<161943793957.929.15640398646519288095(a)zarathustra.ccalternatives.org> smtp
to ssan(a)lists.ccalternatives.org for 1 recips, completed in
0.22335004806518555 seconds
Apr 26 11:52:22 2021 (819)
<161943793957.929.15640398646519288095(a)zarathustra.ccalternatives.org> post
to ssan(a)lists.ccalternatives.org from ssan-bounces(a)lists.ccalternatives.org,
765 bytes
Apr 26 11:52:22 2021 (819)
<161943793960.929.13309139087156940549(a)zarathustra.ccalternatives.org> smtp
to ssan(a)lists.ccalternatives.org for 2 recips, completed in
0.05862092971801758 seconds
Apr 26 11:52:22 2021 (819)
<161943793960.929.13309139087156940549(a)zarathustra.ccalternatives.org> post
to ssan(a)lists.ccalternatives.org from noreply(a)lists.ccalternatives.org, 810
bytes
Apr 26 11:55:22 2021 (819)
<161943812108.929.10391982256874011271(a)zarathustra.ccalternatives.org> smtp
to ssan(a)lists.ccalternatives.org for 1 recips, completed in
0.1459965705871582 seconds
Apr 26 11:55:22 2021 (819)
<161943812108.929.10391982256874011271(a)zarathustra.ccalternatives.org> post
to ssan(a)lists.ccalternatives.org from
ssan-confirm+2144530ad102026077911eac6eb574bcbd04be92(a)lists.ccalternatives.o
rg, 1526 bytes
Apr 26 12:01:30 2021 (817) Available AUTH mechanisms: LOGIN(builtin)
PLAIN(builtin)
Apr 26 12:01:30 2021 (817) Peer: ('127.0.0.1', 38556)
Apr 26 12:01:30 2021 (817) ('127.0.0.1', 38556) handling connection
Apr 26 12:01:30 2021 (817) ('127.0.0.1', 38556) Data: b'LHLO
zarathustra.ccalternatives.org'
Apr 26 12:01:30 2021 (817) ('127.0.0.1', 38556) Data: b'MAIL
FROM:<christian(a)sewagesludgeactionnetwork.com>'
Apr 26 12:01:30 2021 (817) ('127.0.0.1', 38556) sender:
christian(a)sewagesludgeactionnetwork.com
Apr 26 12:01:30 2021 (817) ('127.0.0.1', 38556) Data: b'RCPT
TO:<ssan-confirm+2144530ad102026077911eac6eb574bcbd04be92(a)lists.ccalternativ
es.org>'
Apr 26 12:01:30 2021 (817) ('127.0.0.1', 38556) recip:
ssan-confirm+2144530ad102026077911eac6eb574bcbd04be92(a)lists.ccalternatives.o
rg
Apr 26 12:01:30 2021 (817) ('127.0.0.1', 38556) Data: b'DATA'
Apr 26 12:01:30 2021 (817) ('127.0.0.1', 38556) Data: b'QUIT'
Apr 26 12:01:30 2021 (817) ('127.0.0.1', 38556) connection lost
Apr 26 12:01:30 2021 (817) Connection lost during _handle_client()
Apr 26 12:01:34 2021 (819)
<161943849287.814.5890052642238479423(a)zarathustra.ccalternatives.org> smtp
to ssan(a)lists.ccalternatives.org for 2 recips, completed in
0.06680631637573242 seconds
Apr 26 12:01:34 2021 (819)
<161943849287.814.5890052642238479423(a)zarathustra.ccalternatives.org> post
to ssan(a)lists.ccalternatives.org from noreply(a)lists.ccalternatives.org, 821
bytes
Apr 26 12:01:34 2021 (819)
<161943849292.814.6140111398379700592(a)zarathustra.ccalternatives.org> smtp
to ssan(a)lists.ccalternatives.org for 1 recips, completed in
0.04269862174987793 seconds
Apr 26 12:01:34 2021 (819)
<161943849292.814.6140111398379700592(a)zarathustra.ccalternatives.org> post
to ssan(a)lists.ccalternatives.org from ssan-request(a)lists.ccalternatives.org,
1335 bytes
Message sent that only the user receives:
Return-Path: <christian(a)sewagesludgeactionnetwork.com>
Delivered-To: ces(a)ecovillage.cc
Received: from box.ecovillage.cc ([127.0.0.1])
by box.ecovillage.cc with LMTP id MDucNBythmCTSwAAMoO61A
for <ces(a)ecovillage.cc>; Mon, 26 Apr 2021 05:07:56 -0700
X-Spam-Checker-Version: SpamAssassin 3.4.2 (2018-09-13) on box.ecovillage.cc
X-Spam-Level:
X-Spam-Status: No, score=-1.1 required=5.0 tests=ALL_TRUSTED,DKIM_SIGNED,
DKIM_VALID,DKIM_VALID_AU,HTML_MESSAGE autolearn=ham
autolearn_force=no
version=3.4.2
X-Spam-Report:
* -1.0 ALL_TRUSTED Passed through trusted hosts only via SMTP
* 0.0 HTML_MESSAGE BODY: HTML included in message
* -0.1 DKIM_VALID Message has at least one valid DKIM or DK
signature
* 0.1 DKIM_SIGNED Message has a DKIM or DK signature, not
necessarily
* valid
* -0.1 DKIM_VALID_AU Message has a valid DKIM or DK signature from
* author's domain
X-Spam-Score: -1.1
Received: from authenticated-user (box.ecovillage.cc [45.79.28.18])
(using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256
bits))
(No client certificate requested)
by box.ecovillage.cc (Postfix) with ESMTPSA id 6EADF3E8CC
for <ssan(a)lists.naturalintelligence.us>; Mon, 26 Apr 2021 05:07:54
-0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple;
d=sewagesludgeactionnetwork.com; s=mail; t=1619438876;
bh=1M7F/uIS0bNG6cWjecy/a9QjskrHVwJHkjWRv+ffpM4=;
h=From:To:References:In-Reply-To:Subject:Date:From;
b=jXOswVZgFeHBB+sjIDqVkNBQqIbfZCj9ZUfpVwl10NQEkGaoxckPHNOKT6x9zIqsW
BZ7iZqqi2mWprVQ8LrK48Lp7gvCQ/ipqspMeLt3t+uljzTtryHmV6uJFEAU3hqM33Y
nQqX6Z8la8Ko40F9Ayb4h4e/MOfPdA4nadgf5hZzt/DzPFZvzUbG3V8lWcHuyJNA2y
SQkhbNubQ6iNEEB0SyBjoOjl3g3LVxjxY+9kMGGmX+1PFfW90CpDDShRmKkkscEWaA
NiV0fX6U5LENBBnc6Q9ImLgXuaLdCqlBRBumJBk+eUUr007rpXXVAPck2NvUzGyM2v
kNNGlT68hGzEg==
From: <christian(a)sewagesludgeactionnetwork.com>
To: <ssan(a)lists.naturalintelligence.us>
References:
In-Reply-To:
Subject: How US chemical industry lobbying and cash defeated regulation in
Trump era
Date: Mon, 26 Apr 2021 05:07:37 -0700
Message-ID: <020501d73a94$cbe17440$63a45cc0$(a)sewagesludgeactionnetwork.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0206_01D73A5A.1F831170"
Thread-Index: Adc6h7I/qzBKx1yOT6aPOuipppacoQACatZAAADW1wA=
Content-Language: en-us
How US chemical industry lobbying and cash defeated regulation in Trump era
Industry's congressional allies defeated nearly all PFAS legislation while
the Trump EPA killed, watered down or slowalked new rules
https://www.theguardian.com/environment/2021/apr/26/us-chemical-companies-lo
bbying-donation-defeated-regulation
-----Original Message-----
From: Mark Sapiro <mark(a)msapiro.net>
Sent: Monday, April 26, 2021 2:05 PM
To: mailman-users(a)mailman3.org
Subject: [MM3-users] Re: user mail not accepted
On 4/26/21 5:16 AM, Christian Stalberg via Mailman-users wrote:
> I have a user whose moderation rule is 'Accept immediately' yet when
> they send a message for distribution to the list, they only receive it
> and it is not distributed via the list. Logfile entries below. Please
> advise. Btw I have another list on this same instance which is running
fine. Thank you.
>
> [26/Apr/2021:12:06:25 +0000] "GET
> /3.1/lists/ssan.lists.ccalternatives.org
> HTTP/1.1" 200 453 "-" "GNU Mailman REST client v3.3.2"
> [26/Apr/2021:12:06:25 +0000] "POST
> /3.1/members/find?list_id=ssan.lists.ccalternatives.org&subscriber=chr
> istian %40sewagesludgeactionnetwork.com HTTP/1.1" 200 1257 "-" "GNU
> Mailman REST client v3.3.2"
> [26/Apr/2021:12:06:25 +0000] "PATCH
> /3.1/members/7186cd45bde34d4fa7e7b5ab36b97272 HTTP/1.1" 204 0 "-" "GNU
> Mailman REST client v3.3.2"
> [26/Apr/2021:12:06:26 +0000] "GET
> /3.1/lists/ssan.lists.ccalternatives.org
> HTTP/1.1" 200 453 "-" "GNU Mailman REST client v3.3.2"
> [26/Apr/2021:12:06:26 +0000] "POST
> /3.1/members/find?list_id=ssan.lists.ccalternatives.org&subscriber=chr
> istian %40sewagesludgeactionnetwork.com HTTP/1.1" 200 1288 "-" "GNU
> Mailman REST client v3.3.2"
> [26/Apr/2021:12:06:26 +0000] "GET
> /3.1/lists/ssan(a)lists.ccalternatives.org/requests/count?token_owner=mo
> derato r HTTP/1.1" 200 73 "-" "GNU Mailman REST client v3.3.2"
> [26/Apr/2021:12:06:26 +0000] "GET
> /3.1/lists/ssan(a)lists.ccalternatives.org/held/count HTTP/1.1" 200 73 "-"
> "GNU Mailman REST client v3.3.2"
> [26/Apr/2021:12:06:26 +0000] "GET
> /3.1/members/7186cd45bde34d4fa7e7b5ab36b97272/preferences HTTP/1.1"
> 200 295 "-" "GNU Mailman REST client v3.3.2"
These entries don't tell anything about a post to the list. They are all
from Mailman's REST API relating to Postorius interactions with core.
However the absence of messages like
Apr 26 07:32:39 2021 (17860) ACCEPT: <message_id> and Apr 26 07:32:41 2021
(17857) HyperKitty archived message <message_id> to
https://example.com/archives/list/list_adderss/message/message_id_hash/
assuming you are looking at the correct time span, says there wasn't an
accepted list post.
Mailman's smtp.log may have more info, but the complete, raw message that
the user receives may be more helpful.
--
Mark Sapiro <mark(a)msapiro.net> The highway is for gamblers,
San Francisco Bay Area, California better use your sense - B. Dylan
_______________________________________________
Mailman-users mailing list -- mailman-users(a)mailman3.org To unsubscribe send
an email to mailman-users-leave(a)mailman3.org
https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/
3 years, 6 months
Re: Restore/export existing Mailman lists + hyperkitty archives on a new server
by alexs＠ecoscentric.com
Mark Sapiro wrote:
...
> I thing just dumping and loading the databases and copying mailman.cfg
> and the Django settings should do it. Are the domains the same on the
> new server? If not there may be issues with that. I'd need to see the
> exception and traceback to say more.
I am migrating from mailman 3.2.1 & mailman3-web 0+20180916-8 on Debian Buster to mailman 3.3.8 & mailman3-web 0+20200530-2.1 on Debian bookworm, have mailman3 and mailman3-web configured (and running on bookworm) from the initial install. But when I use the mailman3-web 0+20180916-8 database (after stopping mailman3 and mailman3-web) on bookworm, unfortunately migrate fails:
# mailman-web showmigrations
account
[X] 0001_initial
[X] 0002_email_max_length
admin
[X] 0001_initial
[X] 0002_logentry_remove_auto_add
[X] 0003_logentry_add_action_flag_choices
auth
[X] 0001_initial
[X] 0002_alter_permission_name_max_length
[X] 0003_alter_user_email_max_length
[X] 0004_alter_user_username_opts
[X] 0005_alter_user_last_login_null
[X] 0006_require_contenttypes_0002
[X] 0007_alter_validators_add_error_messages
[X] 0008_alter_user_username_max_length
[X] 0009_alter_user_last_name_max_length
[X] 0010_alter_group_name_max_length
[X] 0011_update_proxy_permissions
[X] 0012_alter_user_first_name_max_length
contenttypes
[X] 0001_initial
[X] 0002_remove_content_type_name
...
# mailman-web migrate --plan
Planned operations:
contenttypes.0001_initial
Create model ContentType
Alter unique_together for contenttype (1 constraint(s))
auth.0001_initial
Create model Permission
Create model Group
Create model User
account.0001_initial
Create model EmailAddress
Create model EmailConfirmation
account.0002_email_max_length
Alter field email on emailaddress
admin.0001_initial
Create model LogEntry
admin.0002_logentry_remove_auto_add
Alter field action_time on logentry
admin.0003_logentry_add_action_flag_choices
Alter field action_flag on logentry
contenttypes.0002_remove_content_type_name
Change Meta options on contenttype
Alter field name on contenttype
Raw Python operation
Remove field name from contenttype
...
But the migrate fails at the first operation:
# mailman-web migrate
Operations to perform:
Apply all migrations: account, admin, auth, contenttypes, django_mailman3, django_q, hyperkitty, postorius, sessions, sites, socialaccount
Running migrations:
Applying contenttypes.0001_initial...Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 82, in _execute
return self.cursor.execute(sql)
^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/django/db/backends/mysql/base.py", line 73, in execute
return self.cursor.execute(query, args)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 209, in execute
res = self._query(query)
^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 315, in _query
db.query(q)
File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 239, in query
_mysql.connection.query(self, query)
MySQLdb._exceptions.OperationalError: (1050, "Table 'django_content_type' already exists")
...
Indeed the table django_content_type already exists on 0+20180916-8 . Apart from fields changes, there are an additional 4 tables in mailman3-web 0+20200530-2.1
I managed to import the mailman 3.2.1 database to the mailman 3.3.8 database, and all lists, subscriptions and settings looks fine.
So how can I upgrade my existing mailman3-web database?
1 year, 2 months
Re: Message Sent to A Re-Created List Results In Error
by matthew＠alberti.us
Mojo,
Thanks for the link. I finally got it sorted out. I probably need to
write all this somewhere else. I have a combination of local, virtual,
alias, and Mailman3 mail transport/routing, all on one server. Virtual,
alias, and Mailman3 all use the same domain. Mailman also has an additional
domain. It seemed like no matter what I did, the virtual mail would not work
and mailman would, or the virtual mail would work but the domain that is
both virtual and mailman wouldn't work with mailman.
The problem was the (well documented) behavior when defining
"virtual_transport" (for dovecot lmtp) and "virtual_mailbox_domains" (for
virtual domains and Mailman domains). When "virtual_transport" is defined,
the "transport_maps" option is basically ignored, which causes Mailman to
not work (assuming Mailman is setup with virtual domains, not alias or
relay). When I took out "virtual_transport", then virtual mail via dovecot
stopped working.
To fix it, I ended up creating an additional mysql lookup for the
virtual mail (they use dovecot lmtp for delivery). I put this lookup in the
"transport_maps", and things seem to work. Now Postfix will check with both
the virtual mailbox database and Mailman's lmtp regex list, and know the
correct transport (dovecot-lmtp and mailman-core lmtp) respectively.
So after all that, I have to circle back around and see if there is
still an issue with using aliased or virtual addresses as a Mailman owner or
subscriber. I'm guessing probably not, since now the correct transport
method for each is now defined to Postfix.
Thanks for reading.
- Matt Alberti
-----Original Message-----
From: Morris Jones <mojo(a)whiteoaks.com>
Sent: Tuesday, December 15, 2020 1:04 AM
To: mailman-users(a)mailman3.org
Subject: [MM3-users] Re: Message Sent to A Re-Created List Results In Error
Matt, I think you're describing exactly the problem that's handled by
/virtual alias domains/ that were added to support this case.
https://docs.mailman3.org/projects/mailman/en/latest/src/mailman/docs/mta.ht
ml#unusual-postfix-configuration
I did an integration between Mailman3 and Zimbra which uses Postfix, and
came across the same issue with domains managed by Postfix and Mailman
simultaneously.
I documented the case in my Zimbra - Mailman3 integration document here:
https://gitlab.com/MojoLA/mailman3.3-zimbra-8.8-integration/-/blob/master/ma
ilman-zimbra-integration.rst
See if that helps ...
Best regards,
Mojo
On 12/14/20 9:38 PM, matthew(a)alberti.us wrote:
> I checked all over the mailman core logs and couldn't find a
problem.
> But then I noticed that the 550 error was coming from dovecot-lmtp.
> I should rename this thread because the actual problem seems to be
> unrelated to re-created lists.
>
> It seems like the actual problem seems to occur in the following
> situation:
>
> * Using Postfix
> * Using Dovecot
> * /etc/postfix/virtual includes addresses with same domain as mailman
> lists.
> * An e-mail address subscribed to a mailman list is in the
> /etc/postfix/virtual file as an alias (possibly also if destination
> address for an alias).
> * (Possibly related) E-mail address is also one of the list owners.
>
> In that environment, Postfix seems to check only 'virtual_transport'
> list, which in my case is dovecot-lmtp, and when it doesn't find the
> mailman listname@domain entry in there, it sends a 550 user unknown.
> It seems to be that it isn't getting passed to 'transport_maps', which is
mailman-lmtp.
>
> When I remove that one address (that is in /etc/postfix/virtual)
from
> the list of subscribers, I'm able to post again. Interestingly enough,
> when I put it back in as a subscriber. I'm still able to post. So it
> seems unsubscribing and re-subscribing that address fixed it, or
> adding an additional list owner and deleting it fixed it, or some
> combination of those.
>
> I know this might be shaping up to be a very unlikely scenario. But
> basically the account is mine, an admin, doing testing before/after a
> deployment.. I'll try to create a few test procedures to document the
> method to reproduce the problem, and also hopefully fix it. If I can
> do that, I'll open another thread. This could also be a postfix config
> error of some kind, which is definitely possible if not likely.
>
> Thanks for reading.
>
> - Matt Alberti
>
>
>
> -----Original Message-----
> From: Abhilash Raj <maxking(a)asynchronous.in>
> Sent: Monday, December 14, 2020 11:42 PM
> To: matthew(a)alberti.us; Mailman users <mailman-users(a)mailman3.org>
> Subject: [MM3-users] Re: Message Sent to A Re-Created List Results In
> Error
>
>
>
> On Tue, Dec 15, 2020, at 10:00 AM, matthew(a)alberti.us
> <mailto:matthew@alberti.us> wrote:
>> I created a list in the Postorius interface, used it, and then
>> deleted it. A week or so later, I re-created the list, and things
>> were fine thru the creation and subscription process. But when I sent
>> a message to the list, a
>> "550 user unknown" error was sent back.
>
> Can you share more error details from the Mailman logs? If 550 error
> response was sent, there must be some internal error traceback in the
logs.
>
>>
>>
>> I tried to determine if this is a known issue by searching the issues
>> in Gitlab; but didn't find anything. But wanted to ask if this was a
>> known issue or not?
>
> I personally don't remember seeing such an issue, but Mark or others
> might know.
>
>>
>>
>>
>> Thanks.
>>
>>
>>
>> - Matt Alberti
>>
>> _______________________________________________
>> Mailman-users mailing list -- mailman-users(a)mailman3.org
> <mailto:mailman-users@mailman3.org> To
>> unsubscribe send an email to mailman-users-leave(a)mailman3.org
> <mailto:mailman-users-leave@mailman3.org>
>> https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/
>>
>
> --
> thanks,
> Abhilash Raj (maxking)
> _______________________________________________
> Mailman-users mailing list -- mailman-users(a)mailman3.org
> <mailto:mailman-users@mailman3.org> To unsubscribe send an email to
> mailman-users-leave(a)mailman3.org
> <mailto:mailman-users-leave@mailman3.org>
> https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/
> _______________________________________________
> Mailman-users mailing list -- mailman-users(a)mailman3.org To
> unsubscribe send an email to mailman-users-leave(a)mailman3.org
> https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/
>
--
Morris Jones, Monrovia, CA
BridgeMojo <http://bridgemojo.com>
Old Town Sidewalk Astronomers <http://otastro.org> Mojo's Blog
<http://mojo.whiteoaks.com> _______________________________________________
Mailman-users mailing list -- mailman-users(a)mailman3.org To unsubscribe send
an email to mailman-users-leave(a)mailman3.org
https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/
3 years, 11 months
Re: Question to add "alias" address in list by group
by Pierre Malard
Thanks,
> Le 28 avr. 2022 à 15:17, Stephen J. Turnbull <stephenjturnbull(a)gmail.com> a écrit :
>
> Pierre Malard via Mailman-users writes:
>
>> We must add some (a lot) alias address for members and I don’t find
>> any indications on doc to do that with « mailman » command.
>
> I have no idea what you mean by an "alias address" that can be added
> for many members simultaneously. There is no concept of "alias" in
> Mailman, and almost certainly no special command for this.
These are authorized alternate email addresses. For example A@domain is subscribed to the Z list of which only members can contribute but we also want to authorize some other address of A (A@domain2, …) as an « alternative" email contributor.
In the Mailman2 version this was called "accept_these_nonmembers" and it actually got added to that "non-members" list in mailman3.
>
> The general way to add a lot of addresses for a single list is the
> mass add command in Postorius's users tab, or an equivalent script
> using mailmanclient. If you need to do this at the user level (rather
> than the subscription level), you will need to write a script for it,
> and also to update subscriptions if that is what you have in mind.
We would like to be able to add these "non-members" addresses with the "mailman" command line, indicating the assigned "role". But, obviously, the only available option managing the role is provided by "mailman members" which declares itself obsolete! :-(
As far as the Python mailman libraries are concerned, we lack documentation. For example the possible parameters… Otherwise, working directly in the database seems dangerous to us.
>
> Steve
>
--
Pierre Malard
« Je n'ai jamais séparé la République des idées de justice sociale,
sans laquelle elle n'est qu'un mot »
Jean Jaures - 1887
|\ _,,,---,,_
/,`.-'`' -. ;-;;,_
|,4- ) )-,_. ,\ ( `'-'
'---''(_/--' `-'\_) πr
perl -e '$_=q#: 3|\ 5_,3-3,2_: 3/,`.'"'"'`'"'"' 5-. ;-;;,_: |,A- ) )-,_. ,\ ( `'"'"'-'"'"': '"'"'-3'"'"'2(_/--'"'"' `-'"'"'\_): 24πr::#;y#:#\n#;s#(\D)(\d+)#$1x$2#ge;print'
- --> Ce message n’engage que son auteur <--
___________________________________________
Mailman's content filtering has removed the
following MIME parts from this message.
Replaced multipart/alternative part with first alternative.
2 years, 6 months
Re: [Mailman-Developers] Mailman 3.1 beta coming soon
by Terri Oda
On 2016-12-12 12:29 AM, Stephen J. Turnbull wrote:
> Barry Warsaw writes:
>
> > >I can also work on Postorius. Also in this vein I have a question.
> > >Should the DMARC settings be added to the Alter Messages tab in the List
> > >Settings view or would it be better to have a separate DMARC Mitigations
> > >tab.
> >
> > My gut reaction is to add a separate DMARC Mitigations tab, but Florian and
> > Terri have final say I think.
>
> I would find it more natural to have "Posting Policy" (which would
> include posting filters on size and list membership, as well as
> message alterations such as removing .exe files and enforcing plain
> text by removing or rendering HTML parts), and "Malware Mitigation",
> which would include IP, domain, and mailbox filters as well as DMARC.
> I think DMARC mitigation is probably too special to deserve its own
> tab.
Alter messages tab works for me, but DMARC is kind of a big enough deal
(as far as mail delivery goes) and sufficiently different that I agree
with Mark that it's not unreasonable to give it a separate tab. I'd be
willing to start it on its own and move it if we're getting too
cluttered later, as long as we document it in the release notes when we
do. Florian, what do you think?
> Probably this is way too much reorganization to do at this point, but
> I'd like to keep this point in mind. We are already getting reports
> that configuration options are hard to find just because it's
> different from Mailman 2. I suspect that the REST API is sufficiently
> flexible and regular that we'll be tempted to proliferate options, so
> let's try to keep them organized.
We also get reports that mailman 2.1 options are hard to find -- I think
I personally help someone find something at least once a month (on irc,
in person, or by email) for the past decade. :) I imagine Mark has
answered a lot more of those than I have.
The big thing I want is good documentation here. There's never going to
be an organization that works for everyone, but an easily searchable
document with all the options would make a big difference. I only got
to that level with the user docs not the list admin docs in 2.1
7 years, 11 months
Re: Trying to configure a list (hosted)
by Abhilash Raj
On Sat, Aug 31, 2019, at 6:25 PM, paul(a)arenson.org wrote:
> I guess my message wasn't clear?
>
> Let me try again.
>
> I have not made any list settings or sent mails because I do not want
> my archive filled with a lot of test mails.
>
> I am simply trying to understand
>
> a) why there are supposed to be two ways to sign up--one where you just
> get the messages by email and one where you are able to interact with
> the archives and send from the web interface.
>
> Example, as seen here--->
> https://list.tokyoprogressive.org/postorius/lists/discuss.list.tokyoprogres…
Web UI is only of the ways you can configure subscriptions to the MailingList. A user can purely interact through email to subscribe to a MailingList, a possible 3rd way to sign up a MailingList.
This is by design for the flexibility of choosing the interface users are comfortable with.
>
> 1) I was told that Subscription / Unsubscription lets you truly register
Login and Sign-Up to the Web UI only lets you manage your subscription through the Web UI, Post through the Web UI.
You can interact with Mailman purely through email commands too, without having to ever look at the Web UI.
Send an email to <listname>-requests@<domain> with subject "help".
>
> and that just below that
>
> 2) "You can also subscribe without creating an account" lLets you just
> receive emails but not interact with the archives.post from the web.
>
> CONFUSION
>
> --> Aside from the confusing use of "subscribe/subscription for both,
> when I tried testing both options, BOTH sets of emails ended up in my
> members list.
>
> If there is a guide (I was told it is not ready), it would help, but anyway:
>
> 3) Can anyone help me understand the problem above?
>
> 4) Will it go away if I enter my settings? Will my users (this who
> truly register with a password) be able to get the archives and post
> from the interface?
This isn't configurable right now, so you can't disable email commands or subscribing without signing up.
>
> The next post is about the other issue:
> _______________________________________________
> Mailman-users mailing list -- mailman-users(a)mailman3.org
> To unsubscribe send an email to mailman-users-leave(a)mailman3.org
> https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/
>
--
thanks,
Abhilash Raj (maxking)
5 years, 2 months
Post installation issues (recipients refused) with Exim4 in a virtual host environment
by Kyriakos Terzopoulos
Hi,
I have set up (I believe successfully) and configured the following in a
Virtualhost environment (with HestiaCP):
- A record for lists.mydomain.com
- Venv
- Mailman core
- Mailman web (run migrate, collectstatic, compress, compilemessages)
Postorius
- gunicorn, hyperkitty
- Nginx
- SMTP exim4 conf
I can see Posrorius and I have logged in and created my first mailing list:
[image: Screenshot 2023-10-11 at 10.57.31 AM.png]
My issue is that even though I have subscribed to my list as you can see
above, I am not receiving the confirmation email. I get a "recipients
refused" error. The smtp log for mailman is as follows:
Oct 11 10:41:20 2023 (1533666)
<169701007904.1534165.14569329382406660776@localhost> recipients refused: {'
kyriakos.terzopoulos(a)gmail.com': (550, b'Verification failed for
<testlist-bounces+kyriakos.terzopoulos=gmail.com(a)myproject.eu>\nUnrouteable
address\nSender verify failed')}
Oct 11 10:41:20 2023 (1533666)
<169701007904.1534165.14569329382406660776@localhost> smtp to
testlist(a)myproject.eu for 1 recips, completed in 0.26796579360961914 seconds
Oct 11 10:41:20 2023 (1533666)
<169701007904.1534165.14569329382406660776@localhost> post to
testlist(a)myproject.eu from
testlist-confirm+c9b20c5290bec43147a7e96a6b8cd825daf913d7(a)myproject.eu,
1667 bytes, 1 failures
Oct 11 10:41:20 2023 (1533666)
<169701007904.1534165.14569329382406660776@localhost> delivery to
kyriakos.terzopoulos(a)gmail.com failed with code 550, b'Verification failed
for <testlist-bounces+kyriakos.terzopoulos=gmail.com(a)myproject.eu>\nUnrouteable
address\nSender verify failed'
I have used the configuration for exim that is here
<https://docs.mailman3.org/projects/mailman/en/latest/src/mailman/docs/mta.h…>
and
I have also tested with the alternative approach that is documented in
there.
------
Debug info follows:
First, here is my installation directory:
[image: image.png]
The following are the services that are running successfully (albeit with
some warnings):
------
*Mailman:*
● mailman3.service - GNU Mailing List Manager
Loaded: loaded (/etc/systemd/system/mailman3.service; enabled; vendor
preset: enabled)
Active: active (running) since Thu 2023-10-05 12:32:08 EEST; 28min ago
Process: 1563357 ExecStart=/opt/mailman/venv/bin/mailman start
(code=exited, status=0/SUCCESS)
Main PID: 1563364 (python3)
Tasks: 18 (limit: 9255)
Memory: 929.7M
CPU: 22.818s
CGroup: /system.slice/mailman3.service
├─1563364 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/master -C /etc/mailman3/mailman.cfg
├─1563370 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/runner -C /etc/mailman3/mailman.cfg
--runner=archive:0:1
├─1563371 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/runner -C /etc/mailman3/mailman.cfg
--runner=bounces:0:1
├─1563372 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/runner -C /etc/mailman3/mailman.cfg
--runner=command:0:1
├─1563373 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/runner -C /etc/mailman3/mailman.cfg --runner=in:0:1
├─1563374 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/runner -C /etc/mailman3/mailman.cfg --runner=lmtp:0:1
├─1563375 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/runner -C /etc/mailman3/mailman.cfg --runner=nntp:0:1
├─1563376 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/runner -C /etc/mailman3/mailman.cfg --runner=out:0:1
├─1563377 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/runner -C /etc/mailman3/mailman.cfg
--runner=pipeline:0:1
├─1563378 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/runner -C /etc/mailman3/mailman.cfg --runner=rest:0:1
├─1563379 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/runner -C /etc/mailman3/mailman.cfg --runner=retry:0:1
├─1563380 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/runner -C /etc/mailman3/mailman.cfg --runner=task:0:1
├─1563381 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/runner -C /etc/mailman3/mailman.cfg
--runner=virgin:0:1
├─1563382 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/runner -C /etc/mailman3/mailman.cfg
--runner=digest:0:1
├─1563420 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/runner -C /etc/mailman3/mailman.cfg --runner=rest:0:1
└─1563421 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/runner -C /etc/mailman3/mailman.cfg --runner=rest:0:1
Oct 05 12:32:07 hestia. mydomain.eu systemd[1]: Starting GNU Mailing List
Manager...
Oct 05 12:32:08 hestia. mydomain.eu mailman[1563357]: Starting Mailman's
master runner
Oct 05 12:32:08 hestia. mydomain.eu mailman[1563357]: Generating MTA alias
maps
Oct 05 12:32:08 hestia. mydomain.eu systemd[1]: *mailman3.service: Can't
open PID file /opt/mailman/venv/master.pid (yet?) after start: Ope*>
Oct 05 12:32:08 hestia. mydomain.eu systemd[1]: Started GNU Mailing List
Manager.
*Note the above warning for the master.pid file. However the file exists
and is writeable*
------
*Mailman web service*
● mailmanweb.service - GNU Mailman Web UI
Loaded: loaded (/etc/systemd/system/mailmanweb.service; disabled;
vendor preset: enabled)
Active: active (running) since Thu 2023-10-05 12:51:46 EEST; 9min ago
Main PID: 1578503 (gunicorn)
Tasks: 2 (limit: 9255)
Memory: 67.2M
CPU: 753ms
CGroup: /system.slice/mailmanweb.service
├─1578503 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/gunicorn -c /etc/mailman3/gunicorn.conf
mailman_web.wsgi:application
└─1578505 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/gunicorn -c /etc/mailman3/gunicorn.conf
mailman_web.wsgi:application
Oct 05 12:51:46 hestia.mydomain.eu systemd[1]: Started GNU Mailman Web UI.
Oct 05 12:51:46 hestia. mydomain.eu gunicorn[1578503]: !!!
Oct 05 12:51:46 hestia. mydomain.eu gunicorn[1578503]: !!! *WARNING:
configuration file should have a valid Python extension*.
Oct 05 12:51:46 hestia. mydomain.eu gunicorn[1578503]: !!!
*Another warning above, however the service is starting normally.*
------
*Django Qcluster*
● qcluster.service - HyperKitty async tasks runner
Loaded: loaded (/etc/systemd/system/qcluster.service; disabled; vendor
preset: enabled)
Active: active (running) since Thu 2023-10-05 12:51:40 EEST; 10min ago
Main PID: 1578463 (mailman-web)
Tasks: 8 (limit: 9255)
Memory: 101.2M
CPU: 30.915s
CGroup: /system.slice/qcluster.service
├─1578463 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/mailman-web qcluster --pythonpath /etc/mailman3
--settings settings
├─1578465 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/mailman-web qcluster --pythonpath /etc/mailman3
--settings settings
├─1578466 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/mailman-web qcluster --pythonpath /etc/mailman3
--settings settings
├─1578467 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/mailman-web qcluster --pythonpath /etc/mailman3
--settings settings
├─1578468 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/mailman-web qcluster --pythonpath /etc/mailman3
--settings settings
├─1578469 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/mailman-web qcluster --pythonpath /etc/mailman3
--settings settings
├─1578470 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/mailman-web qcluster --pythonpath /etc/mailman3
--settings settings
└─1578471 /opt/mailman/venv/bin/python3
/opt/mailman/venv/bin/mailman-web qcluster --pythonpath /etc/mailman3
--settings settings
Oct 05 12:51:40 hestia. mydomain.eu systemd[1]: Started HyperKitty async
tasks runner.
Oct 05 12:51:40 hestia. mydomain.eu mailman-web[1578463]: 09:51:40 [Q]
INFO Q Cluster washington-solar-muppet-alanine starting.
Oct 05 12:51:40 hestia. mydomain.eu mailman-web[1578466]: 09:51:40 [Q]
INFO Process-1:1 ready for work at 1578466
Oct 05 12:51:40 hestia. mydomain.eu mailman-web[1578467]: 09:51:40 [Q]
INFO Process-1:2 ready for work at 1578467
Oct 05 12:51:40 hestia. mydomain.eu mailman-web[1578468]: 09:51:40 [Q]
INFO Process-1:3 ready for work at 1578468
Oct 05 12:51:40 hestia. mydomain.eu mailman-web[1578469]: 09:51:40 [Q]
INFO Process-1:4 ready for work at 1578469
Oct 05 12:51:41 hestia. mydomain.eu mailman-web[1578470]: 09:51:41 [Q]
INFO Process-1:5 monitoring at 1578470
Oct 05 12:51:41 hestia. mydomain.eu mailman-web[1578465]: 09:51:41 [Q]
INFO Process-1 guarding cluster washington-solar-muppet-alanine
Oct 05 12:51:41 hestia. mydomain.eu mailman-web[1578465]: 09:51:41 [Q]
INFO Q Cluster washington-solar-muppet-alanine running.
Oct 05 12:51:41 hestia.mydomain.eu mailman-web[1578471]: 09:51:41 [Q] INFO
Process-1:6 pushing tasks at 1578471
------
Nginx (hestia CP virtual hosts)
server {
listen 1.2.3.4:80;
server_name lists.mydomain <http://lists.mydomain.com>.eu;
location /static/ {
alias /opt/mailman/venv/web/static/;
}
location / {
proxy_pass http://127.0.0.1:8000;
proxy_set_header Host $host;
proxy_set_header X-Forwarded-For $remote_addr;
}
}
------
Happy to share my other mailman or EXIM4 configuration files if needed.
Thanks in advance.
Kyriakos
___________________________________________
Mailman's content filtering has removed the
following MIME parts from this message.
Content-Type: image/png
Name: image.png
Content-Type: image/png
Name: =?UTF-8?B?U2NyZWVuc2hvdCAyMDIzLTEwLTExIGF0IDEwLjU3LjMx4oCvQU0ucG5n?=
Replaced multipart/alternative part with first alternative.
1 year, 1 month
Difficulties setting up MM3 with Postfix MTA in Docker Environment: Invalid EHLO domain name & Authentification as lists.local
by Niklas Frühauf
Hi everyone,
I managed to setup mailman using the maxking/mailman-* docker containers, connected to a postfix/dovecot mailserver and a mysql database.
The mail domain is @mail.local, mailman is reachable at lists.local.
I can see the mailman UI fine, its connection to the database is working as well, the only things that’s not working is the initial login: When I try to login with the correct credentials of the superuser I added, I get An error occurred while processing your request.
To me it seems like mailman is trying to authenticate as “lists.local” or “mail.local” or “localhost” to postfix (which of course isn’t working), then issues a EHLO/HELO to postfix which is not a FQDN.
So I guess the latter issue could be resolved by providing a FQDN by mailman.
These are the logfiles from the period:
mail | Oct 21 11:15:07 mail postfix/postscreen[1862]: CONNECT from [172.18.18.8]:49288 to [172.18.18.254]:25
ldap_1 | 5bcc5fc1 conn=1000 fd=12 ACCEPT from IP=172.18.19.8:49252 (IP=0.0.0.0:389)
ldap_1 | 5bcc5fc1 conn=1000 op=0 BIND dn="cn=admin,dc=..." method=128
ldap_1 | 5bcc5fc1 conn=1000 op=0 BIND dn="cn=admin,dc=..." mech=SIMPLE ssf=0
ldap_1 | 5bcc5fc1 conn=1000 op=0 RESULT tag=97 err=0 text=
ldap_1 | 5bcc5fc1 conn=1000 op=1 SRCH base="ou=users,dc=..." scope=2 deref=0 filter="(mail=lists.local)"
ldap_1 | 5bcc5fc1 conn=1000 op=1 SRCH attr=mail
ldap_1 | 5bcc5fc1 conn=1000 op=1 SEARCH RESULT tag=101 err=0 nentries=0 text=
ldap_1 | 5bcc5fc1 conn=1000 op=2 SRCH base="ou=users,dc=..." scope=2 deref=0 filter="(?mailGroupMember=lists.local)"
ldap_1 | 5bcc5fc1 conn=1000 op=2 SRCH attr=mail
ldap_1 | 5bcc5fc1 conn=1000 op=2 SEARCH RESULT tag=101 err=0 nentries=0 text=
ldap_1 | 5bcc5fc1 conn=1000 op=3 SRCH base="ou=users,dc=..." scope=2 deref=0 filter="(|(mail=*@lists.local)(mailalias=*@lists.local))"
ldap_1 | 5bcc5fc1 conn=1000 op=3 SRCH attr=mail
ldap_1 | 5bcc5fc1 <= mdb_substring_candidates: (mail) not indexed
ldap_1 | 5bcc5fc1 <= mdb_substring_candidates: (mailalias) not indexed
ldap_1 | 5bcc5fc1 conn=1000 op=3 SEARCH RESULT tag=101 err=0 nentries=0 text=
ldap_1 | 5bcc5fc1 conn=1000 op=4 SRCH base="ou=users,dc=..." scope=2 deref=0 filter="(mail=mail.local)"
ldap_1 | 5bcc5fc1 conn=1000 op=4 SRCH attr=mail
ldap_1 | 5bcc5fc1 conn=1000 op=4 SEARCH RESULT tag=101 err=0 nentries=0 text=
ldap_1 | 5bcc5fc1 conn=1000 op=5 SRCH base="ou=users,dc=..." scope=2 deref=0 filter="(?mailGroupMember=mail.local)"
ldap_1 | 5bcc5fc1 conn=1000 op=5 SRCH attr=mail
ldap_1 | 5bcc5fc1 conn=1000 op=5 SEARCH RESULT tag=101 err=0 nentries=0 text=
ldap_1 | 5bcc5fc1 conn=1000 op=6 SRCH base="ou=users,dc=..." scope=2 deref=0 filter="(|(mail=*@mail.local)(mailalias=*@mail.local))"
ldap_1 | 5bcc5fc1 conn=1000 op=6 SRCH attr=mail
ldap_1 | 5bcc5fc1 <= mdb_substring_candidates: (mail) not indexed
ldap_1 | 5bcc5fc1 <= mdb_substring_candidates: (mailalias) not indexed
ldap_1 | 5bcc5fc1 conn=1000 op=6 SEARCH RESULT tag=101 err=0 nentries=0 text=
ldap_1 | 5bcc5fc1 conn=1000 op=7 SRCH base="ou=users,dc=..." scope=2 deref=0 filter="(mail=lists.local)"
ldap_1 | 5bcc5fc1 conn=1000 op=7 SRCH attr=mail
ldap_1 | 5bcc5fc1 conn=1000 op=7 SEARCH RESULT tag=101 err=0 nentries=0 text=
ldap_1 | 5bcc5fc1 conn=1000 op=8 SRCH base="ou=users,dc=..." scope=2 deref=0 filter="(?mailGroupMember=lists.local)"
ldap_1 | 5bcc5fc1 conn=1000 op=8 SRCH attr=mail
ldap_1 | 5bcc5fc1 conn=1000 op=8 SEARCH RESULT tag=101 err=0 nentries=0 text=
ldap_1 | 5bcc5fc1 conn=1000 op=9 SRCH base="ou=users,dc=..." scope=2 deref=0 filter="(|(mail=*@lists.local)(mailalias=*@lists.local))"
ldap_1 | 5bcc5fc1 conn=1000 op=9 SRCH attr=mail
ldap_1 | 5bcc5fc1 <= mdb_substring_candidates: (mail) not indexed
ldap_1 | 5bcc5fc1 <= mdb_substring_candidates: (mailalias) not indexed
ldap_1 | 5bcc5fc1 conn=1000 op=9 SEARCH RESULT tag=101 err=0 nentries=0 text=
mail | Oct 21 11:15:13 mail postfix/postscreen[1862]: PASS OLD [172.18.18.8]:49288
mail | Oct 21 11:15:13 mail postfix/smtpd[1873]: connect from srv-docker_mailman-web_1.srv-docker_frontend[172.18.18.8]
mail | Oct 21 11:15:17 mail postfix/postscreen[1862]: warning: dnsblog reply timeout 10s for list.dnswl.org
mail | Oct 21 11:15:27 mail postfix/dnsblog[1866]: warning: dnsblog_query: lookup error for DNS query 8.18.18.172.list.dnswl.org: Host or domain name not found. Name service error for name=8.18.18.172.list.dnswl.org type=A: Host not found, try again
ldap_1 | 5bcc5fdf conn=1000 op=10 SRCH base="ou=users,dc=..." scope=2 deref=0 filter="(mail=lists.local)"
ldap_1 | 5bcc5fdf conn=1000 op=10 SRCH attr=mail
ldap_1 | 5bcc5fdf conn=1000 op=10 SEARCH RESULT tag=101 err=0 nentries=0 text=
ldap_1 | 5bcc5fdf conn=1000 op=11 SRCH base="ou=users,dc=..." scope=2 deref=0 filter="(?mailGroupMember=lists.local)"
ldap_1 | 5bcc5fdf conn=1000 op=11 SRCH attr=mail
ldap_1 | 5bcc5fdf conn=1000 op=11 SEARCH RESULT tag=101 err=0 nentries=0 text=
ldap_1 | 5bcc5fdf conn=1000 op=12 SRCH base="ou=users,dc=..." scope=2 deref=0 filter="(|(mail=*@lists.local)(mailalias=*@lists.local))"
ldap_1 | 5bcc5fdf conn=1000 op=12 SRCH attr=mail
ldap_1 | 5bcc5fdf <= mdb_substring_candidates: (mail) not indexed
ldap_1 | 5bcc5fdf <= mdb_substring_candidates: (mailalias) not indexed
ldap_1 | 5bcc5fdf conn=1000 op=12 SEARCH RESULT tag=101 err=0 nentries=0 text=
ldap_1 | 5bcc5fdf conn=1000 op=13 SRCH base="ou=users,dc=..." scope=2 deref=0 filter="(mail=localhost)"
ldap_1 | 5bcc5fdf conn=1000 op=13 SRCH attr=mail
ldap_1 | 5bcc5fdf conn=1000 op=13 SEARCH RESULT tag=101 err=0 nentries=0 text=
ldap_1 | 5bcc5fdf conn=1000 op=14 SRCH base="ou=users,dc=..." scope=2 deref=0 filter="(?mailGroupMember=localhost)"
ldap_1 | 5bcc5fdf conn=1000 op=14 SRCH attr=mail
ldap_1 | 5bcc5fdf conn=1000 op=14 SEARCH RESULT tag=101 err=0 nentries=0 text=
ldap_1 | 5bcc5fdf conn=1000 op=15 SRCH base="ou=users,dc=..." scope=2 deref=0 filter="(|(mail=*@localhost)(mailalias=*@localhost))"
ldap_1 | 5bcc5fdf conn=1000 op=15 SRCH attr=mail
ldap_1 | 5bcc5fdf <= mdb_substring_candidates: (mail) not indexed
ldap_1 | 5bcc5fdf <= mdb_substring_candidates: (mailalias) not indexed
ldap_1 | 5bcc5fdf conn=1000 op=15 SEARCH RESULT tag=101 err=0 nentries=0 text=
ldap_1 | 5bcc5fdf conn=1000 op=16 SRCH base="ou=users,dc=..." scope=2 deref=0 filter="(mail=lists.local)"
ldap_1 | 5bcc5fdf conn=1000 op=16 SRCH attr=mail
ldap_1 | 5bcc5fdf conn=1000 op=16 SEARCH RESULT tag=101 err=0 nentries=0 text=
ldap_1 | 5bcc5fdf conn=1000 op=17 SRCH base="ou=users,dc=..." scope=2 deref=0 filter="(?mailGroupMember=lists.local)"
ldap_1 | 5bcc5fdf conn=1000 op=17 SRCH attr=mail
ldap_1 | 5bcc5fdf conn=1000 op=17 SEARCH RESULT tag=101 err=0 nentries=0 text=
ldap_1 | 5bcc5fdf conn=1000 op=18 SRCH base="ou=users,dc=..." scope=2 deref=0 filter="(|(mail=*@lists.local)(mailalias=*@lists.local))"
ldap_1 | 5bcc5fdf conn=1000 op=18 SRCH attr=mail
ldap_1 | 5bcc5fdf <= mdb_substring_candidates: (mail) not indexed
ldap_1 | 5bcc5fdf <= mdb_substring_candidates: (mailalias) not indexed
ldap_1 | 5bcc5fdf conn=1000 op=18 SEARCH RESULT tag=101 err=0 nentries=0 text=
mail | Oct 21 11:15:43 mail policyd-spf[1886]: prepend Received-SPF: Temperror (mailfrom) identity=mailfrom; client-ip=172.18.18.8; helo=c98c668820fd; envelope-from=postorius(a)lists.local; receiver=<UNKNOWN>
mail | Oct 21 11:15:43 mail postfix/smtpd[1873]: NOQUEUE: reject: RCPT from srv-docker_mailman-web_1.srv-docker_frontend[172.18.18.8]: 504 5.5.2 <c98c668820fd>: Helo command rejected: need fully-qualified hostname; from=<postorius(a)lists.local> to=<niklas.fruehauf(a)mail.local> proto=ESMTP helo=<c98c668820fd>
mail | Oct 21 11:15:43 mail postfix/postscreen[1862]: CONNECT from [172.18.18.8]:49304 to [172.18.18.254]:25
mail | Oct 21 11:15:43 mail postfix/postscreen[1862]: PASS OLD [172.18.18.8]:49304
mail | Oct 21 11:15:43 mail postfix/smtpd[1903]: connect from srv-docker_mailman-web_1.srv-docker_frontend[172.18.18.8]
proxy_1 | 172.18.18.1 - - [21/Oct/2018:11:16:13 +0000] "POST /accounts/login/ HTTP/1.1" 500 1102 "https://lists.local/accounts/login/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36" "-"
6 years, 1 month
Re: Upgrade-path from Ubuntu18LTS to recent mailman release
by Stefan Bauer
Thank you all for your time. I managed to do a fresh installation. The MM
documentation is very good.
As i only use sqlite, i will give it a try to just copy the database files.
Stefan
Am Do., 5. Mai 2022 um 11:11 Uhr schrieb Stephen J. Turnbull <
stephenjturnbull(a)gmail.com>:
> Stefan Bauer writes:
>
> > thanks alot. That looks promising. Can we just copy the current
> > mailman3-database and take the configurations or is there a specific
> > migration path we have to follow?
>
> Much of the documentation on mailman.readthedocs.io discusses
> migrations and upgrades. You should read those for general hints.
>
> The distro Mailman to venv Mailman case is more discussed here on the
> mailing list than in those documents. I don't have pointers to those
> threads or the time to look offhand, maybe over the next few weeks as
> I work on our GSoC project. If you do find any, and would post them
> here, I'll make sure they get into the docs.
>
> The main thing is to backup Mailman configs (probably in /etc/mailman
> or /etc/mailman3) and the backend database (core, Postorius, possibly
> HyperKitty depending on configuration, and the django-mailman auth
> stuff) before trying to migrate. (For the backend database I would
> just dump the RDBMS unless non-Mailman content is really huge.) The
> nature of the virtualenv install is such that it *will not* overwrite
> any of the distro files at all (as long as you put it in /usr/local or
> /opt). However, you want to preserve the configs and database and
> reuse them, so those *must* be backed up.
>
> > We are currently running 3.1.1-9 (Ubuntu 18).
>
> Ubuntu 18 is probably old enough that you need to be careful about
> MySQL and its derivatives. The specific problems are (1) you need to
> specify the right UTF-8 variant for the coding system, and (2) more
> recent versions of Mailman tend to make certain records overflow.
>
> If you're using PostgreSQL these caveats *do not* apply. If you're
> using sqlite3 (I doubt it, but just for completeness) you should
> change to PostgreSQL or MySQL. If you're using something else (same
> caveat), I can't really say. Probably somebody out there is using
> Oracle or whatever, but we don't know about that. :-)
>
> Steve
>
>
2 years, 6 months