Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wGDYI-0060Ee-2w for pgsql-www@arkaria.postgresql.org; Fri, 24 Apr 2026 10:14:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wGDYF-005p3K-0X for pgsql-www@arkaria.postgresql.org; Fri, 24 Apr 2026 10:14:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wGDYE-005p3C-2o for pgsql-www@lists.postgresql.org; Fri, 24 Apr 2026 10:14:22 +0000 Received: from smtp.cmatte.me ([54.37.205.152]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wGDYC-00000002oBC-0wke for pgsql-www@lists.postgresql.org; Fri, 24 Apr 2026 10:14:22 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=cmatte.me; s=myselector; t=1777025658; bh=RZphmFLWvA6R9FcvM+CBFqVVWf5su9QcQOR4sWeSii8=; h=Date:Subject:To:References:From:In-Reply-To; b=KUD0vw1afRPG5K9xT1X/xhuJ9/YYHqobfasKSzzm5NV6+OeoqKPLK77R+s3PrRyEX VITE7o1ifi6B0ncNH712ha3zKScMDz9XBUgFL+XsMfPe+R7+v0CxJw7tScmb0jSiKR kX8vQzU0rQDwgHk2rHJ50rnmoOayJtx6l77h/b4ejvfZv96IFrEHGiDbvotySoqmAQ 9Bf3rtJaSsASuWmr8WA50YDsFLnERlkzyt9BX+Q92X+egeajgGosq9DAf0md+OOGPi a/xAKlkvM7XKN46Z6SHuFNFO72aeIKHNSkJ/PzrpGGO14DZGYG8Lski3RTjd/wEeG5 i0sYhNdpgj3XA== Content-Type: multipart/mixed; boundary="------------P0RZYpTiKbuOcyUqftWYyVZE" Message-ID: <8b93374e-e32e-42f4-a5fa-a925d86d2c57@cmatte.me> Date: Fri, 24 Apr 2026 12:14:18 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Issue: pglister: emails to list owners break SPF/DMARC To: pgsql-www@lists.postgresql.org References: <1aaa8202-1dfa-4316-8af6-60955882492c@cmatte.me> Content-Language: en-US From: =?UTF-8?Q?C=C3=A9lestin_Matte?= Autocrypt: addr=celestin.matte@cmatte.me; keydata= xsFNBFQipO8BEADUvqE27QFRLuew+jnzTi1HupltXE+mcFXkCE3ksU4UIMpUDHud+Uje6HIA dHQuq4ovTZOrCsE6cmwZ7HXjG3/fwCTsmlL+/VlJM+ip3l4vAnlL9CaN1iPGERfiYEgyQ80J GeEaPAo4wPyuU/qE0OkBFsb25lyyfpycd6GZXCWEj2/lJtWqkRLx9S9kNms6PlbOGw2KBaeL H9a778Gk73ELkaV/rTmLISZSy5KFszHnesZeNCIwjJdiEPvrhR1W/Nux1h8ac1fUzmbGXoLv 2dCskYX8DHCTzEEDJs+jnS3JVcWA39DDWnpdkLCy8/dKFJtnC/bw8dAryAIyqtSERJhJ5k7r hTr2t7EMwkh+mjTgYc8ixxkUEeHmTz3QMgnWBaKB/GhNPrdlJEmPxdQnTftA5kek9hfcmdCR mitOZkrqq0N55i/PPb5YFCEMuEWDkJLdRN+oyQy4zz4qdqHxhLqNnVrKx56kuHCEvD8rMvJg qrBei2rmr/rXhLGqk5l8iTfNZNJBRDCTT2S+i07U8bHuRpFH7R80pdBgyvJM3JViA1EbxDxS aGrK9PcWnxSgdex+hYN3bNHsK3CLMcMf94fbZIpATDM28tgKFjiCWJq1z+EaWuV48LBRanxF wqMj/YhG7ydcWj+KD1tjhb3c5sPqxoFF7ZMA4SiquUO+1Qis9wARAQABzSpDw6lsZXN0aW4g TWF0dGUgPGNlbGVzdGluLm1hdHRlQGNtYXR0ZS5tZT7CwY4EEwEIADgWIQRkMBVsWP+VuH6p DzChpij+y2qL1gUCX140dAIbAwULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRChpij+y2qL 1rnREADUGn7UXdUl2pyFlaIErGT17tulBh854Q43ePV27JDlOabh0csk6WyB18bYn9PhA4es liF6LFYOGdJPO+t1qodfxthZjZksVPb4cqR/Q/EL135zZ069Jg0P7kcmSyEeFq0iUSCVL4wN YYF+lCpKVvwkt9cD3vqxGi0zacO0aKBYlG/KNTTYNKC606FmTS75jtoJeQEpQE/eQpDqPACC nBMoyJZyDfXyIkg02lWQTrLjMa5U6G0+iH00pjadgaUeB3OpvIYaMFxMfKodnWEgTx21aY1m HFa8MSM1uSW6NFLXjTKxCxEzQtkwOLiOpvIf+Kjxe1VLcb39ulMs9JBxAYJAfpaUO+u/sPGf N6NexjVjJlaV153wdAjcOycDk1UXhqHwMh4i7Um6pjftyqAhT25/CPD+O2A68vn852Taw/Bx cbIbJ3uDxluR5/J0eIwiLzP4cMRa+0av2Xt7UqqN/RCx0owvlILpHkxH/3Buzu505pNqNs3Y 7ZnViYRe0cQpfdQOOfjtSV2gFx/e6jcF47dUGSqCogCAfn9j8HpmsAsXnMS4g9548CKc7ByY HZNXAuRZmywRrCP+kyNB/No4uaMvNzGbaCtva3Ui9DEI01IAoZ2GILEGOlmHCXO6QLDLW+lH /N0fgKv40D6vR9ysq0BuRHeJmHCRLhhBRZHSy8U9Ls7BTQRUIqTvARAA3h2d22LoJs9UboUg oBIIBS7D5NV2sfUbt3j8fotgaKWT2Y4UJJx8hBdyfkdUa6++yaGk92EBN8vs4BLd1zRj/izX Ai3sbyb+lzXs7e/DwAX5vZveGQn7fYc14ST72fLIE/B2k1V+syoi4bhoueCWnprSEwYNWhbg POQMFyOvUhglEeqLGhijnIQatYzwmoli6QhRip4wx5FfSYS0cgjD/uFZPnLxKvq7Cn39Hbe7 4k5atJRC2YD1aFysjGzPm1mr0H+JCjJpN3b7VlDrYtpwEfc77F6txKGFVonS66P4Xn2+n3A4 mBUqn3GXe2DkJACnS6NS//wWUj6nxn1vxbTLrhyvYVSMKksZ09jfBT4poN/yGawhleMwEF2i sXMDu2tmNb8wwTsj6Je9ibi2xs6E7gohZnGSnWx7dgnlUyKAQvmEsE8Z2wC3T2FppeobzY3Y t+Isj3wFYWMpp9Ijsk9IMjIkyFs1ii/OA8zsXlpT1Jsok39KkZQGJ9xaRm79+mHM6t7b2tR2 LmtqypIqOsg8PukIK83oVP2BQQHwBCOf8LoVJZp6Q2Zt/mhkHm1+2C2ajGKeoEWcc0wd2FiC LHSYPplT+a5Gf2Cxlk9wgtGBa7X4YZq1btXFJebwC9UOHaTG9suFDYUJkIC48/mm7MRdZgjd el/Ip0nLP6qfkmVcWm0AEQEAAcLBXwQYAQIACQUCVCKk7wIbDAAKCRChpij+y2qL1qyZD/9q WaxEuYW2SM9hUaHnnERfmlnJAT6EmRU2uRXm5pGg3kbS6GcjiFnByLK8U9syA7j1XNIB/R/c 442R5o1tAd0kEYq9pLk80Nkc8oULOBHgMs8FJSWpgVYJ7Qxfgg9geKXwjjljhdM2SCB214s1 oIml3MiE91se7JSPAfMnomTdXRQMuphFF4ETw7Dd134AmhpAcXj6PeCXWmQJh4iPmJCy6K2t +Gbe7xyc9f6ok4zIEeZGDWyKctKgCQv07vVB5qFhxbk60AGWHjKSBTKLB8EhA2nriWIpJqPM Ng1DdFuBiBuWwLo29whT66XC8zdtfqbcDh4bRG7KaarOB0nbrYvifOQRB/ijnjn9xssaSdWy 8+ea2vSamjCXDb0wWl1itDa61iUsiiPiB2UP7PrI75rI+oHRDBy8AK3IYkby0IkI3nD+8wKf 7eeHao1vG/r6E8PhJ1KbMtHkxwV/iSVRoETR8+vcsYP4Rh5HHlc7ERUWgN4Cgyk/WZd4RwNa E7jwD00hpkxgbHNoXXVvYlzRKWpIQnBzEKc+46JsRie91/YrxOkm123PoWGasOCzinr5r3uT lHrvULo7IsHw+1Ru29cne8BH9+FKxup4B2SYJ6RjZFwd+8dan2DW7dqjA2d8l2/CgQgL7Hqq co++UjjOPJT3t7qY4ekbQ3xf6bdSDZh7Aw== In-Reply-To: <1aaa8202-1dfa-4316-8af6-60955882492c@cmatte.me> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------P0RZYpTiKbuOcyUqftWYyVZE Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 15/09/2025 18:00, Célestin Matte wrote: > Unlike regular mailing list emails, emails to -owner@ are forwarded as-is to mailing list owners, which means they will probably be blocked later on as the mailing list email server is not the legitimate sender. This breaks SPF/DMARC. In my case, smtp-relay.gmail.com (which I use to emit mailing list emails) refuses to forward any such email. > > I did not dig too much into ways to fix this because most (if not all) emails to these address are spam anyway, some of them passing spamassassin filters. But it may be better to do things properly at some point. Here's a patch to fix this issue. To do so, I embed the email in a moderation email sent from the moderation address. -- Célestin Matte --------------P0RZYpTiKbuOcyUqftWYyVZE Content-Type: text/x-patch; charset=UTF-8; name="0001-Use-template-to-forward-emails-to-mailing-list-owner.patch" Content-Disposition: attachment; filename*0="0001-Use-template-to-forward-emails-to-mailing-list-owner.pa"; filename*1="tch" Content-Transfer-Encoding: base64 RnJvbSA4ODM3ZGNhNWQzYTAzNDI5YWU1MWIwYzFiNDg5MGNjMjNjYTM2NjZhIE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiA9P1VURi04P3E/Qz1DMz1BOWxlc3Rpbj0yME1hdHRl Pz0gPGRldkBjbWF0dGUubWU+CkRhdGU6IEZyaSwgMjQgQXByIDIwMjYgMTA6MzE6MzggKzAy MDAKU3ViamVjdDogW1BBVENIXSBVc2UgdGVtcGxhdGUgdG8gZm9yd2FyZCBlbWFpbHMgdG8g bWFpbGluZyBsaXN0IG93bmVycyB2aWEgYQogc3lzdGVtIGFkZHJlc3MKClJlbGF5aW5nIHRo ZSBlbWFpbCBkaXJlY3RseSBicmVha3MgU1BGL0RNQVJDLiBUbyBhdm9pZCB0aGlzIGlzc3Vl LAplbWJiZWQgdGhlIGVtYWlsIGluIGEgbW9kZXJhdGlvbiBlbWFpbCBzZW50IGZyb20gdGhl IG1vZGVyYXRpb24KYWRkcmVzcy4KLS0tCiBsaWIvaGFuZGxlcnMvbWFpbGhhbmRsZXIucHkg ICAgIHwgMjYgKysrKysrKysrKysrKysrKysrKystLS0tLS0KIG1haWx0ZW1wbGF0ZXMvb3du ZXJfZm9yd2FyZC50eHQgfCAgNyArKysrKysrCiAyIGZpbGVzIGNoYW5nZWQsIDI3IGluc2Vy dGlvbnMoKyksIDYgZGVsZXRpb25zKC0pCiBjcmVhdGUgbW9kZSAxMDA2NDQgbWFpbHRlbXBs YXRlcy9vd25lcl9mb3J3YXJkLnR4dAoKZGlmZiAtLWdpdCBhL2xpYi9oYW5kbGVycy9tYWls aGFuZGxlci5weSBiL2xpYi9oYW5kbGVycy9tYWlsaGFuZGxlci5weQppbmRleCA3MWE3ZDRl Li5iZWIyY2IwIDEwMDY0NAotLS0gYS9saWIvaGFuZGxlcnMvbWFpbGhhbmRsZXIucHkKKysr IGIvbGliL2hhbmRsZXJzL21haWxoYW5kbGVyLnB5CkBAIC0xNSw3ICsxNSw3IEBAIGZyb20g YmFzZWxpYi5saXN0cyBpbXBvcnQgQ2NQb2xpY2llcywgQmNjUG9saWNpZXMKIGZyb20gbWFp bHV0aWwuaGVhZGVyIGltcG9ydCBkZWNvZGVfbWltZV9oZWFkZXIKIGZyb20gbWFpbHV0aWwu Ym9keSBpbXBvcnQgZ2V0X3RydW5jYXRlZF9ib2R5CiBmcm9tIG1haWx1dGlsLmF0dGFjaG1l bnQgaW1wb3J0IGdldF9hdHRhY2htZW50X2luZm8KLWZyb20gYmFzZWxpYi5taXNjIGltcG9y dCBnZW5lcmF0ZV9yYW5kb21fdG9rZW4sIGxvZywgZm9ybWF0X3NpemUKK2Zyb20gYmFzZWxp Yi5taXNjIGltcG9ydCBnZW5lcmF0ZV9yYW5kb21fdG9rZW4sIGxvZywgZm9ybWF0X3NpemUs IG9iZnVzY2F0ZV9lbWFpbF9hZGRyZXNzCiBmcm9tIGJhc2VsaWIuY29uZmlnIGltcG9ydCBj b25maWcKIGZyb20gYmFzZWxpYi50ZW1wbGF0ZSBpbXBvcnQgc2VuZF9tYWlsdGVtcGxhdGUK IApAQCAtOTExLDEyICs5MTEsMjYgQEAgT1JERVIgQlkgMSIiIiwKICAgICAgICAgIyBwYXNz IHRoZSBtYWlsIG9uIHRvIHRoZXJlLgogICAgICAgICB3aXRoIHNlbGYuY29ubi5jdXJzb3Io KSBhcyBjdXJzOgogICAgICAgICAgICAgbW9kcyA9IHNlbGYubWxpc3QuZ2V0X21vZGVyYXRv cnMoKQorICAgICAgICAgICAgY29udGV4dCA9IHsKKyAgICAgICAgICAgICAgICAnc2VuZGVy Jzogb2JmdXNjYXRlX2VtYWlsX2FkZHJlc3Moc2VsZi5zZW5kZXIpLAorICAgICAgICAgICAg ICAgICdmcm9tJzogb2JmdXNjYXRlX2VtYWlsX2FkZHJlc3Moc2VsZi5mcm9tYWRkciksCisg ICAgICAgICAgICAgICAgJ3N1YmplY3QnOiBzZWxmLnN1YmplY3QsCisgICAgICAgICAgICAg ICAgJ2JvZHknOiBzZWxmLl9nZXRfdHJ1bmNhdGVkX2JvZHkoKSwKKyAgICAgICAgICAgICAg ICAnbGlzdF9uYW1lJzogc2VsZi5tbGlzdC5uYW1lLAorICAgICAgICAgICAgICAgICdtb2Rl cmF0b3JfYWRkcmVzcyc6IHNlbGYubWxpc3QubW9kZXJhdG9yX25vdGljZV9hZGRyZXNzKCkK KyAgICAgICAgICAgIH0KKwogICAgICAgICAgICAgZm9yIGVtYWlsLCBuYW1lIGluIG1vZHM6 Ci0gICAgICAgICAgICAgICAgY3Vycy5leGVjdXRlKCJJTlNFUlQgSU5UTyByYXdfb3V0IChz ZW5kZXIsIHJlY2lwaWVudCwgY29udGVudHMpIFZBTFVFUyAoJShzZW5kZXIpcywgJShyZWNp cGllbnQpcywgJShjb250ZW50cylzKSIsIHsKLSAgICAgICAgICAgICAgICAgICAgJ3NlbmRl cic6IHNlbGYuc2VuZGVyLAotICAgICAgICAgICAgICAgICAgICAncmVjaXBpZW50JzogZW1h aWwsCi0gICAgICAgICAgICAgICAgICAgICdjb250ZW50cyc6IHNlbGYuYmlvLmdldHZhbHVl KCksCi0gICAgICAgICAgICAgICAgfSkKKyAgICAgICAgICAgICAgICBzZW5kX21haWx0ZW1w bGF0ZSgKKyAgICAgICAgICAgICAgICAgICAgY3VycywKKyAgICAgICAgICAgICAgICAgICAg c2VsZi5tbGlzdC5tb2RlcmF0b3Jfbm90aWNlX2FkZHJlc3MoKSwKKyAgICAgICAgICAgICAg ICAgICAgc2VsZi5tbGlzdC5tb2RlcmF0b3Jfbm90aWNlX25hbWUoKSwKKyAgICAgICAgICAg ICAgICAgICAgZW1haWwsCisgICAgICAgICAgICAgICAgICAgIG5hbWUsCisgICAgICAgICAg ICAgICAgICAgIGYiRW1haWwgcmVjZWl2ZWQgb24ge3NlbGYubWxpc3QubmFtZX0gbGlzdCBt b2RlcmF0b3JzIGFkZHJlc3MiLAorICAgICAgICAgICAgICAgICAgICAnb3duZXJfZm9yd2Fy ZC50eHQnLAorICAgICAgICAgICAgICAgICAgICBjb250ZXh0CisgICAgICAgICAgICAgICAg KQogICAgICAgICAgICAgbG9nKGN1cnMsIDAsICdtYWlsJywKICAgICAgICAgICAgICAgICAn TWFpbCB0byBsaXN0IG93bmVyIG9mIHswfSBkZWxpdmVyZWQgdG8gezF9IG1vZGVyYXRvcnMu Jy5mb3JtYXQoc2VsZi5tbGlzdC5uYW1lLCBsZW4obW9kcykpLAogICAgICAgICAgICAgICAg IHNlbGYubWVzc2FnZWlkKQpkaWZmIC0tZ2l0IGEvbWFpbHRlbXBsYXRlcy9vd25lcl9mb3J3 YXJkLnR4dCBiL21haWx0ZW1wbGF0ZXMvb3duZXJfZm9yd2FyZC50eHQKbmV3IGZpbGUgbW9k ZSAxMDA2NDQKaW5kZXggMDAwMDAwMC4uZDEyMjAzOAotLS0gL2Rldi9udWxsCisrKyBiL21h aWx0ZW1wbGF0ZXMvb3duZXJfZm9yd2FyZC50eHQKQEAgLTAsMCArMSw3IEBACitUaGUgZm9s bG93aW5nIGVtYWlsIHdhcyByZWNlaXZlZCBvbiB0aGUgbGlzdCBtb2RlcmF0b3JzIGFkZHJl c3MgKCRtb2RlcmF0b3JfYWRkcmVzcyk6CisKK1NlbmRlcjogICRmcm9tICgkc2VuZGVyKQor U3ViamVjdDogJHN1YmplY3QKK0xpc3Q6ICRsaXN0X25hbWUKKworJGJvZHkKLS0gCjIuNTMu MAoK --------------P0RZYpTiKbuOcyUqftWYyVZE--