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

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

by Mark Sapiro

On 9/23/23 17:51, Mark wrote: > > For example, on searching for the word "Derbyshire" (which is mentioned > in one of the archived messages) the results page displays: > > "Sorry no email could be found for this query." > > The logs show: > > +++++++++++++++++++++++++++++++++++++ > /var/log/mailman3/web/mailman-web.log > +++++++++++++++++++++++++++++++++++++ > > [pid: 1156|app: 0|req: 55/55] 2001:8004:5310:2405:ce66:5ff:41fc:60db () > {76 vars in 1537 bytes} [Sat Sep 23 23:57:43 2023] GET > /mailman3/hyperkitty/search?mlist=LISTNAME-1%40DOMAIN.COM&q=Derbyshire > => generated 13752 bytes in 3188 msecs (HTTP/1.1 200) 5 headers in 164 > bytes (1 switches on core 0) ... > mlist = MailingList.objects.get(name=mlist_name) > File "/usr/lib/python3/dist-packages/django/db/models/manager.py", > line 82, in manager_method > return getattr(self.get_queryset(), name)(*args, **kwargs) > File "/usr/lib/python3/dist-packages/django/db/models/query.py", line > 406, in get > raise self.model.DoesNotExist( > hyperkitty.models.mailinglist.MailingList.DoesNotExist: MailingList > matching query does not exist. What does this database query return ``` select * from hyperkitty_mailinglist where name like 'LISTNAME-1(a)DOMAIN.COM'; ``` If it returns a row, does case match for the name in the row and the query? -- Mark Sapiro <mark(a)msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan

2 years, 9 months

[MM3-users] Re: mailman-web migrate fails with sqlite3.IntegrityError: UNIQUE constraint failed: account_emailaddress.email

by Mark Sapiro

On 3/14/25 3:55 AM, Stefan Bauer via Mailman-users wrote: > Dear Mark, > > thank you for your time. > > After patching your script according to > https://github.com/maxking/docker-mailman/issues/729#issuecomment-2447542238 > > It fails with > > /opt/mailman/venv/data# /usr/local/bin/UC_fix > /opt/mailman/venv/data/mailman3web.db > Traceback (most recent call last): > File "/usr/local/bin/UC_fix", line 77, in <module> > c.execute("delete from account_emailaddress where email = %s;", > sqlite3.OperationalError: near "%": syntax error That patch still assumes the database is PostgreSQL. You need to replace ``` import psycopg2 ``` with ``` import sqlite3 ``` and ``` db = psycopg2.connect(...) ``` with ``` db = sqlite3.connect(...) ``` but it appears you've done that. It appears that the sqlite3 module doesn't accept the '... %s', value' syntax. See https://docs.python.org/3/library/sqlite3.html You need to change things like ``` c.execute("""update account_emailaddress set "primary" = 't' where email = %s;""", [em1]) ``` to ``` c.execute("""update account_emailaddress set "primary" = 't' where email = %s;""" % em1) ``` -- Mark Sapiro <mark(a)msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan

1 year, 3 months

[MM3-users] Re: How to get rid of footer (Mailman3)

by Mark Sapiro

On 2/11/20 11:31 PM, tarmokumar(a)gmail.com wrote: > Hi, I have read multiple posts in this forum that you should be able to get rid of the footer completely but I am unable to. > I have tried: > - adding the footer template to a list and not adding any "Data" to it. Result was a attachment with some "dfgdfgdfgdfg" text in it. Did you add this via Postorius. If so, it would seem to be a Postorius issue. > - adding/creating a blank "list:member:generic:footer" document to /var/templates/site/en, var/templates/lists/LIST.ID/en/ and var/templates/domains/DOMAIN/en/. Result is that the sent e-mail still has the original unsubscribe text in the footer (as an attachment) Did you name the file list:member:generic:footer.txt (with the .txt extension)? Putting a zero-length file of that name in any of those places should work. > - removing all the files from /mailman/src/mailman/templates/en, still no change If you restarted Mailman after doing this, this indicates something (Postorius?) may have set a URI for this template. What do you get from curl -urestadmin:restpass \ http://localhost:8001/3.1/lists/LIST.ID/uris -- Mark Sapiro <mark(a)msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan

6 years, 4 months

[MM3-users] Re: hyperkitty installation: Unclear instructions

by Mark Sapiro

On 1/5/23 15:00, Johannes Rohr wrote: > Dear all, > > I just installed mailman and mailman3-web in virtualenv as described in > https://docs.mailman3.org/en/latest/install/virtualenv.html > > Next I moved on to set up hyperkitty as described in > https://docs.mailman3.org/projects/hyperkitty/en/latest/install.html. I > got confused by the instructions: You are confused because you are mixing incompatible ways of installation. Installing mailman-web per https://docs.mailman3.org/en/latest/install/virtualenv.html#installing-web-… installs both HyperKitty an Postorius as dependencies of mailman-web. > But then, hyperkitty seems to be already have been pulled in by > mailman-web, looking at its dependencies. Yes. > If that's the case, then neither the instructions at > https://docs.mailman3.org/projects/hyperkitty/en/latest/install.html nor > those at > https://docs.mailman3.org/projects/hyperkitty/en/latest/development.html > are correct. They are correct, but they are for different methods of installation. > Can someone enlighten me on what the canonical way is of installing and > setting it up in virtualenv? Just follow the instructions at <https://docs.mailman3.org/en/latest/install/virtualenv.html>. They are the current recommendation and will result in a complete installation. -- Mark Sapiro <mark(a)msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan

3 years, 5 months

[MM3-users] Re: mass remove pending confirmation

by Mark Sapiro

On 5/22/23 13:46, Jens Günther wrote: > > Since we migrate some lists from mailman2 to 3, there are a lot of new > users/subscribers and an admin made the mistake to not checkbox the 3. > option that the users don't need to verify their address. Are these newly added users since the migration? If you migrate a list with the `mailman import21` the users of the MM 2.1 list will be imported and there won't be confirmations. > Now we have a long list of pending confirmations in different lists. Is > there an easy way in the shell to mass remove these pending > mailaddresses so that we don't have to do that one by one? That would be > awsome. Do you want to remove them or confirm them. If you just remove them, the user's addresses will still be unconfirmed. If you just want to remove them so you can redo the mass subscribes, you could do something like the following in `mailman shell` ``` >>> pendings = getUtility(IPendings) >>> for token, data in pendings.find( token_owner=TokenOwner.subscriber, pend_type='subscription'): ... pendings.confirm(token, expunge=True) ... >>> commit() ``` -- Mark Sapiro <mark(a)msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan

3 years, 1 month

[MM3-users] Re: Setting base_url for the domain to use it in the templates.

by Mark Sapiro

On 8/27/24 11:27, Ondřej Brablc via Mailman-users wrote: > The documentation at https://docs.mailman3.org/projects/mailman/en/latest/src/mailman/rest/docs/… shows that when the variable is not set it would come as `base_url: None` on GET request. > > But the my table `domain` does not even have column `base_url`. I have tried adding it `ALTER TABLE domain ADD COLUMN base_url CHARACTER VARYING;` but this did not help. The docs at https://docs.mailman3.org/ include documentation of the heads of the GitLab branches so they may contain documentation of things that are not yet released. When Mailman 3.3.10 is released and you upgrade (or when you upgrade from the head of the GitLab branch), a migration will run automatically to add the base_url column to the domain table. > So I believe this is just some WIP. Some related commits: > > - https://gitlab.com/mailman/mailman/-/commit/a80f6d32252b6cf174f836210bc2157… > - https://gitlab.com/mailman/mailman/-/commit/7c5294fe1245d927cb30c556beb2176… Yes, it is a WIP in that it hasn't yet been released as are all the changes at https://docs.mailman3.org/projects/mailman/en/latest/src/mailman/docs/NEWS.… -- Mark Sapiro <mark(a)msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan

1 year, 9 months

[MM3-users] Re: Migrating Mailman 3 lists

by Mark Sapiro

On 5/19/20 7:25 PM, Mark Dadgar wrote: > > I get a bunch of these errors because identifiers in postgres are limited to 63 characters and mm3 creates some in sqlite that are longer than that: > > 2020-05-20T02:16:20.574000Z WARNING PostgreSQL warning: identifier "idx_44731_auth_user_user_permissions_user_id_permission_id_14a6b632_uniq" will be truncated to "idx_44731_auth_user_user_permissions_user_id_permission_id_14a6" ... > > etc. > > I killed the job before it finished and have not actually tried running against this database, but my question is this: > > How does mailman3 handle this limitation with postgres if I set up an instance from scratch using postgres? Does it just truncate the identifiers identically, in which case migrating via pgloader should work? Mailman doesn't make those names. Those are names in table index entries. Mailman specifies the columns in a table which are indexed, but the DBM itself manages the index. > For reference my pgloader script looks like: > > load database > from sqlite:///var/lib/dbconfig-common/sqlite3/mailman3-web/mailman3web.db > into postgresql://mailman3:XXREDACTEDXX@localhost/mailman > > with include drop, create tables, create indexes, reset sequences, no truncate I'm not sure why this doesn't work. A brief look at the pgloader docs seems to say it should. -- Mark Sapiro <mark(a)msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan

6 years, 1 month

[MM3-users] Re: Bad Signature with Gmail

by Mark Sapiro

On 9/19/20 12:33 PM, Massimo Zappalà wrote: > Hi Mark, thanks for the reply. > > my /etc/opendkim.conf > AutoRestart Yes > AutoRestartRate 10/1h > UMask 002 > Syslog yes > SyslogSuccess Yes > LogWhy Yes > Canonicalization relaxed/simple > ExternalIgnoreList refile:/etc/opendkim/TrustedHosts > InternalHosts refile:/etc/opendkim/TrustedHosts > KeyTable refile:/etc/opendkim/KeyTable > SigningTable refile:/etc/opendkim/SigningTable > Mode sv > PidFile /var/run/opendkim/opendkim.pid > SignatureAlgorithm rsa-sha256 > UserID opendkim:opendkim > Socket inet:12301@localhost > > > my /etc/opendkim/SigningTable > *(a)catania.linux.it mailselector._domainkey.catania.linux.it Assuminng your list's domain is catania.linux.it, what you need to do to enable DKIM signing of this message is add SenderHeaders List-Post,Sender,From to /etc/opendkim.conf > full email django error > Internal Server Error: /hyperkitty/api/mailman/archive > > OperationalError at /hyperkitty/api/mailman/archive > (1366, "Incorrect string value: '\\xF0\\x9F\\x98\\xB1\\xF0\\x9F...' for column `mailman3web`.`hyperkitty_email`.`content` at row 1") Unfortunately, the rest of the detail doesn't help. What we need to see is the raw message. You should be able to find it in Mailman's var/archives/prototype/<list_address/new/ directory, perhaps by timestamp or something in the headers. -- Mark Sapiro <mark(a)msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan

5 years, 9 months

[MM3-users] Re: Re-enable member after bouce processed disable

by Mark Sapiro

On 12/9/21 6:07 AM, Henrik Rasmussen wrote: > Recently I upgraded Mailman to GNU Mailman 3.3.4 (Tom Sawyer) (Postorius: 1.3.5 and HyperKitty: 1.3.4) which is now processing bounces. > > When a member have been disabled due to bounces, how is the member re-enabled? I would guess it would be under the "Users -> Members -> Member options -> Delivery status", but theses are both (Enabled and disabled) unchecked, not indicating whether or not the member is either or. You are looking at the user's list based preferences. If one of these is unset, it falls back to address based preferences and from there to the user's global preferences. You can see all of these for yourself at the Mailman settings choice in the dropdown at your user name, but for another list member you only see the list based preferences. > How do I or the list admins re-enable a bounce-disabled member? Just set the member's delivery status on the page you see to Enabled. Even though it was not previously shown as Disabled by Bounces, it will be enabled. Likewise the member can set her Delivery status to Enabled. -- Mark Sapiro <mark(a)msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan

4 years, 6 months

[MM3-users] Re: mailing list aliases

by Mark Sapiro

On 01/19/2018 03:09 PM, Dmitry Makovey wrote: > Not sure whether to mark this "SOLVED" yet - but when I manually updated > postgres DB with the aliases I wanted - everything started to work as > expected. > > so it does sound like a bug in mailman-core 3.3.0 . Shall I file it or > was it already fixed in 3.3.1 (anouncement page didn't list that fix) As far as I know, this is not a bug in core. It is <https://gitlab.com/mailman/postorius/issues/58> however, this may in fact be a bug in the REST API in which case I don't think it's fixed in API 3.3.1 >> 2. Related to #1 - we've migrated our mailing lists from foo(a)my.com to >> foo(a)lists.my.com however we've preserved old addresses. But in new setup >> mail sent in gets stopped for moderation with: "X-Mailman-Rule-Hits: >> implicit-dest" . What's the best course of action here to get mailing >> list respond to multiple email addresses? acceptable_aliases is the way to address this, but as you note, it can't be properly set via Postorius and possibly via REST. -- Mark Sapiro <mark(a)msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan

8 years, 5 months

Search results for query "sapiro"