Search results for "Postorius" - Mailman-users

Re: Database deadlock when trying to delete a member.

by Simon Coggins

> On 18 Mar 2021, at 5:05 pm, Abhilash Raj <maxking(a)asynchronous.in> wrote: > > Hi Simon, > > > On Mar 17, 2021, at 10:16 PM, Simon Coggins <s.coggins(a)cqu.edu.au> wrote: > > > > Hi, > > > > I’ve got a strange error. I migrated from mailman 2.1 to 3 using the migration guide on the website and things have been working fine. But I’m in the process of testing the new syncmembers command to replace some inhouse mailman API code we wrote. I’ve tracked my problem down to what appears to be a deadlock in the postgresql database. When trying to delete certain users the SQL query hangs and never returns. > > > > After doing some tracing and tracking it down to the database, I enabled DB logging of all queries and saw that the following query was never returning: > > > > DELETE FROM member WHERE member.id = 166814 > > > > If I try to run it manually I get the same issue, in psql it never returns. > > mailman=# explain analyze DELETE FROM member WHERE member.id = 166814; > > [… 60 seconds passes…] > > ^CCancel request sent > > ERROR: canceling statement due to user request > > CONTEXT: while deleting tuple (2998,72) in relation "member" > > I’m just wondering if there are any commands or scripts I can run to verify the database and it’s constraints to see if there is some error in the database data? Or where you’d recommend I go from here? It only impacts the user on this specific list. If I add this user to another list and remove them, everything works fine. > > Are you able to retrieve that Member object using API? > > This[1] the Python code which would try to delete a Member object and I > am assuming is being called from syncmembers command. I am not entire > sure about what would cause the database to hang, if there was some database > constraint that failed, I would imagine some error to be returned. > > [1]: https://gitlab.com/mailman/mailman/-/blob/master/src/mailman/model/member.p… > Ok I think I’m getting closer. It appears to be an open transaction that is locking the database record. While mailman is running, if I try to execute "DELETE FROM member WHERE member.id = 166507;” on the mailman table in psql the query hangs and never returned. But if I shutdown mailman and try to run the query again, it executed immediately. So I’m pretty sure there is an open transaction that is causing the entry to be locked. > One thing you can try is see if you can unsubscribe the user using the API or > `mailman shell` command. > > You can unsubscribe from API by calling a `DELETE` method at > > http://localhost:9001/3.1/members/<member_id> > > This would give us some indication about whether there is some bug > in the implementation of syncmembers command or if there is something > else going on. > Trying via shell or via API to delete the user all fail and hang. I’m able to receive the user/membership/list data without any issue both via mailman command and via the API. > > > > This is on a test system so I can do various testing. I’m trying to find the root cause so that I can verify my production system isn’t impacted by the same thing. > > > > > > Setup Details: > > OS: Oracle Linux 7 (Redhat) > > Installed using pip via virtualenv talking to a local pgsql database on the same box. > > Data was migrated from a mailman 2.1 install into mailman3 using migration instructions on the website. > > > > PIP Modules versions: > > django-mailman3 1.3.5 > > mailman 3.3.3 > > mailman-hyperkitty 1.1.0 > > mailmanclient 3.3.2 > > postorius 1.3.4 > > psycopg2-binary 2.8.5 > > What is the version of sqlalchemy package? There is a new 1.4.0 version that came out recently > and is incompatible with Core right now. There are backwards incompatible changes which might > need some changes in Core to add support. > SQLAlchemy 1.3.19 > > > > RPM packages: > > postgresql12-12.6-1PGDG.rhel7.x86_64 > > postgresql12-server-12.6-1PGDG.rhel7.x86_64 > > postgresql12-libs-12.6-1PGDG.rhel7.x86_64 > > postgresql12-devel-12.6-1PGDG.rhel7.x86_64 > > > > > > -Simon > > > > > > _______________________________________________ > > 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) > > > _______________________________________________ > 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/ --- Simon Coggins, Principal Systems Engineer Digital Services Directorate CQUniversity, Lvl 6.14, 160 Ann Street Brisbane, QLD, 4000 Email: s.coggins(a)cqu.edu.au Web: http://www.cqu.edu.au/

4 years, 11 months

Re: Mailman Core 3.3.2 is now out

by Abhilash Raj

I missed it in the original email, but a full list of changes in this version is present here: https://docs.mailman3.org/projects/mailman/en/latest/src/mailman/docs/NEWS.… thanks, Abhilash On Fri, Nov 6, 2020, at 5:38 PM, Abhilash Raj wrote: > Hi Everyone, > > I am pleased to announce that with a week long delay from the planned date, > GNU Mailman Core 3.3.2 is now finally out. This release includes both bug fixes > and some new features. > > Some notable changes include: > - Support for inviting users to join mailing lists. > - New adddmembers, delmembers and syncmembers command to manage > membership from CLI. > - Addition of new REST API endpoints that return the count of held > messages and subscription requests of much faster page loads in > Postorius. > - Addition of support for filtering in some API endpoints like > Members and Subscription requests. > - Support for address= option in email join command to subscribe an > address other then sending address. > - Addition of who email command to lookup memberships. > - Expose emergency field for MailingList resource in REST API. > - Several bug fixes to support new major version of libraries like > dnspython, flufl.* etc. > > You can install it using: > > $ pip install --upgrade mailman > > The tarball for the release is available at PyPI: > > https://pypi.org/project/mailman/ > > Finally, many thanks to all the contributors who have helped make this > release a success! > > -- > Abhilash Raj (maxking) on behalf of Mailman Core team > -- thanks, Abhilash Raj (maxking)

5 years, 3 months

Getting Archives to work - new setup on Ubuntu 18.04 (with mailman3-full pkg)

by kelly.close＠lrewater.com

Happy New Year! I'm setting up my first Mailman 3 server and was delighted to find a distribution package for Ubuntu 18.04, since that's the environment I'm most familiar with working in, that installs an integrated mailman3-hyperkitty-postorius setup. The package install plus the additional config steps in the included README files have gotten me oh-so-very close! What isn't working yet are the archives, specifically the messages sent to lists showing up at .../mailman3/hyperkitty. I'm at a loss and I'm hoping maybe the folks on this list can help me bring it home. Messages are distributed to subscribers as they should be - subscribers can send from their emails or from the web site. People can subscribe, etc. It's all working great. Just no archives. I am able to successfully run these django-admin processes without errors (described here: http://docs.mailman3.org/en/latest/config-web.html#scheduled-tasks-required) I've run them all manually and then I've been running the minutely and hourly ones manually after each test message I send (haven't set up the actual cron jobs yet). I'm not sure what to try next or what info to provide here for help - can anyone suggest where I can look to see why archives aren't getting created, or let me know what information would be essential for me to post to get help on this? I'm using PostgreSQL for the database, Postfix for mail and Apache2 for the web server. Thanks for your time! ~Kelly

7 years, 1 month

Re: Modify approval email

by Jens Günther

Yes. As already described, you can set it **per list** in Postorious. Though, you can also set it systemwide with a template in [..]/var/templates/site/de/list:admin:action:post.txt (where de should be changed to it/en in your case, I suppose!?) and the following link: https://$domain/postorius/lists/$short_listname.$domain/held_messages (maybe you also need the other variables: $list_id and $reasons) This can also be set per domain as a template in /var/templates/domains/$domain/$your-language/... Regards, Jens. Am 15.09.23 um 13:22 schrieb pau.baiges(a)csuc.cat: > Good morning, > Is there a way to modify the email that is sent by default to list owners when a non-list member sends email to the list? > Basically the default email that is sent is this: > > ________________________________________________________ > As list administrator, your authorization is requested for the > following mailing list posting: > > List: lis1(a)llistes.csuc.cat > From: jim(a)csuc.cat > Subject: test > > The message is being held because: > > El missatge no és d'un membre de la llista > > At your convenience, visit your dashboard to approve or deny the > request. > _____________________________________________________________________ > > We would like to add the link to the page to accept the email from the list itself. > I think I remember that in the old mailman it could be done > Thanks! > _______________________________________________ > 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/ > Archived at: https://lists.mailman3.org/archives/list/mailman-users@mailman3.org/message… > > This message sent to jens.guenther(a)posteo.de

2 years, 5 months

Re: Django: An error occurred while processing your request.

by Odhiambo Washington

On Mon, May 26, 2025 at 7:16 PM Florian Sukup <florian2025(a)sukup.at> wrote: > Hi, > > I running Debian bookworm and have installed mailman3-full (+ postfix). > > I am new to mailman3 (using mailman2 now) and about exploring how to > migrate. > > I had 3 sites or domains: example.com and two real ones. > > When I received emails from postorius, then it came from example.com > which is nonsense as I worked with the real lists. So I deleted > example.com. > > When I call https://.../mailman3/admin or any of the lists, the result is: > Server error > An error occurred while processing your request. > > How can I get out of it? This is only a test environment, so no heart > attack. > Welcome to MM3. You can get out of that by entering the database and checking the site_id for the domain you created, entering that ID into settings.py and restarting mailmanweb. Just to help you a little more, the recommended method for installing Mailman2 is documented at: https://docs.mailman3.org/en/latest/install/virtualenv.html If you use the Debian packages, chances of getting support from this forum will be close to remote as the developers (and for sure many other admins) don't use the packaged versions of MM3. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]

9 months

Re: Uncaught runner exception: 'str' object has no attribute 'decode'

by Mark Sapiro

On 10/02/2017 05:25 AM, Henrik Rasmussen wrote: >> The bottom line is at this point, <https://bugs.python.org/issue27321> >> no longer affects Postorius, but it still affects message delivery. I >> have opened <https://gitlab.com/mailman/mailman/issues/406> about >> defending against that and also the UnicodeEncodeError you included in >> your OP. > > Is there some kind of workaround, I can give my users or something that the list admins can do as a workaround? There is no user or list admin workaround, but the defense is a fairly simple patch. See the MR at <https://gitlab.com/mailman/mailman/merge_requests/322> and the commit at <https://gitlab.com/mailman/mailman/commit/37b3f62afdf225a8e29b66fcefcdb56b9…>. The commit changes 7 files, but only two are needed. The rests are tests or reverting <https://gitlab.com/mailman/mailman/issues/256> which isn't necessary. The only changes you need are those to mailman/email/message.py and mailman/mta/connection.py. >> No. 'bin/mailman queue' is the Mailman 3 command. The Mailman 2 command >> is 'bin/show_qfiles'. > > I much be in the wrong place because when I do a 'docker exec -it mailman-core bash' and do a 'mailman --help' I don't see a 'queue' argument. The only bin/mailman I have inside the mailman-core container is /usr/local/bin/mailman, which is the same command. My bad. The name is 'qfile', not 'queue'. Sorry about that. -- Mark Sapiro <mark(a)msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan

8 years, 4 months

Re: Mailman Core 3.3.2 is now out

by Seth Seeger

When will these changes be available via the docker container? Thanks, Seth > On Nov 6, 2020, at 8:38 PM, Abhilash Raj <maxking(a)asynchronous.in> wrote: > > Hi Everyone, > > I am pleased to announce that with a week long delay from the planned date, > GNU Mailman Core 3.3.2 is now finally out. This release includes both bug fixes > and some new features. > > Some notable changes include: > - Support for inviting users to join mailing lists. > - New adddmembers, delmembers and syncmembers command to manage membership from CLI. > - Addition of new REST API endpoints that return the count of held messages and subscription requests of much faster page loads in Postorius. > - Addition of support for filtering in some API endpoints like Members and Subscription requests. > - Support for address= option in email join command to subscribe an address other then sending address. > - Addition of who email command to lookup memberships. > - Expose emergency field for MailingList resource in REST API. > - Several bug fixes to support new major version of libraries like dnspython, flufl.* etc. > > You can install it using: > > $ pip install --upgrade mailman > > The tarball for the release is available at PyPI: > > https://pypi.org/project/mailman/ > > Finally, many thanks to all the contributors who have helped make this release a success! > > -- > Abhilash Raj (maxking) on behalf of Mailman Core team > _______________________________________________ > 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/

5 years, 3 months

Re: Is there an option to "disable" a list temporarily? (feature request?!)

by Washington Odhiambo

On Mon, Feb 2, 2026 at 2:27 PM Christian Schneider < christian.schneider(a)tu-dortmund.de> wrote: > Hello dear Mailman Team, > > I scanned through the web interface of my mailman instance... > and I did not find an option to disable a list temporarily ("sending" and > "access to web interface")... > This might come in handy when a list is abused for sending spams > or when a list owner wants his/her list to be removed... > Instead of removing the list instantly I would disable it for three months > first... > (You never know with users... ;-) ) > Preferably I would backup the list (settings and members) and the archives, > but as seen in the discussion there is actually no backup mechanism for > lists... > > Is there an option to disable a list (except from resetting passwords and > remove/disable mail aliases)? > To disable access to Postorius, you can achieve that using the web server. To disable mail processing, you do that by disabling the mail aliases or just redirect a list address to /dev/null. > If not I'd like to hand this in as a feature request... xD > I always see the Devs say that you do that by creating an issue in gitlab. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]

3 weeks, 4 days

Re: starting gunicorn per mailman.log yet gunicorn not installed

by Mark Sapiro

On 6/26/23 1:15 AM, Odhiambo Washington wrote: > On Mon, Jun 26, 2023 at 9:29 AM Stephen J. Turnbull < > turnbull.stephen.fw(a)u.tsukuba.ac.jp> wrote: > >> Yes, it makes sense. Mailman 3 core is basically an application which >> manages a webserver that provides the REST API, a database of domains, >> users, and lists, an LMTP server for incoming posts and an SMTP client >> for outgoing distribution. Mailman uses gunicorn to provide the >> webserver. >> >> Installation of gunicorn is handled as a package dependency, so you >> probably wouldn't notice unless you were watching the installation >> process very carefully. >> > > It doesn't make sense, IMHO, because as the OP says, > 1. his ExecStart is: > ExecStart=/opt/mailman/venv/bin/uwsgi --ini /etc/mailman3/uwsgi.ini" *and > not* > ExecStart=/opt/mailman/venv/bin/gunicorn -c /etc/mailman3/gunicorn.conf > mailman_web.wsgi:application. > > 2. He has not knowingly created any gunicorn.conf > > Why would Gunicorn be Exec-ing itself? :-) As Steve says, Mailman core uses Gunicorn to manage it's REST API. This has nothing to do with whatever WSGI server (uWSGI, Gunicorn, Apache mod_wsgi, ...) is used to support the Django applications (django-mailman3, hyperkitty and postorius). I.e., there is always a Gunicorn instance configured and started by Mailman core, regardless of whatever WSGI server supports Django or even if one isn't running Django at all. -- Mark Sapiro <mark(a)msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan

2 years, 8 months

Re: Can't add emails to accept_these_nonmembers

by Ibiam Chihurumnaya

Stephen J. Turnbull wrote: > Ibiam Chihurumnaya via Mailman-users writes: > > I had done the members part in the past, but the issue with it was > > I wanted certain members to not receive messages from the list, but > > only send to the list. > > As Mark explained, you can set those members to 'Default Processing' > in the moderation option, and to 'No Mail' in the mail options. In > that case they or list owners could reset them to receive mail. Yes, I'll try this. > The alternative is to add the addresses one by one as non-members and > set their moderation. In that case they cannot receive mail, although > they may be able to subscribe themselves depending on list settings, > or an administrator could subscribe them. In both cases the nonmember > would remain unless removed by an administrator. > In both cases, although you can add members with mass subscription, > there are no "mass" operations to update the subscription option or to > create non-members in Postorius, you need to do it one by one. You > can automate that by using a loop over a list of addresses in Mailman > shell, or if you expect to do it more than once, you could create a > withlist script to use with the -r option. It's just a few emails so I'm doing it manually. > -- > GNU Mailman consultant (installation, migration, customization) > Sirius Open Source https://www.siriusopensource.com/ > Software systems consulting in Europe, North America, and Japan

21 hours, 10 minutes

Mailman-users search results for query "Postorius"