Обсуждение: strange message for moderation: weird list aliases??
Hi, I just got this message for moderation on the pgsql-patches list: From: pgsql-patches-postgresql.org@localhost.postgresql.org To: "pgsql-patches-postgresql.org@localhost.postgresql.org" <pgsql-patches-postgresql.org@localhost.postgresql.org> Date: Wed, 12 Dec 2007 08:40:14 -0400 (AST) Subject: Your health is your wealth.Date: s This is not hard to shot and reject on sight. The strange thing is that I also got a subsequent message for moderation which was addressed to the list, saying that this post had just been held for moderation. Huh?? So my question is this: do we have alternate addresses that receive messages for the list? Is pgsql-patches-postgresql.org@postgresql.org a valid address to which I can send a message and it will be forwarded to the pgsql-patches list? If so, I think that is a bogus configuration and should be abolished, removed, tarred, feathered, burned and banned. Unless there are good reasons for having it in place. In fact I think I've seen mail to the lists arrive as hackers@postgresql.org. Is there any reason to have them? Thanks. -- Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34J Licensee shall have no right to use the Licensed Software for productive or commercial use. (Licencia de StarOffice 6.0 beta)
On Wed, Dec 12, 2007 at 09:49:38AM -0300, Alvaro Herrera wrote: > > From: pgsql-patches-postgresql.org@localhost.postgresql.org > To: "pgsql-patches-postgresql.org@localhost.postgresql.org" This is the thing I was complaining about recently. I thought we'd agreed to drop on the floor all messages _to_ the list that appear to come _from_ the list. No?
Andrew Sullivan wrote: > On Wed, Dec 12, 2007 at 09:49:38AM -0300, Alvaro Herrera wrote: >> From: pgsql-patches-postgresql.org@localhost.postgresql.org >> To: "pgsql-patches-postgresql.org@localhost.postgresql.org" > > This is the thing I was complaining about recently. I thought we'd agreed > to drop on the floor all messages _to_ the list that appear to come _from_ > the list. No? Yes we did. Joshua D. Drake
Andrew Sullivan wrote: > On Wed, Dec 12, 2007 at 09:49:38AM -0300, Alvaro Herrera wrote: > > > > From: pgsql-patches-postgresql.org@localhost.postgresql.org > > To: "pgsql-patches-postgresql.org@localhost.postgresql.org" > > This is the thing I was complaining about recently. I thought we'd agreed > to drop on the floor all messages _to_ the list that appear to come _from_ > the list. No? Not exactly the same problem, though I absolutely agree with you. The problem I'm reporting is closely related: you will note that the username part contains an extra -postgresql.org so it's not exactly the list's "from" address. In my opinion what should have happened was that this message, instead of attempting delivery to the list, should have been dropped on the floor with a reject message of "no such user here" or some such. -- Alvaro Herrera http://www.amazon.com/gp/registry/5ZYLFMCVHXC "The Gord often wonders why people threaten never to come back after they've been told never to return" (www.actsofgord.com)
On Wed, Dec 12, 2007 at 01:43:09PM -0300, Alvaro Herrera wrote: > The problem I'm reporting is closely related: you will note that the > username part contains an extra -postgresql.org so it's not exactly the > list's "from" address. In my opinion what should have happened was that Aha. > this message, instead of attempting delivery to the list, should have > been dropped on the floor with a reject message of "no such user here" > or some such. Right. That's the other problem we were talking about in the same context. I think it was Magnus who thought he had a solution for that. A
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 - --On Wednesday, December 12, 2007 11:40:00 -0500 Andrew Sullivan <ajs@crankycanuck.ca> wrote: > On Wed, Dec 12, 2007 at 09:49:38AM -0300, Alvaro Herrera wrote: >> >> From: pgsql-patches-postgresql.org@localhost.postgresql.org >> To: "pgsql-patches-postgresql.org@localhost.postgresql.org" > > This is the thing I was complaining about recently. I thought we'd agreed > to drop on the floor all messages _to_ the list that appear to come _from_ > the list. No? The above would never have matched anyway,as there is no list called pgsql-patches-postgresql.org ... how does: post deny /pgsql-*@postgresql.org/i look for a patter? that would cover everything, I think ... ? I can't think of any reason why we'd want anything to go through as a POST from any address combination that falls in there, can you? - ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email . scrappy@hub.org MSN . scrappy@hub.org Yahoo . yscrappy Skype: hub.org ICQ . 7615664 -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) iD8DBQFHYBZb4QvfyHIvDvMRAmXpAKCww3X72GyBO35lZaZrDNULKhbu1ACeMTl7 C0jdWV3Gi4MBLDYVqHIVRCo= =XDJu -----END PGP SIGNATURE-----
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 - --On Wednesday, December 12, 2007 11:56:36 -0500 Andrew Sullivan <ajs@crankycanuck.ca> wrote: > On Wed, Dec 12, 2007 at 01:43:09PM -0300, Alvaro Herrera wrote: >> The problem I'm reporting is closely related: you will note that the >> username part contains an extra -postgresql.org so it's not exactly the >> list's "from" address. In my opinion what should have happened was that > > Aha. > >> this message, instead of attempting delivery to the list, should have >> been dropped on the floor with a reject message of "no such user here" >> or some such. > > Right. That's the other problem we were talking about in the same context. > I think it was Magnus who thought he had a solution for that. I thought we had already implemented the solution for that? We have a fixed list of valid email addresses on all the MX servers that mail gets rejected on ... try sending to 'garbage@postgresql.org', and it should bounce back with 'no such user' ... - ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email . scrappy@hub.org MSN . scrappy@hub.org Yahoo . yscrappy Skype: hub.org ICQ . 7615664 -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) iD8DBQFHYBcl4QvfyHIvDvMRAgBzAJwM9reKBfLtml7me/n1zBFyUTWRpwCeP/sE zO8vDJ3tYv67dk3prf9SvRU= =jS8r -----END PGP SIGNATURE-----
Marc G. Fournier wrote: > I thought we had already implemented the solution for that? We have a fixed > list of valid email addresses on all the MX servers that mail gets rejected on > ... try sending to 'garbage@postgresql.org', and it should bounce back with 'no > such user' ... > Well... -------- Original Message -------- Subject: [HACKERS] test Date: Wed, 12 Dec 2007 09:22:56 -0800 From: Joshua D. Drake <jd@commandprompt.com> Organization: Command Prompt, Inc. To: hackers@postgresql.org test ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend Joshua D. Drake
On Wed, Dec 12, 2007 at 09:29:12AM -0800, Joshua D. Drake wrote: > Marc G. Fournier wrote: > >rejected on ... try sending to 'garbage@postgresql.org', and it should > >bounce back with 'no such user' ... > > Well... > > > > -------- Original Message -------- > Subject: [HACKERS] test > Date: Wed, 12 Dec 2007 09:22:56 -0800 > From: Joshua D. Drake <jd@commandprompt.com> > Organization: Command Prompt, Inc. > To: hackers@postgresql.org But see the attachment here. Which raises the question, why did the sample we're discussing get by? It's not an address at that server. . . A This message was created automatically by mail delivery software. A message that you sent could not be delivered to one or more of its recipients. This is a permanent error. The following address(es) failed: garbage@postgresql.org SMTP error from remote mail server after RCPT TO:<garbage@postgresql.org>: host mail.postgresql.org [200.46.204.71]: 550 5.1.1 <garbage@postgresql.org>: Recipient address rejected: User unknown in local recipient table ------ This is a copy of the message, including all the headers. ------ Return-path: <ajs@crankycanuck.ca> Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=crankycanuck.ca) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from <ajs@crankycanuck.ca>) id 1J2VPC-0005gP-Go for garbage@postgresql.org; Wed, 12 Dec 2007 12:29:58 -0500 Received: by crankycanuck.ca (Postfix, from userid 1000) id 901A650476; Wed, 12 Dec 2007 12:29:53 -0500 (EST) Date: Wed, 12 Dec 2007 12:29:53 -0500 From: Andrew Sullivan <ajs@crankycanuck.ca> To: garbage@postgresql.org Subject: test Message-ID: <20071212172953.GB31954@crankycanuck.ca> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.13 (2006-08-11) testing
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Well what? hackers is listed as a valid alias for pgsql-hackers, and mail is redirected as appropriate ... that's why I suggested "garbage@postgresql.org" as a test, since we have no lists named 'garbage' :) - --On Wednesday, December 12, 2007 09:29:12 -0800 "Joshua D. Drake" <jd@commandprompt.com> wrote: > Marc G. Fournier wrote: > >> I thought we had already implemented the solution for that? We have a fixed >> list of valid email addresses on all the MX servers that mail gets rejected >> on ... try sending to 'garbage@postgresql.org', and it should bounce back >> with 'no such user' ... >> > > Well... > > > > -------- Original Message -------- > Subject: [HACKERS] test > Date: Wed, 12 Dec 2007 09:22:56 -0800 > From: Joshua D. Drake <jd@commandprompt.com> > Organization: Command Prompt, Inc. > To: hackers@postgresql.org > > test > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > > > Joshua D. Drake > > - ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email . scrappy@hub.org MSN . scrappy@hub.org Yahoo . yscrappy Skype: hub.org ICQ . 7615664 -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) iD8DBQFHYDAQ4QvfyHIvDvMRAr4yAJ9HZPmeyozOz08/Qq0O8/EdlJ2gSgCaA1Uk DZhQ/0e1syaYryEgyBL7yz0= =GFPC -----END PGP SIGNATURE-----
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 - --On Wednesday, December 12, 2007 12:32:12 -0500 Andrew Sullivan <ajs@crankycanuck.ca> wrote: > On Wed, Dec 12, 2007 at 09:29:12AM -0800, Joshua D. Drake wrote: >> Marc G. Fournier wrote: >> > rejected on ... try sending to 'garbage@postgresql.org', and it should >> > bounce back with 'no such user' ... >> >> Well... >> >> >> >> -------- Original Message -------- >> Subject: [HACKERS] test >> Date: Wed, 12 Dec 2007 09:22:56 -0800 >> From: Joshua D. Drake <jd@commandprompt.com> >> Organization: Command Prompt, Inc. >> To: hackers@postgresql.org > > But see the attachment here. Which raises the question, why did the sample > we're discussing get by? It's not an address at that server. . . Actually, yes it is ... its how majordomo deals with virtual domains ... when you send to pgsql-hackers@postgresql.org, it re-writes that as pgsql-hackers-postgresql.org@<hostname> within the virtual tables, and then passes *that* to the aliases file for processing: pgsql-hackers-postgresql.org: "|/usr/local/majordomo/bin/mj_enqueue - -r -d postgresql.org -l pgsql-hackers -P10 -p10" pgsql-hackers-postgresql.org-request: "|/usr/local/majordomo/bin/mj_enqueue - -q -d postgresql.org -l pgsql-hackers -P10 -p10" pgsql-hackers-postgresql.org-owner: "|/usr/local/majordomo/bin/mj_enqueue - -o -d postgresql.org -l pgsql-hackers -P10 -p10" owner-pgsql-hackers-postgresql.org: pgsql-hackers-postgresql.org-owner pgsql-hackers-postgresql.org-subscribe: "|/usr/local/majordomo/bin/mj_enqueue - -c subscribe -d postgresql.org -l pgsql-hackers -P10 -p10" pgsql-hackers-postgresql.org-subscribe-digest: "|/usr/local/majordomo/bin/mj_enqueue -c subscribe-set --req setting=digest -d postgresql.org -l pgsql-hackers -P10 -p10" pgsql-hackers-postgresql.org-unsubscribe: "|/usr/local/majordomo/bin/mj_enqueue - -c unsubscribe -d postgresql.org -l pgsql-hackers -P10 -p10" It doesn't by pass any rules sending to that address, it just by passes the virtual rewrite tables in postfix ... - ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email . scrappy@hub.org MSN . scrappy@hub.org Yahoo . yscrappy Skype: hub.org ICQ . 7615664 -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) iD8DBQFHYDC+4QvfyHIvDvMRApl+AJ0c5+QX6sPjJlwU+yOdGUTG0YsSpwCg3WLi PMC6EML6UlxiTz/UoPia8ys= =sgAI -----END PGP SIGNATURE-----
Marc G. Fournier wrote: > how does: > > post > deny > /pgsql-*@postgresql.org/i > > look for a patter? that would cover everything, I think ... ? I can't think > of any reason why we'd want anything to go through as a POST from any address > combination that falls in there, can you? AFAICS the idea is fine, but if this is a regex (I very much doubt it's not) it should be /pgsql-.*@postgresql.org/i -- Alvaro Herrera http://www.PlanetPostgreSQL.org/ "Pido que me den el Nobel por razones humanitarias" (Nicanor Parra)
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 You are right, I was looking at the examples for Glob vs Regular Expression ... but, it also needs a \ for the .org part, which I've added ... This is now added to the DEFAULT access rules ... - --On Wednesday, December 12, 2007 16:32:18 -0300 Alvaro Herrera <alvherre@alvh.no-ip.org> wrote: > Marc G. Fournier wrote: > >> how does: >> >> post >> deny >> /pgsql-*@postgresql.org/i >> >> look for a patter? that would cover everything, I think ... ? I can't >> think of any reason why we'd want anything to go through as a POST from any >> address combination that falls in there, can you? > > AFAICS the idea is fine, but if this is a rregex (I very much doubt it's > not) it should be > > /pgsql-.*@postgresql.org/i > > -- > Alvaro Herrera http://www.PlanetPostgreSQL.org/ > "Pido que me den el Nobel por razones humanitarias" (Nicanor Parra) - ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email . scrappy@hub.org MSN . scrappy@hub.org Yahoo . yscrappy Skype: hub.org ICQ . 7615664 -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) iD8DBQFHYEFb4QvfyHIvDvMRAq3SAKC+9bK2mzMk6ZkAjqilqTpakD66RACfSPRB qLTPhrD16Awj2AOVcKcjOzs= =ZADG -----END PGP SIGNATURE-----
Marc G. Fournier wrote: > You are right, I was looking at the examples for Glob vs Regular Expression ... > but, it also needs a \ for the .org part, which I've added ... Doh! > This is now added to the DEFAULT access rules ... Thanks! :-) -- Alvaro Herrera http://www.amazon.com/gp/registry/5ZYLFMCVHXC "La espina, desde que nace, ya pincha" (Proverbio africano)