Search results for "sapiro" - lists.mailman3.org

[MM3-users] Re: Getting original message headers

by Peter Chubb

>>>>> "Mark" == Mark Sapiro <mark(a)msapiro.net> writes: Mark> On 1/5/26 12:25, Peter Chubb via Mailman-users wrote: >> >> I think they must have been posting via hyperkitty. The first >> received: line is localhost then the mailman server. Is there a >> way to turn that ability off? Mark> If the posting is from Hyperkitty, there should be a Mark> User-Agent: HyperKitty on <list URL> There is. Mark> Are the spammer's list members? If so, you need to remove them Mark> and then set `Default action to take when a member posts to the Mark> list` to `Hold for moderation`. That way, when a new member Mark> posts for the first time, the message will be held and if it's Mark> spam, you can discard it and set the member's moderation action Mark> to discard. and if it's not spam you can accept the message and Mark> set the member's moderation action to default processing. I've done all this now; I've also required moderation to join the (unadvertised) lists. We had the 'moderate until first good message' policy on all advertised lists; but were expecting that unadvertised lists could not be found to be subscribed and posted to. This is not the case. Peter C

4 months, 2 weeks

[MM3-users] Re: SUBSCRIBE_FORM_SECRET in MM3?

by Phil Stracchino

On 2020-01-30 12:01, Mark Sapiro wrote: > On 1/30/20 1:50 AM, Gila Halpern wrote: >> I've been looking into ways to prevent spam on my company's list, and one thing I came across was the SUBSCRIBE_FORM_SECRET option in the Mailman configuration, which embeds a CSRF token into the form, and prevents it from being submitted until five seconds after it renders, to keep bots from subscribing. Unfortunately, the information I found pertained to Mailman 2. Does this option exist in MM3 as well, or is there a similar option? > > > This feature in MM 2.1 is not very effective. On mail.python.org, this > feature as well as reCAPTCHA is enabled (e.g. > <https://mail.python.org/mailman/listinfo/mailman-users>) and we still > get periodic attacks of robotic subscribes that get around these measures. Human verification vs. verification-defeating countermeasures is an ongoing arms race which, frankly, humans have been losing for a long time. I have more than once commented, not entirely joking, that we're reaching a point where *FAILURE* to complete the CAPTCHA is evidence that you're a human. We need to come up with a better verification paradigm than presenting increasingly difficult puzzles which AI agents are better overall at solving than humans are. -- Phil Stracchino Babylon Communications phils(a)caerllewys.net phil(a)co.ordinate.org Landline: +1.603.293.8485 Mobile: +1.603.998.6958

6 years, 3 months

[MM3-users] Re: Mailman3 reinstall fail, need some help

by Yvan ♞

Hello every body I have progress to try to reinstall mailman3 on yunohost server but I still have an error, if somebody can help me as I don't understand the log https://paste.yunohost.org/raw/ugijepuyuv Sincerely. Yvan Le 14/03/2022 à 16:31, Yvan ♞ a écrit : > Ok thanks, I'll try on debian forum as I already unsuccessfully tried > on yunohost since 6 months. > > Le 14/03/2022 à 16:23, Mark Sapiro a écrit : >> On 3/14/22 08:12, Yvan ♞ wrote: >>> Maybe an idea of my problem as I have pgadmin app installed, it >>> could be in conflict to create a postgresql db? >> >> Your original dbug logs seem to show no issue with postgresql. >> >> I don't think people on this list can be much help for installing the >> Debian package on YunoHost. As I said earlier, I would go first to >> YunoHost for help and then to Debian if necessary. >> >> If you want help from us, I recommend installing as documented at >> https://docs.mailman3.org/en/latest/install/virtualenv.html >> > _______________________________________________ > 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/

4 years, 1 month

[MM3-users] Re: combine postorius and hyperkitty into one Apache vhost

by Eggert Ehmke

So you prefer Gunicorn over uWSGI? When I have a working installation that uses uwsgi, should I reconfigure for Gunicorn? At the moment I see no reason for this, and while I am open for alternate solutions, ... ´ never change a running system Am Donnerstag, 29. Dezember 2022, 21:48:54 CET schrieb Mark Sapiro: > On 12/29/22 05:51, Wolfgang Rosenauer wrote: > > Hi, > > > > I'm in the process to set up a new mailman3 site. > > (Migrating from mailman2) > > > > There are RPMs for my distribution which integrate postorius and > > hyperkitty with uwsgi. > > I think you'll be much happier if you don't use the distro's RPMs which > are probably out of date and instead follow > <https://docs.mailman3.org/en/latest/install/virtualenv.html>. Those > instructions use uWSGI as a WSGI interface, but Gunicorn > <https://gunicorn.org/> is what is used on the site supporting this > list. The advantages of Gunicorn are it's already installed as a > dependency of Mailman core, and it's what the Mailman developers are > more familiar with. > > I'll work on updating > <https://docs.mailman3.org/en/latest/install/virtualenv.html> to include > Gunicorn as an alternative.

3 years, 4 months

[MM3-users] Re: Upgrade to 3.3.2 fails

by Joel Lord

On 12/26/2020 3:07 PM, Mark Sapiro wrote: > As far as utf8mb4 vs. utf8 is concerned. There will be issues with the > hyperkitty_email table subject and content columns in particular and > maybe others if email messages contain 4-byte utf-8 unicodes. However, > as I read the MySQL docs, for columns like VARCHAR(255) and > VARCHAR(510), the difference affects only the number of characters that > can be stored in the column and not the actual column width. I.e., a > VARCHAR(255) column is actually up to 256 bytes wide (1 byte for length > and up to 255 butes of data) and can thus hold up to 85 3-byte utf-8 > encodings or up to 63 4-byte utf-8 encodings, but since any string > normally contains only a few if any (probably none in the case of the > mailinglist table) the actual limit is much closer to 85. > Earlier I had attempted changing the encoding and collation and manually adding the new column, and it failed with the same error. This fits with Mark's explanation of how the column size and encoding go together. I just ran an "optimize table mailinglist;" and then the update ran clean. Thanks for the eyeballs today, no idea why that would have worked but now we're up and running. -- Joel Lord

5 years, 4 months

[MM3-users] Re: Mailman notify generating emails for request that aren't visible.

by Simon Coggins

Oops sorry I hit send to soon. If I try to go to /lists/listname.example.com/unsubscription_requests<http://listname.example.com/unsubscription_requests> I get a 404, it looks like unsubscription_requests<http://listname.example.com/unsubscription_requests> isn’t in my urls.py list for Postorius? (venv) [mailman@mailman postorius]$ grep version __init__.py # Software Foundation, either version 3 of the License, or (at your option) # any later version. __version__ = '1.3.4' (venv) [mailman@mailman postorius]$ grep _requests urls.py url(r'^subscription_requests$', list_views.list_subscription_requests, name='list_subscription_requests'), I’m upgrading this week to: django-mailman3 1.3.7 mailman 3.3.5 mailman-hyperkitty 1.2.0 mailmanclient 3.3.3 postorius 1.3.6 And I’ve just confirmed that 1.3.6 does have the url endpoint. So I’m guessing it came in in 1.3.5+? (venv) [mailman@mailman-dev postorius]$ grep version __init__.py # Software Foundation, either version 3 of the License, or (at your option) # any later version. __version__ = '1.3.6' (venv) [mailman@mailman-dev postorius]$ grep _requests urls.py re_path(r'^subscription_requests$', list_views.list_subscription_requests, name='list_subscription_requests'), re_path(r'^unsubscription_requests$', list_views.list_unsubscription_requests, name='list_unsubscription_requests'), -Simon --- [https://www.cqu.edu.au/] Mr Simon Coggins Principal Systems Engineer | Digital Services Directorate CQUniversity Australia, Level 6.14, 160 Ann Street, Brisbane, QLD 4000 P +61 7 3295 1182 | X 51182 | M +61 408 115 861 | E s.coggins(a)cqu.edu.au<mailto:s.coggins@cqu.edu.au> [https://www.cqu.edu.au/social-media] I respectfully acknowledge the Traditional Owners of the land on which we work and learn, and pay respect to the First Nations Peoples and their Elders, past, present and future. This communication may contain privileged or confidential information. If you have received this in error, please return to sender and delete. CRICOS: 00219C | RTO Code 40939 On 1 Nov 2021, at 12:15 pm, Simon Coggins <s.coggins(a)cqu.edu.au<mailto:s.coggins@cqu.edu.au>> wrote: The version of postorius is 1.3.4 django-mailman3 1.3.5 mailman 3.3.4 mailman-hyperkitty 1.1.0 mailmanclient 3.3.2 postorius 1.3.4 --- [https://www.cqu.edu.au/] Mr Simon Coggins Principal Systems Engineer | Digital Services Directorate CQUniversity Australia, Level 6.14, 160 Ann Street, Brisbane, QLD 4000 P +61 7 3295 1182 | X 51182 | M +61 408 115 861 | E s.coggins(a)cqu.edu.au<mailto:s.coggins@cqu.edu.au> [https://www.cqu.edu.au/social-media] I respectfully acknowledge the Traditional Owners of the land on which we work and learn, and pay respect to the First Nations Peoples and their Elders, past, present and future. This communication may contain privileged or confidential information. If you have received this in error, please return to sender and delete. CRICOS: 00219C | RTO Code 40939 On 1 Nov 2021, at 12:04 pm, Mark Sapiro <mark(a)msapiro.net<mailto:mark@msapiro.net>> wrote: On 10/31/21 6:11 PM, Simon Coggins wrote: > Hi, > > We’re running mailman 3.3.4 (about to upgrade to 3.3.5 this week). I enabled mailman notify cron a few weeks ago to email out any pending requests for admins. I’ve now got multiple lists that keep emailing out the same outstanding holds but they can’t visible in the GUI. The requests are all duplicates as well. This is a redacted example email: > > -----Original Message----- > From: mailman-alerts(a)example.com<mailto:mailman-alerts@example.com><mailto:mailman-alerts@example.com> > Sent: Monday, 1 November 2021 8:10 AM > To: somelist-owner(a)lists.example.com<mailto:somelist-owner@lists.example.com><mailto:somelist-owner@lists.example.com> > Subject: The somelist(a)lists.example.com<mailto:somelist@lists.example.com><mailto:somelist@lists.example.com> list has 4 moderation requests waiting. > > The somelist(a)lists.example.com<mailto:somelist@lists.example.com><mailto:somelist@lists.example.com> list has 4 moderation requests waiting. > > Held Unsubscriptions: > User: john.smith(a)maildomain.com<mailto:john.smith@maildomain.com><mailto:john.smith@maildomain.com> > User: john.smith(a)maildomain.com<mailto:john.smith@maildomain.com><mailto:john.smith@maildomain.com> > User: john.smith(a)maildomain.com<mailto:john.smith@maildomain.com><mailto:john.smith@maildomain.com> > User: john.smith(a)maildomain.com<mailto:john.smith@maildomain.com><mailto:john.smith@maildomain.com> > > Please attend to this at your earliest convenience. Your lists are configured with Un-Subscription Policy moderate or confirm, then moderate so unsubs require Moderator approval. What Postorius version is this? Prior to 1.3.3, unsubsubscription requests were not visible in Postorius. In 1.3.3_+ they are available in the Subscription requests dropdown at https://example.com/mailman3/lists/listname.example.com/unsubscription_requ…<https://example.com/mailman3/lists/listname.example.com/unsubscription_requ…> although they may not be counted in the Subscription requests count badge. -- Mark Sapiro <mark(a)msapiro.net<mailto:mark@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<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/<https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org>

4 years, 6 months

[MM3-users] [SOLVED] Re: Re: Help with Newbie error -- I think I deleted my server

by William Oliver

On Fri, 2021-12-24 at 21:12 -0800, Mark Sapiro wrote: > On 12/24/21 8:22 PM, William Oliver wrote: > > > > I clicked on that, and it took me to a page where I could add > > servers. > > So, I added my real domain (libertyfp.org) It successfully added > > it, > > so I decided that I clearly didn't need "example.com" as a server, > > and > > deleted it using the same page. > > > > Immediately, I got an "internal server error" and have now lost all > > web > > interfaces. I tried restarting the daemons and rebooting the box, > > to > > no avail. > > > You have to set SITE_ID in your Django settings to the correct value > for > your site. See > https://docs.mailman3.org/en/latest/faq.html#the-domain-name-displayed-in-h… > > Joy! You are a lifesaver. I had to guess at the ID number, but "2" worked. Just out of curiosity, if I could not have guessed a valid ID number and did not have the admin interface, how could I have figured out what site IDs were available? Thanks. billo

4 years, 4 months

[MM3-users] Re: Archive search failing on one list

by Mark

On 2023-09-24 13:28, Mark Sapiro wrote: > On 9/23/23 19:19, Mark wrote: >> >> Yes, the query returns a result and the case in "name" matches that in >> the query ... >> >> select * from hyperkitty_mailinglist where name like >> 'listname(a)domain.com' >> >> id | 91 >> name | listname(a)domain.com >> display_name | Listname >> description | ... >> subject_prefix | [Listname] >> archive_policy | 1 >> created_at | 2023-09-21 08:55:36.385239+2 >> list_id | listname(a)domain.com > > Is that really what you get for list_id? It should have a dot, not at > as listname.domain.com. > > What if you do something like the following where django-admin is > whatever command you use for the Django admin command. > ``` > $ django-admin shell > Python 3.9.16 (main, Dec 11 2022, 12:49:23) > [GCC 9.4.0] on linux > Type "help", "copyright", "credits" or "license" for more information. > (InteractiveConsole) >>>> from hyperkitty.models.mailinglist import MailingList >>>> mlist_name = 'listname(a)domain.com' >>>> mlist = MailingList.objects.get(name=mlist_name) >>>> mlist > <MailingList listname(a)domain.com (listname.domain.com)> >>>> > ``` My bad. I was in too much of a hurry when redacting. The list_id is as you say: listname.domain.com

2 years, 7 months

[MM3-users] Re: Mysterious Bounces Being Logged

by Allan Hansen

All, Appreciation to Brian for bringing this up. After upgrading to MM3, a lot of legitimate users' subscriptions on my lists have been disabled even though they still get at least some messages (according to them), while some were correctly disabled. Yes, I need to be informed of bounces, because when the accounts get disabled, I don't want my reply to be 'Huh? I don't have a clue why.' I reported this before. Yours, Allan On 3/26/21, 14:08 , "Brian Carpenter" <brian_carpenter(a)emwd.com> wrote: On 3/26/21 2:59 PM, Mark Sapiro wrote: > They are being bounced by a downstream MTA. If you want to know why, you > have a few choices. You can mail the address yourself and hopefully get > a DSN back. You can install this patch: I would think any mail administrator for a mailman server would want to know why bounces are happening. I never saw this issue with Mailman 2. Did it exist? Is the patch going to make it to the next version of Mailman 3 core? Are there any plans to make bounce processing more transparent to server admins so we can troubleshoot delivery issues? -- Brian Carpenter Harmonylists.com Emwd.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/

5 years, 1 month

[MM3-users] Re: Moving existing lists to a new domain

by Jeremy Stanley

On 2024-09-18 16:36:50 -0700 (-0700), Mark Sapiro wrote: > On 9/18/24 10:13, Jeremy Stanley wrote: [...] > > Since all the lists for the given domain will be moving to the same > > unused new domain on the existing server, and can move at the same > > time, I suppose this could be done through (offline if necessary) > > backend database update queries. [...] > ``` > UPDATE mailinglist SET mail_host = 'new.domain' WHERE mail_host = > 'old_domain'; > ``` [...] > ``` > UPDATE mailinglist SET list_id = CONCAT(list_name, '.', mail_host) WHERE > mail_host = 'new_domain'; > ``` > For HyperKitty, similar changes need to be made to the > hyperkitty_mailinglist table. The `name` column entries need to be changed > from `listname(a)old.domain` to `listname(a)new.domain` and the `list_id` column > entries need to be changed from `listname.old.domain` to > `listname.new.domain` Preparing to test this, I poked around the schema a bit and noticed that the domain names are also embedded as strings in the following fields: django_mailman3_maildomain.mail_domain django_site.domain django_site.name domain.mail_host Can anyone think of any additional tables/columns which would need updating for this? I'll see if scanning a dump of the full DB content turns up anything I might be missing too. Thanks again! -- Jeremy Stanley

1 year, 5 months

Search results for query "sapiro"