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

[MM3-users] Re: Held messages: Long time waiating for response of the Mailman API

by Stephan Krinetzki

Stephen J. Turnbull wrote: > Mark Sapiro writes: > > mailmancore/API ->database > > that seems to have an issue and only with this one > > DELETE FROM pendedkeyvalue WHERE pendedkeyvalue.id = XXX > > query. However, like you, I have no idea as to what you could do further > > to debug this. > > I have an idea, but it seems so obvious that presumably it's already > been tried: log in to the database as mailman with pgsql and try > deleting something. If that works immediately, try with mailmanclient > and the mailman command line utility. > Steve Well, we didn't try this. Since we don't know what the query for deleting a held message in the database needs to look like, we left that out for now. If someone can help me there, it would be great. Over the mailman shell it hangs as long as on the web ui (using mailman shell -l list@host and iterating over the held messages). So it is the communication Mailman API <-> Database.

3 years, 10 months

[MM3-users] Re: Mailman web interface / uwsgi

by Stephen J. Turnbull

Mark Sapiro writes: > On 11/27/22 00:19, Jan Eden via Mailman-users wrote: > > > > I see. But the mailman.cfg is placed in /etc/mailman3, and this file > > also belongs to the core, doesn't it? In any case, I changed the > > configuration parameter for [archiver.hyperkitty] as you suggested and > > all settings are in one place now. > > In that case, it's probably just an oversight. Yes, I think that's what's going on. There's been quite a bit of simplification and unification of the Django configuration over time, which is ongoing and not 100% reflected in all documentation. Because of the way most Linux distros work (and I think it's probably true for *BSD and other POSIX systems), it makes sense to put users' site configurations in /etc. I don't see a particular reason why with the current relatively small set of config files we'd want to put HyperKitty or Postorius files elsewhere than /etc/mailman3 (although it might make sense to have more separation given the existence of EMWD's Affinity etc). Steve

3 years

[MM3-users] Re: hyperkitty threads by month question

by Bryan Fields

On 7/26/24 11:19 PM, Mark Sapiro wrote: > On 7/26/24 18:53, Bryan Fields wrote: >> On 7/26/24 4:01 PM, Mark Sapiro wrote: >> >>> If this returns just the one message_id, I would then >>> >>> DELETE FROM hyperkitty_thread WHERE id = 35670; >>> DELETE FROM hyperkitty_email WHERE id = 150555; >> >> It's giving an error due to a fk constraint on another table. I'm not >> familiar with the db structure enough to be certain how to clean/fix it. > > Yes, you need to do these first. > > DELETE FROM hyperkitty_favorite WHERE thread_id = 35670; > DELETE FROM hyperkitty_tagging WHERE thread_id = 35670; > DELETE FROM hyperkitty_lastview WHERE thread_id = 35670; > DELETE FROM hyperkitty_vote WHERE email_id = 150555; > > Not all those will exist, but then you should be able to > > DELETE FROM hyperkitty_thread WHERE id = 35670; > DELETE FROM hyperkitty_email WHERE id = 150555; Sill no go on it. mailmanweb=> DELETE FROM hyperkitty_favorite WHERE thread_id = 35670; DELETE 0 mailmanweb=> DELETE FROM hyperkitty_tagging WHERE thread_id = 35670; DELETE 0 mailmanweb=> DELETE FROM hyperkitty_lastview WHERE thread_id = 35670; DELETE 0 mailmanweb=> DELETE FROM hyperkitty_vote WHERE email_id = 150555; DELETE 0 mailmanweb=> DELETE FROM hyperkitty_thread WHERE id = 35670; ERROR: update or delete on table "hyperkitty_thread" violates foreign key constraint "hyperkitty_email_thread_id_038c9aee_fk_hyperkitty_thread_id" on table "hyperkitty_email" DETAIL: Key (id)=(35670) is still referenced from table "hyperkitty_email". mailmanweb=> DELETE FROM hyperkitty_email WHERE id = 150555; ERROR: update or delete on table "hyperkitty_email" violates foreign key constraint "hyperkitty_thread_starting_email_id_fa7c55f5_fk_hyperkitt" on table "hyperkitty_thread" DETAIL: Key (id)=(150555) is still referenced from table "hyperkitty_thread". >> I'm actually thinking I need to fix the archive mbox, then delete them and >> re-import them once they are cleaned. > > > Actually, that would be safest. Fix the mbox, delete the entire archive > and re-run the import. I'll attempt to clean this up tomorrow an clean it up/re-import. Is there a quick/easy way to drop the entire archive from the db or must I delete the entire list? >>> Also, FYI, assuming those messages with very old Date: headers had >>> reasonable unix from dates, the hyperkitty/contrib/cleanarch3 script >>> would fix them, except you have to get the script from >>> https://gitlab.com/mailman/hyperkitty/-/blob/master/hyperkitty/contrib/clea… >>> or https://www.msapiro.net/scripts/cleanarch3 because the script in the >>> latest release has a bug. >> >> I tried the dry run option on your script and it gave a bunch of output >> for bad >> dates. This was absent on the one shipping with the source. What's >> interesting >> is that pipermail seems to have no issue with this, detecting the date >> correctly. > > If I recall correctly, pipermail checks date skew and 'fixes' the dates > in the archive, but they remain off in the mbox. I'll have to check that, but I've got at least some good leads now and tools to find suspected issues. It does seem like a bad design that importing a mailman2 mbox can cause the server to error 500. >> Is the archive tool in pipermail's import more robust in this manner? >> I'd argue >> it's common to have missing In-Reply-To: headers where the subject and time >> would need to be used to infer the likely thread. I'll agree this is a >> major >> violation of the relevant RFC's to be missing this, but many MUA's (M$) are >> famous for doing just this. > > > Yes, it's arguably a defect in HyperKitty to not implement Jamie > Zawinski's threading algorithm <https://www.jwz.org/doc/threading.html>, > but it doesn't. Well that kinda blows :-( I'm not going to take down the old archives, but I'd like at least one to be searchable, which is why we wanted to use mailman3/hyperkitty. Thank you, -- Bryan Fields 727-409-1194 - Voice http://bryanfields.net

1 year, 4 months

[MM3-users] Re: Moving from forum to Mailman 3

by Stephen J. Turnbull

Mark Sapiro writes: > On 10/9/20 4:39 PM, jonathan.mailing.lists(a)gmail.com wrote: > > > > Thanks for this. I’m sure I could turn that basic information > > (from, date, subject) into an mbox file somehow. What else does > > Mailman need, eg to work out which messages are in reply to > > which? > > To properly thread messages, each message should have a unique > Message-ID: header and all replies should have an In-Reply-To: header > with the Massage-ID: of the message to which it's a reply. [example thread omitted] > The angle brackets around the strings are required and every Message-ID: > in the entire archive for a list must be unique. This is harder to do well (or even "well enough") than you might think. I recommend using some software targeting RFC 4122: https://tools.ietf.org/html/rfc4122. RFC 4122 is implemented in the Python standard library (the uuid module), so if you have Mailman, you have it. The command line utility uuidgen is also good, and you probably have that too if you prefer CLI scripting to Python. Steve

5 years, 2 months

[MM3-users] Re: installation

by Brian Carpenter

On 11/22/20 6:54 PM, Henry S wrote: > > Now I am trying to figure out how to configure mailman+postfix to pass > the unnecessarily convoluted world of spam-free certification and ip > blockings by those 'security lawmakers'. > > Any suggestions on how to not be blocked by gmail, hotmail, etc? I > have used DKIM (no signing yet), SPF, DMARC to no avail. Maybe not an > appropriate question to this mailman list. Mark Sapiro provided some very good suggestions. Is this a new IP address or one that has been used for mail traffic for a white? The only way Gmail and Hotmail will block an IP address is if you have some major outgoing spamming problems or in the case of a new IP address, the IP address has a sordid history which will be reveal if you do a RBL check on it. Gmail likes SPF records and MTA's that utilizes SSL for outbound mail. For Hotmail deliveries, you will want to signed up for Microsoft's Smart Network Data Service (SNDS) program which I find very good. Also sign up for their JMRP program for your IP address. -- Brian Carpenter Harmonylists.com Emwd.com

5 years

[MM3-users] Re: Hyperkitty

by Onyeibo

Hi Mark, On Mon, 30 Jan 2023 12:24:24 -0800 Mark Sapiro <mark(a)msapiro.net> wrote: > On 1/30/23 11:58, Onyeibo wrote: > >> 2. Your MM3 log files - do they say anything? > >> > > Nothing! No new errors. It is very strange and frustrating > > > Are there files in /opt/mailman/mm/var/archives/hyperkitty/spool/? > YES! A lot of them > Do messages received from the list have an Archived-At: header:? > No > Do messages received from the list have a List-Archive: header:? > No > If the first answer is yes, the mailman_hyperkitty archive_message > method is failing. > > If the second answer is no, the mailman_hyperkitty permalink method > is failing. > > If the second answer is no, the mailman_hyperkitty list_url method is > failing. > That means they are all failing. Wow > All of these failures log errors to the mailman.archiver log which by > default is written to mailman.log. The log doesn't have entries pointing to failures above > > If by chance there is an Archived-At: header, what is it? > The mails don't have that header. I suspect I may have to investigate SELinux.

2 years, 10 months

[MM3-users] Re: lists.mailman3.org web site.

by Barry Warsaw

On Aug 30, 2016, at 12:01 AM, Mark Sapiro wrote: >Django Allauth is now properly configured and working on >lists.mailman3.org. You can log in by email/password as noted above or via >OAuth2 with a GitHub, GitLab, Google or Facebook identity. > >If you are an existing user, in order to use one of the OAuth2 providers, you >must first log in with email and password and go to the Account Connections >tab in your account settings and add the 3rd party account(s) you wish. This works pretty great. I tried it with my GitHub and GitLab accounts and was easily able to associate those with my Postorius and HK accounts. I didn't try FB or Google, but I guess those would work the same way. I'll miss Persona but I think this is an entirely acceptable alternative, with plenty of choice for folks wanting to control which authority they delegate to. I'd mildly like to see Launchpad support, but I understand 1) it's a minority platform; 2) it only supports OAuth 1. Thanks to the developers for adding this support and to Mark for enabling it. Cheers, -Barry

9 years, 3 months

[MM3-users] Re: no mails to list members

by Thomas Stein

Thanks for the clarification Mark. cheers t. On Friday, 4 January 2019 19:25:20 CET Mark Sapiro wrote: > On 1/4/19 6:49 AM, Thomas Stein wrote: > > > > While we`re at it. Is /var/lib/mailman3/templates/lists/$listname the right location for customized templates? > > > There are multiple ways to reference templates, but just putting them in > that location should work. > > > > Should > > I name the template list:member:generic:footer.txt or list_member_generic_footer.txt? > > > Your list was created with an older version of import21. That version > named the templates it stored with underscores rather than colons and > set the URI for that template to use the underscore name. Thus, without > changing the URI for the template, you need to continue to use the > underscore name for those templates, but for other templates, you can > use the name with colons and not worry about the URI. > > > > Is there some documentation > > what variables i can put in those templates? > > > See > <https://mailman.readthedocs.io/en/latest/src/mailman/rest/docs/templates.ht…>. > >

6 years, 11 months

[MM3-users] Re: Module Not Found Error after update

by Abhilash Raj

On Thu, Feb 4, 2021, at 8:52 AM, Brian Carpenter wrote: > > On 2/4/21 11:46 AM, Mark Sapiro wrote: > > You need django-mailman3 1.3.5 > > > > > > While all are not required in this case, when you upgrade like this with > > pip, you should upgrade all of django-mailman3, hyperkitty, mailman, > > mailmanclient, mailman-hyperkitty and postorius. > > Thanks Mark. Perhaps Abhilash can include that in the instructions on > the following page for future releases: > > https://lists.mailman3.org/archives/list/mailman-users@mailman3.org/thread/… I was hoping pip would actually upgrade django-mailman3 given that P requires ‘django-mailman3>=1.3.5’ [1] but looks like it didn’t :( [1]: https://gitlab.com/mailman/postorius/-/blob/master/setup.py#L56 > I will make a note of this in my own personal documentation and the > Debian 10 How-to guide that I am currently working on. > > -- > 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/ > -- thanks, Abhilash Raj (maxking)

4 years, 10 months

[MM3-users] Re: Moderate mails from owner

by Henrik Rasmussen

Mark Sapiro wrote: > This can happen in a few ways., If this list was originally imported > from Mailman 2.1 by the 'mailman import21' command, there may be a > legacy accept_these_nonmembers attribute for the list. If so, and if a This makes sense. The list was in fact imported from Mailman 2.1. > You need to check the list's accept_these_nonmembers attribute and the > non-member address's moderation action. > > If you have recent Postorius, you can see nonmembers and their options > from the 'users' -> Non-members view. I currently have Postorius 1.2.2 so I don't have it yet. > mailman shell -l list.example.com The sender is in the list of accept_these_nonmembers, however the command memb.moderation_action = m.default_nonmember_action doesn't seem to remove it from accept_these_nonmembers. bash-4.3# mailman shell -l [LISTNAME].lists.example.com Welcome to the GNU Mailman shell The variable 'm' is the [LISTNAME].lists.example.com mailing list >>> m.accept_these_nonmembers ['listadmin(a)senderdep.example.com'] >>> memb = m.nonmembers.get_member('listadmin(a)senderdep.example.com') >>> memb.moderation_action <Action.accept: 3> >>> memb.moderation_action = m.default_nonmember_action >>> m.accept_these_nonmembers ['listadmin(a)senderdep.example.com'] -- Henrik

6 years, 7 months

Search results for query "sapiro"