Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pWxO9-000854-9t for pgsql-www@arkaria.postgresql.org; Tue, 28 Feb 2023 10:39:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pWxO7-0002CH-TM for pgsql-www@arkaria.postgresql.org; Tue, 28 Feb 2023 10:39:15 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pWxO7-0002C8-Gu for pgsql-www@lists.postgresql.org; Tue, 28 Feb 2023 10:39:15 +0000 Received: from imap2.cmatte.me ([54.37.205.152]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pWxO4-0007hF-IX for pgsql-www@lists.postgresql.org; Tue, 28 Feb 2023 10:39:14 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=cmatte.me; s=myselector; t=1677580749; bh=X4pldw7xiD32TPENo8HbeWTmtECpOp8DZreVC5pPZv4=; h=Date:To:References:From:Subject:In-Reply-To; b=pV9OOoG0lCCcETkRQtXR47rKN6YyFjSqclIsaoYyUN1WkJAiF0MABOBFobd2kGfio DEMVsZ9MhPqrT4ohwlcvYry4jsgz1KV1okZgaHsCJHdgk7EIlmKa2VN4w6zbP5iKHq SmNWZBFRE19KJqXPZwNtu4thWOitZ35nWeoiQjtSR6axnxGeGkml+aoj97Z0NsT4tL n/yg0tBKVeNHIV1a0S4oJKennfOC/4YXTXrLsxWIOQeWwkbaiZZDKx9NC2DI6FgBsf AdgzuH2tYFkvlPTvJYyssiWIN9rg5i4Se4VB2H2f1JZ3JLK5zOwe0dEcVTjG8MaDdO QS37lrJIwBqPw== Content-Type: multipart/mixed; boundary="------------1gz8qLI0G6uWjRm1enVv8mCW" Message-ID: <58138ea4-f2f2-50e7-a356-442b62fc7e14@cmatte.me> Date: Tue, 28 Feb 2023 11:39:09 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.8.0 Content-Language: en-US To: Magnus Hagander , PostgreSQL WWW References: <1d060463-e562-7783-decd-b5a7f3c4c06c@cmatte.me> <1b4db143-3410-54c2-bb91-1242ae430bcd@cmatte.me> From: =?UTF-8?Q?C=c3=a9lestin_Matte?= Subject: Re: [PATCH] pgarchives: pglister_sync: import lists with subscriber_access set to True In-Reply-To: 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. --------------1gz8qLI0G6uWjRm1enVv8mCW Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Attached another proposed solution to that problem, with a series of patches for pglister and pgarchives: - 0001-Add-subscriber_access-field-to-ListGroup_pglister.patch adds a subscriber_access field in pglister's admin section - 0002-Add-subscriber_access-to-archives-API_pglister.patch adds subscriber_access to the API's archive section in pglister - 0001-pglister_sync-obtain-subscriber_access-from-API_pgarchives.patch uses the value received from the API instead of a default "False" that has to be manually changed As a reminder, the problem was that subscriber_access was set to False by default, which means that any list created on pglister and set to be archived on pgarchives won't be reachable by subscribers, unless the subscriber_access field is manually modified in the database. -- Célestin Matte --------------1gz8qLI0G6uWjRm1enVv8mCW Content-Type: text/x-patch; charset=UTF-8; name="0001-Add-subscriber_access-field-to-ListGroup_pglister.patch" Content-Disposition: attachment; filename*0="0001-Add-subscriber_access-field-to-ListGroup_pglister.patch" Content-Transfer-Encoding: base64 RnJvbSA4NzJjNWNlZTUzN2E2YzM4N2FkOWIwZGU5NzY5NGZiOGZhMTJmNzhiIE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiA9P1VURi04P3E/Qz1DMz1BOWxlc3Rpbj0yME1hdHRl Pz0gPGdpdGxhYkBjbWF0dGUubWU+CkRhdGU6IFRodSwgMjMgRmViIDIwMjMgMTg6MDc6Mjgg KzAxMDAKU3ViamVjdDogW1BBVENIIDEvMl0gQWRkIHN1YnNjcmliZXJfYWNjZXNzIGZpZWxk IHRvIExpc3RHcm91cAoKLS0tCiAuLi4vbWlncmF0aW9ucy8wMDU1X2F1dG9fMjAyMzAyMjNf MTcwNi5weSAgICAgIHwgMTggKysrKysrKysrKysrKysrKysrCiB3ZWIvcGdsaXN0ZXIvbGlz dHMvbW9kZWxzLnB5ICAgICAgICAgICAgICAgICAgIHwgIDIgKysKIDIgZmlsZXMgY2hhbmdl ZCwgMjAgaW5zZXJ0aW9ucygrKQogY3JlYXRlIG1vZGUgMTAwNjQ0IHdlYi9wZ2xpc3Rlci9s aXN0cy9taWdyYXRpb25zLzAwNTVfYXV0b18yMDIzMDIyM18xNzA2LnB5CgpkaWZmIC0tZ2l0 IGEvd2ViL3BnbGlzdGVyL2xpc3RzL21pZ3JhdGlvbnMvMDA1NV9hdXRvXzIwMjMwMjIzXzE3 MDYucHkgYi93ZWIvcGdsaXN0ZXIvbGlzdHMvbWlncmF0aW9ucy8wMDU1X2F1dG9fMjAyMzAy MjNfMTcwNi5weQpuZXcgZmlsZSBtb2RlIDEwMDY0NAppbmRleCAwMDAwMDAwLi5iZGI0ZWRl Ci0tLSAvZGV2L251bGwKKysrIGIvd2ViL3BnbGlzdGVyL2xpc3RzL21pZ3JhdGlvbnMvMDA1 NV9hdXRvXzIwMjMwMjIzXzE3MDYucHkKQEAgLTAsMCArMSwxOCBAQAorIyBHZW5lcmF0ZWQg YnkgRGphbmdvIDIuMi4yNCBvbiAyMDIzLTAyLTIzIDE3OjA2CisKK2Zyb20gZGphbmdvLmRi IGltcG9ydCBtaWdyYXRpb25zLCBtb2RlbHMKKworCitjbGFzcyBNaWdyYXRpb24obWlncmF0 aW9ucy5NaWdyYXRpb24pOgorCisgICAgZGVwZW5kZW5jaWVzID0gWworICAgICAgICAoJ2xp c3RzJywgJzAwNTRfYWRkX2FyY2hpdmVkYXQnKSwKKyAgICBdCisKKyAgICBvcGVyYXRpb25z ID0gWworICAgICAgICBtaWdyYXRpb25zLkFkZEZpZWxkKAorICAgICAgICAgICAgbW9kZWxf bmFtZT0nbGlzdGdyb3VwJywKKyAgICAgICAgICAgIG5hbWU9J3N1YnNjcmliZXJfYWNjZXNz JywKKyAgICAgICAgICAgIGZpZWxkPW1vZGVscy5Cb29sZWFuRmllbGQoZGVmYXVsdD1GYWxz ZSwgaGVscF90ZXh0PSdDYW4gc3Vic2NyaWJlcnMgZ2V0IGZ1bGwgYWNjZXNzIHRvIHRoZSBh cmNoaXZlcz8nLCBudWxsPVRydWUpLAorICAgICAgICApLAorICAgIF0KZGlmZiAtLWdpdCBh L3dlYi9wZ2xpc3Rlci9saXN0cy9tb2RlbHMucHkgYi93ZWIvcGdsaXN0ZXIvbGlzdHMvbW9k ZWxzLnB5CmluZGV4IGRiYTk2ODkuLmNmM2ZmZWMgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2xpc3Rl ci9saXN0cy9tb2RlbHMucHkKKysrIGIvd2ViL3BnbGlzdGVyL2xpc3RzL21vZGVscy5weQpA QCAtMTExLDYgKzExMSw4IEBAIGNsYXNzIERvbWFpbihtb2RlbHMuTW9kZWwpOgogY2xhc3Mg TGlzdEdyb3VwKG1vZGVscy5Nb2RlbCk6CiAgICAgZ3JvdXBuYW1lID0gbW9kZWxzLkNoYXJG aWVsZChtYXhfbGVuZ3RoPTEwMCwgbnVsbD1GYWxzZSwgYmxhbms9RmFsc2UpCiAgICAgc29y dGtleSA9IG1vZGVscy5JbnRlZ2VyRmllbGQobnVsbD1GYWxzZSwgZGVmYXVsdD0xMCkKKyAg ICBzdWJzY3JpYmVyX2FjY2VzcyA9IG1vZGVscy5Cb29sZWFuRmllbGQobnVsbD1UcnVlLCBi bGFuaz1GYWxzZSwgZGVmYXVsdD1GYWxzZSwKKyAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgaGVscF90ZXh0PSJDYW4gc3Vic2NyaWJlcnMgZ2V0IGZ1bGwg YWNjZXNzIHRvIHRoZSBhcmNoaXZlcz8iKQogCiAgICAgZGVmIF9fc3RyX18oc2VsZik6CiAg ICAgICAgIHJldHVybiBzZWxmLmdyb3VwbmFtZQotLSAKMi4zOS4yCgo= --------------1gz8qLI0G6uWjRm1enVv8mCW Content-Type: text/x-patch; charset=UTF-8; name="0001-pglister_sync-obtain-subscriber_access-from-API_pgarchives.patch" Content-Disposition: attachment; filename*0="0001-pglister_sync-obtain-subscriber_access-from-API_pgarchi"; filename*1="ves.patch" Content-Transfer-Encoding: base64 RnJvbSBmZjcxZmMzNjYwOWVmMTM5ODM3NjEyYzVkNjA5MDZlZGNkMzQwYjYzIE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiA9P1VURi04P3E/Qz1DMz1BOWxlc3Rpbj0yME1hdHRl Pz0gPGdpdGxhYkBjbWF0dGUubWU+CkRhdGU6IE1vbiwgMjcgRmViIDIwMjMgMTk6MjI6MzMg KzAxMDAKU3ViamVjdDogW1BBVENIXSBwZ2xpc3Rlcl9zeW5jOiBvYnRhaW4gc3Vic2NyaWJl cl9hY2Nlc3MgZnJvbSBBUEkKCi0tLQogbG9hZGVyL3BnbGlzdGVyX3N5bmMucHkgfCA3ICsr KystLS0KIDEgZmlsZSBjaGFuZ2VkLCA0IGluc2VydGlvbnMoKyksIDMgZGVsZXRpb25zKC0p CgpkaWZmIC0tZ2l0IGEvbG9hZGVyL3BnbGlzdGVyX3N5bmMucHkgYi9sb2FkZXIvcGdsaXN0 ZXJfc3luYy5weQppbmRleCBkN2UxOTI1Li43NDQwYWI4IDEwMDc1NQotLS0gYS9sb2FkZXIv cGdsaXN0ZXJfc3luYy5weQorKysgYi9sb2FkZXIvcGdsaXN0ZXJfc3luYy5weQpAQCAtNDIs MTUgKzQyLDE2IEBAIGlmIF9fbmFtZV9fID09ICJfX21haW5fXyI6CiAgICAgb2JqID0gci5q c29uKCkKIAogICAgICMgRm9yIGdyb3VwcywganVzdCBhZGQgdGhlbSBpZiB0aGV5IGRvbid0 IGV4aXN0Ci0gICAgZ3JvdXBzID0ge2dbJ2dyb3VwJ11bJ2lkJ106IGdbJ2dyb3VwJ11bJ2dy b3VwbmFtZSddIGZvciBnIGluIG9ian0KKyAgICBncm91cHMgPSB7Z1snZ3JvdXAnXVsnaWQn XTogKGdbJ2dyb3VwJ11bJ2dyb3VwbmFtZSddLCBnWydncm91cCddWydzdWJzY3JpYmVyX2Fj Y2VzcyddKSBmb3IgZyBpbiBvYmp9CiAKLSAgICBmb3IgaWQsIG5hbWUgaW4gbGlzdChncm91 cHMuaXRlbXMoKSk6CisgICAgZm9yIGlkLCAobmFtZSwgc3Vic2NyaWJlcl9hY2Nlc3MpIGlu IGxpc3QoZ3JvdXBzLml0ZW1zKCkpOgogICAgICAgICBjdXJzLmV4ZWN1dGUoIlNFTEVDVCBF WElTVFMgKFNFTEVDVCAxIEZST00gbGlzdGdyb3VwcyBXSEVSRSBncm91cG5hbWU9JShncm91 cClzKSIsIHsKICAgICAgICAgICAgICdncm91cCc6IG5hbWUsCiAgICAgICAgIH0pCiAgICAg ICAgIGlmIG5vdCBjdXJzLmZldGNob25lKClbMF06Ci0gICAgICAgICAgICBjdXJzLmV4ZWN1 dGUoIklOU0VSVCBJTlRPIGxpc3Rncm91cHMgKGdyb3VwbmFtZSwgc29ydGtleSkgVkFMVUVT ICglKGdyb3VwKXMsIDEwMCkgUkVUVVJOSU5HIGdyb3VwbmFtZSIsIHsKKyAgICAgICAgICAg IGN1cnMuZXhlY3V0ZSgiSU5TRVJUIElOVE8gbGlzdGdyb3VwcyAoZ3JvdXBuYW1lLCBzb3J0 a2V5LCBzdWJzY3JpYmVyX2FjY2VzcykgVkFMVUVTICglKGdyb3VwKXMsIDEwMCwgJShzdWJz Y3JpYmVyX2FjY2VzcylzKSBSRVRVUk5JTkcgZ3JvdXBuYW1lIiwgewogICAgICAgICAgICAg ICAgICdncm91cCc6IG5hbWUsCisgICAgICAgICAgICAgICAgJ3N1YnNjcmliZXJfYWNjZXNz Jzogc3Vic2NyaWJlcl9hY2Nlc3MsCiAgICAgICAgICAgICB9KQogICAgICAgICAgICAgcHJp bnQoIkFkZGVkIGdyb3VwICVzIiAlIG5hbWUpCiAKLS0gCjIuMzkuMgoK --------------1gz8qLI0G6uWjRm1enVv8mCW Content-Type: text/x-patch; charset=UTF-8; name="0002-Add-subscriber_access-to-archives-API_pglister.patch" Content-Disposition: attachment; filename*0="0002-Add-subscriber_access-to-archives-API_pglister.patch" Content-Transfer-Encoding: base64 RnJvbSA2ZTk0YTIzODBiY2I0NzFlMWEwODlhNjE5MzFlNGQ5ZDE2ZTgwNzUyIE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiA9P1VURi04P3E/Qz1DMz1BOWxlc3Rpbj0yME1hdHRl Pz0gPGdpdGxhYkBjbWF0dGUubWU+CkRhdGU6IE1vbiwgMjcgRmViIDIwMjMgMTk6MDc6MDUg KzAxMDAKU3ViamVjdDogW1BBVENIIDIvMl0gQWRkIHN1YnNjcmliZXJfYWNjZXNzIHRvIGFy Y2hpdmVzIEFQSQoKLS0tCiB3ZWIvcGdsaXN0ZXIvbGlzdHMvdmlld3NfYXBpLnB5IHwgNCAr Ky0tCiAxIGZpbGUgY2hhbmdlZCwgMiBpbnNlcnRpb25zKCspLCAyIGRlbGV0aW9ucygtKQoK ZGlmZiAtLWdpdCBhL3dlYi9wZ2xpc3Rlci9saXN0cy92aWV3c19hcGkucHkgYi93ZWIvcGds aXN0ZXIvbGlzdHMvdmlld3NfYXBpLnB5CmluZGV4IDI0ZTQxZGYuLjUwZGU5YzggMTAwNjQ0 Ci0tLSBhL3dlYi9wZ2xpc3Rlci9saXN0cy92aWV3c19hcGkucHkKKysrIGIvd2ViL3BnbGlz dGVyL2xpc3RzL3ZpZXdzX2FwaS5weQpAQCAtMTQwLDExICsxNDAsMTEgQEAgY2xhc3MgQXJj aGl2ZXNBcGkoVmlldyk6CiAgICAgZGVmIGdldF9saXN0cyhzZWxmLCB3aXRoX3N1YnNjcmli ZXJzKToKICAgICAgICAgY3VycyA9IGNvbm5lY3Rpb24uY3Vyc29yKCkKICAgICAgICAgaWYg d2l0aF9zdWJzY3JpYmVyczoKLSAgICAgICAgICAgIGN1cnMuZXhlY3V0ZSgiU0VMRUNUIGwu aWQgQVMgbGlzdGlkLCBsLm5hbWUgQVMgbGlzdG5hbWUsIGQubmFtZSBBUyBkb21haW4sIGwu c2hvcnRkZXNjLCBsLmxvbmdkZXNjLCBqc29uX2J1aWxkX29iamVjdCgnaWQnLCBnLmlkLCAn Z3JvdXBuYW1lJywgZy5ncm91cG5hbWUpIEFTIGdyb3VwLCBDT0FMRVNDRShhcnJheV9hZ2co dS51c2VybmFtZSkgRklMVEVSIChXSEVSRSB1LnVzZXJuYW1lIElTIE5PVCBOVUxMKSwgQVJS QVlbXTo6dGV4dFtdKSBBUyBzdWJzY3JpYmVycyBGUk9NIGxpc3RzX2xpc3QgbCBJTk5FUiBK T0lOIGxpc3RzX2RvbWFpbiBkIE9OIGwuZG9tYWluX2lkPWQuaWQgSU5ORVIgSk9JTiBsaXN0 c19saXN0Z3JvdXAgZyBPTiBsLmdyb3VwX2lkPWcuaWQgTEVGVCBKT0lOIG1haWxpbmdsaXN0 X3N1YnNjcmliZXJzIHMgT04gcy5saXN0aWQ9bC5pZCBMRUZUIEpPSU4gYXV0aF91c2VyIHUg T04gdS5pZD1zLnVzZXJpZCBXSEVSRSBsLmFyY2hpdmVkYXRfaWQ9JShhcmNoaXZlaWQpcyBH Uk9VUCBCWSBsLmlkLCBkLmlkLCBnLmlkIE9SREVSIEJZIDIsMSIsIHsKKyAgICAgICAgICAg IGN1cnMuZXhlY3V0ZSgiU0VMRUNUIGwuaWQgQVMgbGlzdGlkLCBsLm5hbWUgQVMgbGlzdG5h bWUsIGQubmFtZSBBUyBkb21haW4sIGwuc2hvcnRkZXNjLCBsLmxvbmdkZXNjLCBqc29uX2J1 aWxkX29iamVjdCgnaWQnLCBnLmlkLCAnZ3JvdXBuYW1lJywgZy5ncm91cG5hbWUsICdzdWJz Y3JpYmVyX2FjY2VzcycsIGcuc3Vic2NyaWJlcl9hY2Nlc3MpIEFTIGdyb3VwLCBDT0FMRVND RShhcnJheV9hZ2codS51c2VybmFtZSkgRklMVEVSIChXSEVSRSB1LnVzZXJuYW1lIElTIE5P VCBOVUxMKSwgQVJSQVlbXTo6dGV4dFtdKSBBUyBzdWJzY3JpYmVycyBGUk9NIGxpc3RzX2xp c3QgbCBJTk5FUiBKT0lOIGxpc3RzX2RvbWFpbiBkIE9OIGwuZG9tYWluX2lkPWQuaWQgSU5O RVIgSk9JTiBsaXN0c19saXN0Z3JvdXAgZyBPTiBsLmdyb3VwX2lkPWcuaWQgTEVGVCBKT0lO IG1haWxpbmdsaXN0X3N1YnNjcmliZXJzIHMgT04gcy5saXN0aWQ9bC5pZCBMRUZUIEpPSU4g YXV0aF91c2VyIHUgT04gdS5pZD1zLnVzZXJpZCBXSEVSRSBsLmFyY2hpdmVkYXRfaWQ9JShh cmNoaXZlaWQpcyBHUk9VUCBCWSBsLmlkLCBkLmlkLCBnLmlkIE9SREVSIEJZIDIsMSIsIHsK ICAgICAgICAgICAgICAgICAnYXJjaGl2ZWlkJzogc2VsZi5hcmNoaXZlc2VydmVyLmlkLAog ICAgICAgICAgICAgfSkKICAgICAgICAgZWxzZToKLSAgICAgICAgICAgIGN1cnMuZXhlY3V0 ZSgiU0VMRUNUIGwuaWQgQVMgbGlzdGlkLCBsLm5hbWUgQVMgbGlzdG5hbWUsIGQubmFtZSBB UyBkb21haW4sIGwuc2hvcnRkZXNjLCBsLmxvbmdkZXNjLCBqc29uX2J1aWxkX29iamVjdCgn aWQnLCBnLmlkLCAnZ3JvdXBuYW1lJywgZy5ncm91cG5hbWUpIEFTIGdyb3VwIEZST00gbGlz dHNfbGlzdCBsIElOTkVSIEpPSU4gbGlzdHNfZG9tYWluIGQgT04gbC5kb21haW5faWQ9ZC5p ZCBJTk5FUiBKT0lOIGxpc3RzX2xpc3Rncm91cCBnIE9OIGwuZ3JvdXBfaWQ9Zy5pZCBXSEVS RSBsLmFyY2hpdmVkYXRfaWQ9JShhcmNoaXZlaWQpcyBHUk9VUCBCWSBsLmlkLCBkLmlkLCBn LmlkIE9SREVSIEJZIDIsMSIsIHsKKyAgICAgICAgICAgIGN1cnMuZXhlY3V0ZSgiU0VMRUNU IGwuaWQgQVMgbGlzdGlkLCBsLm5hbWUgQVMgbGlzdG5hbWUsIGQubmFtZSBBUyBkb21haW4s IGwuc2hvcnRkZXNjLCBsLmxvbmdkZXNjLCBqc29uX2J1aWxkX29iamVjdCgnaWQnLCBnLmlk LCAnZ3JvdXBuYW1lJywgZy5ncm91cG5hbWUsICdzdWJzY3JpYmVyX2FjY2VzcycsIGcuc3Vi c2NyaWJlcl9hY2Nlc3MpIEFTIGdyb3VwIEZST00gbGlzdHNfbGlzdCBsIElOTkVSIEpPSU4g bGlzdHNfZG9tYWluIGQgT04gbC5kb21haW5faWQ9ZC5pZCBJTk5FUiBKT0lOIGxpc3RzX2xp c3Rncm91cCBnIE9OIGwuZ3JvdXBfaWQ9Zy5pZCBXSEVSRSBsLmFyY2hpdmVkYXRfaWQ9JShh cmNoaXZlaWQpcyBHUk9VUCBCWSBsLmlkLCBkLmlkLCBnLmlkIE9SREVSIEJZIDIsMSIsIHsK ICAgICAgICAgICAgICAgICAnYXJjaGl2ZWlkJzogc2VsZi5hcmNoaXZlc2VydmVyLmlkLAog ICAgICAgICAgICAgfSkKICAgICAgICAgY29sdW1ucyA9IFtjb2xbMF0gZm9yIGNvbCBpbiBj dXJzLmRlc2NyaXB0aW9uXQotLSAKMi4zOS4yCgo= --------------1gz8qLI0G6uWjRm1enVv8mCW--