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

[MM3-users] Re: per domain SITE_ID views?

by David Newman

On 12/28/21 1:30 PM, Mark Sapiro wrote: > On 12/28/21 1:14 PM, David Newman wrote: >> Using FILTER_VHOST, I have two domains set up and working with MM3, >> Postorius and Hyperkitty. However, because SITE_ID in settings.py >> points to one of the domains, that domain name always appears on >> Postorius and Hyperkitty pages. > ... >> How to get the correct domain to appear on that domain's Postorius and >> Hyperkitty pages? > > > I don't think the domain is actually displayed on Postorius pages. You are almost certainly correct. I saw dom1.tld on a login page, but hadn't realized that login page comes from Hyperkitty and not Postorious. > If > I'm wrong, on what Postorius view do you see it? As far as HyperKitty is > concerned, please file an issue for this at > https://gitlab.com/mailman/hyperkitty/-/issues/new Opened an issue here: https://gitlab.com/mailman/hyperkitty/-/issues/404 dn

4 years, 9 months

[MM3-users] Re: FYI: Django security releases issued: 4.0.6 and 3.2.14

by David Newman

On 7/7/22 3:02 PM, Mark Sapiro wrote: > On 7/7/22 1:36 PM, David Newman wrote: >> >> That was my first thought too. But there's nothing in that directory >> beginning with a hyphen, not even with the -a switch. > > What about > ``` > ls -la /opt/mailman/venv/lib/python3.9/site-packages/*-jango* > ``` > and if that shows nothing, > ``` > grep -r '-jango' /opt/mailman/venv/lib/python3.9/site-packages/ Nothing from the first command. The second command thinks '-j' is grep switch, and throws an invalid-option error: root@somehost:/opt/mailman/venv/lib/python3.9/site-packages# grep -r '-jango' /opt/mailman/venv/lib/python3.9/site-packages/ grep: invalid option -- 'j' Usage: grep [OPTION]... PATTERNS [FILE]... I *think* the command runs if I escape the hyphen: root@somehost:/opt/mailman/venv/lib/python3.9/site-packages# grep -r '\-jango' /opt/mailman/venv/lib/python3.9/site-packages/ But then that doesn't return anything. dn

4 years, 3 months

[MM3-users] Re: how to unhold a hold message from a nonmmeber in hold list.

by Guillermo Hernandez (Oldno7)

El 21/4/23 a las 14:29, Mark Sapiro escribió: > On 4/21/23 1:19 AM, Guillermo Hernandez (Oldno7) via Mailman-users wrote: >> I'm having troubles with Django and cannot access to web admin. >> >> I need to unhold a message while figures out what is happening. >> >> Searching the mailman cli help commands didn't help me. >> >> Anyone who knows how to unhold a message, please? > > > See this post > https://lists.mailman3.org/archives/list/mailman-users@mailman3.org/message… > Thanks, Mark. That could have been a life saver if I hadn't reset the UI. I'm writing it down for a future need. -- ___________________________________________ Mailman's content filtering has removed the following MIME parts from this message. Content-Type: image/png Name: firma-GHP-emails.png Replaced multipart/alternative part with first alternative.

3 years, 5 months

[MM3-users] Re: Template URI gets written incorrectly

by Mark Dale

On 2023-05-24 10:11, Mark Sapiro wrote: > On 5/23/23 16:51, Mark Dale via Mailman-users wrote: >> >> When I create a template, it writes the URI incorrectly into the template table in the mailman3 database and the list stops working. >> >> For example, it writes: >> >> http://localhost/mailman3/postorius/api/templates/list/markslist.lists.post… >> >> When I correct it like so, all is well: >> >> https://lists.postmark.io/mailman3/postorius/api/templates/list/markslist.l… >> >> Have I missed a config setting somewhere, or is this a bug with the older Debian Mailman 3.3.3 ? > > > You need to set > > POSTORIUS_TEMPLATE_BASE_URL = 'https://lists.postmark.io/' > > in your Django settings. Debian probably has set it to 'http://localhost/'. > Indeed that was it! Thanks very much Mark. /etc/mailman3/mailman-web.py Line 190: POSTORIUS_TEMPLATE_BASE_URL = 'https://lists.postmark.io/'

3 years, 4 months

[MM3-users] Re: Migrating mailman3 to latest ubuntu lts

by Helio Loureiro

Hi, I looked to the version I in the old installation: mysql> select * from alembic_version; +--------------+ | version_num | +--------------+ | 4bd95c99b2e7 | +--------------+ 1 row in set (0.00 sec) I set the same version on the new. Actually I loaded a fresh dump from DB to be sure it was the same. And now it is starting without errors. I guess that was it. Thanks a lot! Best Regards, Helio Loureiro https://helio.loureiro.eng.br https://github.com/helioloureiro https://mastodon.social/@helioloureiro On Thu, 14 Dec 2023 at 18:47, Mark Sapiro <mark(a)msapiro.net> wrote: > On 12/14/23 01:48, Helio Loureiro wrote: > > > > > But it is failing to start displaying the domain name from the previous > > machine. > > > > (venv) mailman@new-server ~ (v3.3.9)> mailman start > > Starting Mailman's master runner > > Generating MTA alias maps > > Traceback (most recent call last): > > File > > > "/local/mailman/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", > > line 1969, in _exec_single_context > > self.dialect.do_execute( > > File > > > "/local/mailman/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", > > line 922, in do_execute > > cursor.execute(statement, parameters) > > File > > "/local/mailman/venv/lib/python3.10/site-packages/pymysql/cursors.py", > line > > 153, in execute > > result = self._query(query) > > File > > "/local/mailman/venv/lib/python3.10/site-packages/pymysql/cursors.py", > line > > 322, in _query > > conn.query(q) > > File > > > "/local/mailman/venv/lib/python3.10/site-packages/pymysql/connections.py", > > line 558, in query > > self._affected_rows = self._read_query_result(unbuffered=unbuffered) > > File > > > "/local/mailman/venv/lib/python3.10/site-packages/pymysql/connections.py", > > line 822, in _read_query_result > > result.read() > > File > > > "/local/mailman/venv/lib/python3.10/site-packages/pymysql/connections.py", > > line 1200, in read > > first_packet = self.connection._read_packet() > > File > > > "/local/mailman/venv/lib/python3.10/site-packages/pymysql/connections.py", > > line 772, in _read_packet > > packet.raise_for_error() > > File > > "/local/mailman/venv/lib/python3.10/site-packages/pymysql/protocol.py", > > line 221, in raise_for_error > > err.raise_mysql_exception(self._data) > > File > "/local/mailman/venv/lib/python3.10/site-packages/pymysql/err.py", > > line 143, in raise_mysql_exception > > raise errorclass(errno, errval) > > pymysql.err.OperationalError: (1054, "Unknown column > 'domain.alias_domain' > > in 'field list'") > > > The issue is your domains table and possibly others are not up to the > current schema. This should be accomplished by Mailman core running all > the necessary migrations in mailman/database/alembic/versions/. For some > reason, alembic's MigrationContext thinks the migrations have been run, > but they haven't. In the `mailman` database, the alembic_version table > has the version_num of the putative current version. The migration that > added alias_domain is dfe82cf73702_add_alias_domain.py. If there is no > alias_domain column in the domain table, alembic_version.version_num > should be a version older than 'dfe82cf73702'. > > I suggest querying the prior mailman database for the > alembic_version.version_num value and setting that in the current > database, assuming that that migration exists in > mailman/database/alembic/versions/. > > This may be sufficient, but there may be other inconsistencies depending > on exactly what you did. > > -- > 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/ > Archived at: > https://lists.mailman3.org/archives/list/mailman-users@mailman3.org/message… > > This message sent to helio(a)loureiro.eng.br >

2 years, 10 months

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

by William Oliver

On Sat, 2021-12-25 at 10:19 -0800, Mark Sapiro wrote: > On 12/25/21 7:13 AM, William Oliver wrote: > > > > 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? > > > If Postorius is working, recent versions show the SITE_ID in the > domains > view. I.e. after you added your domain you could have noted the > SITE_ID > and made the change in settings before deleting the example.com > domain. > > In any case, the django_site table in Mailman's database has the > information. > Thanks. Yep, I peeked at the database and there it was. That would probably been more efficient than randomly choosing numbers... billo

4 years, 9 months

[MM3-users] Re: how to unhold a hold message from a nonmmeber in hold list.

by Odhiambo Washington

On Fri, Apr 21, 2023 at 11:20 AM Guillermo Hernandez (Oldno7) via Mailman-users <mailman-users(a)mailman3.org> wrote: > I'm having troubles with Django and cannot access to web admin. > > I need to unhold a message while figures out what is happening. > > Searching the mailman cli help commands didn't help me. > > Anyone who knows how to unhold a message, please? > TBH, I find it a lot easier to fix the web UI than mess with the python shell :-) While you wait for @Mark Sapiro <mark(a)msapiro.net> to save you, you can be reading the following: https://docs.mailman3.org/projects/mailmanclient/en/latest/src/mailmanclien… -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]

3 years, 5 months

[MM3-users] Re: Hyperkitty on Debian 12

by Markus Grandpré

short addendum: I was able to correct the following warnings when performing database operations on the mailman-web database: 1) /usr/lib/python3/dist-packages/django_q/conf.py:139: UserWarning: Retry and timeout are misconfigured. Set retry larger than timeout, failure to do so will cause the tasks to be retriggered before completion. See https://django-q.readthedocs.io/en/latest/configure.html#retry for details. 2) django_mailman3.MailDomain: (models.W042) Auto-created primary key used when not defining a primary key type, by default 'django.db.models.AutoField'. HINT: Configure the DEFAULT_AUTO_FIELD setting or the DjangoMailman3Config.default_auto_field attribute to point to a subclass of AutoField, e.g. 'django.db.models.BigAutoField'. on our Debian 12 system in file </etc/mailman/mailman-web.cfg>: 1) Q_CLUSTER = { 'orm': 'default', 'retry': 360, 'save_limit': 100, 'timeout': 300, 'worker': 2 } 2) DEFAULT_AUTO_FIELD = 'django.db.models.BigAutoField' Best Markus Am 26.03.24 um 08:06 schrieb Markus Grandpré: > Dear Mr Sapiro, > > thank you very much for your help. The required command is: > > # mailman-web hyperkitty_import \ > -l mailman21-migration-test-04(a)mailman.uni-konstanz.de \ > /var/mailman21/testlist.mbox > > Due to the following warnings, I still have to customize Hyperkitty: > > django_mailman3.MailDomain: (models.W042) Auto-created primary key used > when not defining a primary key type, by default > 'django.db.models.AutoField'. > HINT: Configure the DEFAULT_AUTO_FIELD setting or the > DjangoMailman3Config.default_auto_field attribute to point to a subclass > of AutoField, e.g. 'django.db.models.BigAutoField'. > ... > > Can you give me another hint? As Linux admin I installed the packages > mailman and mailman-web that were offered to me under Debian 12. > Although during the installation of the packages user "list" was > created, I cannot use it: > > # su - list > This account is currently not available > > As with Mailman 2.1, I will probably have to continue working with > Mailman3 as root. Too bad that there is no documentation for Debian > admins like me, who don't want to dive too deep into the python > framework. Or have I overlooked something? > > Best regards, > Markus > > > > Am 25.03.24 um 18:56 schrieb Mark Sapiro: >> On 3/25/24 07:58, Markus Grandpre wrote: >>> Dear list members, >>> >>> when following the instructions to migrate list archives from >>> Mailman21 to Mailman3 (see [1]), I face the following problem: >>> >>> # python3 manage.py hyperkitty_import -l mailman21-migration-test-04 >>> /var/mailman21/testlist.mbox >>> python3: can't open file '/var/mailman21/manage.py': [Errno 2] No >>> such file or directory >>> >>> and have no clue, where to find the right <manage.py> file. The command >> >> >> This depends on how you installed Mailman 3. You may or may not want >> `python3 manage.py` at all. The required command could be something >> like `django-admin` or `mailman-web`. >> >> Also the `#` prompt indicates you may be running as root. Mailman >> related commands should be run as the Mailman user (could be `mailman` >> or `list` or ... depending again on how you installed Mailman). >> Running as root can create files owned by root that later can't be >> read by the Mailman user. >> > > > _______________________________________________ > 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 markus.grandpre(a)uni-konstanz.de -- Markus Ludwig Grandpré Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung IT-Dienste Forschung und Lehre, B803, Tel: ++49 7531 88 4342

2 years, 6 months

[MM3-users] Re: Permissions issue after upgrade of virtualenv

by Odhiambo Washington

On Thu, Mar 9, 2023 at 10:41 PM Mark Sapiro <mark(a)msapiro.net> wrote: > On 3/9/23 11:25, Odhiambo Washington wrote: > > > > Thu Mar 09 22:17:59.313459 2023] [core:error] [pid 15655] (13)Permission > > denied: [client 197.232.xx.xx:26574] AH00035: access to / denied > > (filesystem path '/opt/mailman/mm') because search permissions are > missing > > on a component of the path, referer: https://mm3-lists.kictanet.or.ke/ > > I did not change Apache config and I made sure that /opt/mailman is all > > owned by mailman:mailman. > > > > What am I missing? > > > X permission on one or more of /opt, /opt/mailman, /opt/mailman/mm > Wow. That would have taken me a decade to spot! The X permissions were missing on /opt/mailman. Thank you very much. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)

3 years, 7 months

[MM3-users] Re: postfix malformed address with confirm replies

by Stephen Willey Mats Mats

> On Feb 26, 2021, at 16:08:35 PST, Mark Sapiro <mark(a)msapiro.net> wrote: > > >>> The mail system >>> >>> <matsmats-mm3-test1-confirm+d6f77a2572ef55a8b2c4ca0d77de8493fbb55856(a)mm3.aca-aws.s.uw.edu>: >>> host 172.19.199.2[172.19.199.2] said: 553 5.1.3 Error: malformed address >>> (in reply to RCPT TO command) >>> Reporting-MTA: dns; ip-172-31-18-222.us-west-2.compute.internal >>> X-Postfix-Queue-ID: E144B8BC3C5 >>> X-Postfix-Sender: rfc822; stephen.s.w.matsmats(a)gmail.com >>> Arrival-Date: Fri, 26 Feb 2021 14:08:54 -0800 (PST) >>> >>> Final-Recipient: rfc822; matsmats-mm3-test1-confirm+d6f77a2572ef55a8b2c4ca0d77de8493fbb55856(a)mm3.aca-aws.s.uw.edu >>> Original-Recipient: rfc822;matsmats-mm3-test1-confirm+d6f77a2572ef55a8b2c4ca0d77de8493fbb55856(a)mm3.aca-aws.s.uw.edu >>> Action: failed >>> Status: 5.1.3 >>> Remote-MTA: dns; 172.19.199.2 >>> Diagnostic-Code: smtp; 553 5.1.3 Error: malformed address > > I have no idea why Postfix is saying > `matsmats-mm3-test1-confirm+d6f77a2572ef55a8b2c4ca0d77de8493fbb55856(a)mm3.aca-aws.s.uw.edu` > is a malformed address, but this is a Postfix issue, not Mailman. > > Can you successfully post to `matsmats-mm3-test1 > @mm3.aca-aws.s.uw.edu` how about a `help` command to > `matsmats-mm3-test1-request(a)mm3.aca-aws.s.uw.edu` > Yep, all day long. A ‘help’ command succeeded. As did sending the confirm command to the -request address. oh, and looking further at the postfix logs the message was accepted by postfix but the error pops-up when postfix tries to pass it on. Feb 26 14:08:54 ip-172-31-18-222 postfix/smtpd[5933]: connect from mail-pj1-f50.google.com[209.85.216.50] Feb 26 14:08:54 ip-172-31-18-222 postfix/smtpd[5933]: E144B8BC3C5: client=mail-pj1-f50.google.com[209.85.216.50] Feb 26 14:08:54 ip-172-31-18-222 postfix/cleanup[5966]: E144B8BC3C5: message-id=<9B650420-A50D-4E25-8B5B-C696C388B7DA(a)selby.com> Feb 26 14:08:54 ip-172-31-18-222 postfix/qmgr[3214]: E144B8BC3C5: from=<stephen.s.w.matsmats(a)gmail.com>, size=4575, nrcpt=1 (queue active) Feb 26 14:08:54 ip-172-31-18-222 postfix/smtpd[5933]: disconnect from mail-pj1-f50.google.com[209.85.216.50] Feb 26 14:08:54 ip-172-31-18-222 postfix/lmtp[5967]: E144B8BC3C5: to=<matsmats-mm3-test1-confirm+d6f77a2572ef55a8b2c4ca0d77de8493fbb55856(a)mm3.aca-aws.s.uw.edu>, relay=172.19.199.2[172.19.199.2]:8024, delay=0.08, delays=0.05/0.01/0/0.01, dsn=5.1.3, status=bounced (host 172.19.199.2[172.19.199.2] said: 553 5.1.3 Error: malformed address (in reply to RCPT TO command)) Feb 26 14:08:54 ip-172-31-18-222 postfix/cleanup[5966]: F0C468BC3C6: message-id=<20210226220854.F0C468BC3C6(a)ip-172-31-18-222.us-west-2.compute.internal> Feb 26 14:08:54 ip-172-31-18-222 postfix/qmgr[3214]: F0C468BC3C6: from=<>, size=6993, nrcpt=1 (queue active) Feb 26 14:08:54 ip-172-31-18-222 postfix/bounce[5968]: E144B8BC3C5: sender non-delivery notification: F0C468BC3C6 Feb 26 14:08:54 ip-172-31-18-222 postfix/qmgr[3214]: E144B8BC3C5: removed The mailman smtp.log show that the message came in but not much else. the mailman.log (and bounce.log) don’t show anything for that time. Feb 26 22:08:54 2021 (27) Available AUTH mechanisms: LOGIN(builtin) PLAIN(builtin) Feb 26 22:08:54 2021 (27) Peer: ('172.19.199.1', 51934) Feb 26 22:08:54 2021 (27) ('172.19.199.1', 51934) handling connection Feb 26 22:08:54 2021 (27) ('172.19.199.1', 51934) >> b'LHLO ip-172-31-18-222.us-west-2.compute.internal' Feb 26 22:08:54 2021 (27) ('172.19.199.1', 51934) >> b'MAIL FROM:<stephen.s.w.matsmats(a)gmail.com> SIZE=4575' Feb 26 22:08:54 2021 (27) ('172.19.199.1', 51934) sender: stephen.s.w.matsmats(a)gmail.com Feb 26 22:08:54 2021 (27) ('172.19.199.1', 51934) >> b'RCPT TO:<matsmats-mm3-test1-confirm+d6f77a2572ef55a8b2c4ca0d77de8493fbb55856(a)mm3.aca-aws.s.uw.edu>' Feb 26 22:08:54 2021 (27) ('172.19.199.1', 51934) >> b'RSET' Feb 26 22:08:54 2021 (27) ('172.19.199.1', 51934) >> b'QUIT' Feb 26 22:08:54 2021 (27) ('172.19.199.1', 51934) connection lost Feb 26 22:08:54 2021 (27) ('172.19.199.1', 51934) Connection lost during _handle_client() I’ve also reproduced this another address that is on an exchange server which is maybe a more vanilla example. steve > -- > 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/

5 years, 7 months

Search results for query "sapiro"