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 1oRUwl-0006Gb-GM for pgsql-hackers@arkaria.postgresql.org; Fri, 26 Aug 2022 08:44:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oRUwi-00049Y-NY for pgsql-hackers@arkaria.postgresql.org; Fri, 26 Aug 2022 08:44:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oRUwi-00049O-07 for pgsql-hackers@lists.postgresql.org; Fri, 26 Aug 2022 08:44:08 +0000 Received: from smtp-fw-2101.amazon.com ([72.21.196.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oRUwd-0000jn-FQ for pgsql-hackers@lists.postgresql.org; Fri, 26 Aug 2022 08:44:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1661503443; x=1693039443; h=message-id:date:mime-version:from:subject:to; bh=x96rmxwG3zNMuPxcUzZJsUNfua4Uts0teS061TWeX1g=; b=ABdzpXxtbvqeH4Ayo8aJBqLMTALuHtoO7jPYXQqWdBfbC49uUxgomLYl 1ZLMuCIFdud/qMxxTTYgiEWhrL0j0R+Brai40/MeqU6hfvTNZMA/Xuo8B FgyY5yibLEArnTWobsejxU5JSLb0WXDZzIXIp9Rr5oelu4CX7zk6t8FmH Y=; X-Amazon-filename: v1-0001-peer-authentication-tap-test.patch X-IronPort-AV: E=Sophos;i="5.93,264,1654560000"; d="scan'208";a="234302842" Received: from iad12-co-svc-p1-lb1-vlan3.amazon.com (HELO email-inbound-relay-iad-1a-bbd95331.us-east-1.amazon.com) ([10.43.8.6]) by smtp-border-fw-2101.iad2.amazon.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 26 Aug 2022 08:43:50 +0000 Received: from EX13D03EUC003.ant.amazon.com (iad12-ws-svc-p26-lb9-vlan3.iad.amazon.com [10.40.163.38]) by email-inbound-relay-iad-1a-bbd95331.us-east-1.amazon.com (Postfix) with ESMTPS id CD4BEC1A45 for ; Fri, 26 Aug 2022 08:43:49 +0000 (UTC) Received: from [192.168.22.152] (10.43.161.172) by EX13D03EUC003.ant.amazon.com (10.43.164.192) with Microsoft SMTP Server (TLS) id 15.0.1497.38; Fri, 26 Aug 2022 08:43:47 +0000 Content-Type: multipart/mixed; boundary="------------VFeIOijtxgu5ppPzvAXpO4EG" Message-ID: Date: Fri, 26 Aug 2022 10:43:43 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.2.0 Content-Language: en-US From: "Drouvot, Bertrand" Subject: [PATCH] Add peer authentication TAP test To: PostgreSQL Hackers X-Originating-IP: [10.43.161.172] X-ClientProxiedBy: EX13D23UWC002.ant.amazon.com (10.43.162.22) To EX13D03EUC003.ant.amazon.com (10.43.164.192) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --------------VFeIOijtxgu5ppPzvAXpO4EG Content-Type: text/plain; charset="UTF-8"; format=flowed Content-Transfer-Encoding: 7bit Hi hackers, During the work in [1] we created a new TAP test to test the SYSTEM_USER behavior with peer authentication. It turns out that there is currently no TAP test for the peer authentication, so we think (thanks Michael for the suggestion [2]) that it's better to split the work in [1] between "pure" SYSTEM_USER related work and the "pure" peer authentication TAP test work. That's the reason of this new thread, please find attached a patch to add a new TAP test for the peer authentication. [1]: https://www.postgresql.org/message-id/flat/7e692b8c-0b11-45db-1cad-3afc5b57409f%40amazon.com [2]: https://www.postgresql.org/message-id/YwgboqQUV1%2BY/k6z%40paquier.xyz Regards, -- Bertrand Drouvot Amazon Web Services: https://aws.amazon.com --------------VFeIOijtxgu5ppPzvAXpO4EG Content-Type: text/plain; charset="UTF-8"; name="v1-0001-peer-authentication-tap-test.patch" Content-Disposition: attachment; filename="v1-0001-peer-authentication-tap-test.patch" Content-Transfer-Encoding: base64 ZGlmZiAtLWdpdCBhL3NyYy90ZXN0L2F1dGhlbnRpY2F0aW9uL3QvMDAzX3BlZXIucGwgYi9z cmMvdGVzdC9hdXRoZW50aWNhdGlvbi90LzAwM19wZWVyLnBsCm5ldyBmaWxlIG1vZGUgMTAw NjQ0CmluZGV4IDAwMDAwMDAwMDAuLjAwNmM0NDA1YTUKLS0tIC9kZXYvbnVsbAorKysgYi9z cmMvdGVzdC9hdXRoZW50aWNhdGlvbi90LzAwM19wZWVyLnBsCkBAIC0wLDAgKzEsMTQwIEBA CisKKyMgQ29weXJpZ2h0IChjKSAyMDIyLCBQb3N0Z3JlU1FMIEdsb2JhbCBEZXZlbG9wbWVu dCBHcm91cAorCisjIFRlc3RzIGZvciBwZWVyIGF1dGhlbnRpY2F0aW9uIGFuZCB1c2VyIG5h bWUgbWFwLgorIyBUaGUgdGVzdCBpcyBza2lwcGVkIGlmIHRoZSBwbGF0Zm9ybSBkb2VzIG5v dCBzdXBwb3J0IHBlZXIgYXV0aGVudGljYXRpb24uCisKK3VzZSBzdHJpY3Q7Cit1c2Ugd2Fy bmluZ3M7Cit1c2UgUG9zdGdyZVNRTDo6VGVzdDo6Q2x1c3RlcjsKK3VzZSBQb3N0Z3JlU1FM OjpUZXN0OjpVdGlsczsKK3VzZSBUZXN0OjpNb3JlOworCisjIERlbGV0ZSBwZ19oYmEuY29u ZiBmcm9tIHRoZSBnaXZlbiBub2RlLCBhZGQgYSBuZXcgZW50cnkgdG8gaXQKKyMgYW5kIHRo ZW4gZXhlY3V0ZSBhIHJlbG9hZCB0byByZWZyZXNoIGl0Lgorc3ViIHJlc2V0X3BnX2hiYQor eworCW15ICRub2RlICAgICAgID0gc2hpZnQ7CisJbXkgJGhiYV9tZXRob2QgPSBzaGlmdDsK KworCXVubGluaygkbm9kZS0+ZGF0YV9kaXIgLiAnL3BnX2hiYS5jb25mJyk7CisJIyBqdXN0 IGZvciB0ZXN0aW5nIHB1cnBvc2VzLCB1c2UgYSBjb250aW51YXRpb24gbGluZS4KKwkkbm9k ZS0+YXBwZW5kX2NvbmYoJ3BnX2hiYS5jb25mJywgImxvY2FsIGFsbCBhbGxcXFxuICRoYmFf bWV0aG9kIik7CisJJG5vZGUtPnJlbG9hZDsKKwlyZXR1cm47Cit9CisKKyMgVGVzdCBhY2Nl c3MgZm9yIGEgc2luZ2xlIHJvbGUsIHVzZWZ1bCB0byB3cmFwIGFsbCB0ZXN0cyBpbnRvIG9u ZS4KK3N1YiB0ZXN0X3JvbGUKK3sKKyAgbG9jYWwgJFRlc3Q6OkJ1aWxkZXI6OkxldmVsID0g JFRlc3Q6OkJ1aWxkZXI6OkxldmVsICsgMTsKKworICBteSAoJG5vZGUsICRyb2xlLCAkbWV0 aG9kLCAkZXhwZWN0ZWRfcmVzKSA9IEBfOworICBteSAkc3RhdHVzX3N0cmluZyA9ICdmYWls ZWQnOworICAkc3RhdHVzX3N0cmluZyA9ICdzdWNjZXNzJyBpZiAoJGV4cGVjdGVkX3JlcyBl cSAwKTsKKworICBteSAkY29ubnN0ciA9ICJ1c2VyPSRyb2xlIjsKKyAgbXkgJHRlc3RuYW1l ID0KKyAgICAiYXV0aGVudGljYXRpb24gJHN0YXR1c19zdHJpbmcgZm9yIG1ldGhvZCAkbWV0 aG9kLCByb2xlICRyb2xlIjsKKworICBpZiAoJGV4cGVjdGVkX3JlcyBlcSAwKQorICB7Cisg ICAgJG5vZGUtPmNvbm5lY3Rfb2soJGNvbm5zdHIsICR0ZXN0bmFtZSk7CisgIH0KKyAgZWxz ZQorICB7CisgICAgICAjIE5vIGNoZWNrcyBvZiB0aGUgZXJyb3IgbWVzc2FnZSwgb25seSB0 aGUgc3RhdHVzIGNvZGUuCisgICAgICAkbm9kZS0+Y29ubmVjdF9mYWlscygkY29ubnN0ciwg JHRlc3RuYW1lKTsKKyAgfQorfQorCisjIHJldHVybiB0aGUgc2l6ZSBvZiBsb2dmaWxlIG9m ICRub2RlIGluIGJ5dGVzLgorc3ViIGdldF9sb2dfc2l6ZQoreworICBteSAoJG5vZGUpID0g QF87CisKKyAgcmV0dXJuIChzdGF0ICRub2RlLT5sb2dmaWxlKVs3XTsKK30KKworIyBmaW5k ICRwYXQgaW4gbG9nZmlsZSBvZiAkbm9kZSBhZnRlciAkb2ZmLXRoIGJ5dGUuCitzdWIgZmlu ZF9pbl9sb2cKK3sKKyAgbXkgKCRub2RlLCAkcGF0LCAkb2ZmKSA9IEBfOworCisgICRvZmYg PSAwIHVubGVzcyBkZWZpbmVkICRvZmY7CisgIG15ICRsb2cgPSBQb3N0Z3JlU1FMOjpUZXN0 OjpVdGlsczo6c2x1cnBfZmlsZSgkbm9kZS0+bG9nZmlsZSk7CisgIHJldHVybiAwIGlmIChs ZW5ndGgoJGxvZykgPD0gJG9mZik7CisKKyAgJGxvZyA9IHN1YnN0cigkbG9nLCAkb2ZmKTsK KworICByZXR1cm4gJGxvZyA9fiBtLyRwYXQvOworfQorCisjIEluaXRpYWxpemUgcHJpbWFy eSBub2RlLgorbXkgJG5vZGUgPSBQb3N0Z3JlU1FMOjpUZXN0OjpDbHVzdGVyLT5uZXcoJ3By aW1hcnknKTsKKyRub2RlLT5pbml0OworJG5vZGUtPmFwcGVuZF9jb25mKCdwb3N0Z3Jlc3Fs LmNvbmYnLCAibG9nX2Nvbm5lY3Rpb25zID0gb25cbiIpOworJG5vZGUtPnN0YXJ0OworCisj IEdldCB0aGUgc2Vzc2lvbl91c2VyIHRvIGRlZmluZSB0aGUgdXNlciBuYW1lIG1hcCB0ZXN0 LgorbXkgJHNlc3Npb25fdXNlciA9CisgICRub2RlLT5zYWZlX3BzcWwoJ3Bvc3RncmVzJywg J3NlbGVjdCBzZXNzaW9uX3VzZXInKTsKKworIyBDcmVhdGUgYSBuZXcgdXNlciBmb3IgdGhl IHVzZXIgbmFtZSBtYXAgdGVzdC4KKyRub2RlLT5zYWZlX3BzcWwoJ3Bvc3RncmVzJywKKyAg cXF7Q1JFQVRFIFVTRVIgdGVzdG1hcCRzZXNzaW9uX3VzZXJ9KTsKKworIyBTZXQgcGdfaGJh LmNvbmYgd2l0aCB0aGUgcGVlciBhdXRoZW50aWNhdGlvbi4KK3Jlc2V0X3BnX2hiYSgkbm9k ZSwgJ3BlZXInKTsKKworIyBDaGVjayB0aGF0IHBlZXIgYXV0aGVudGljYXRpb24gaXMgc3Vw cG9ydGVkIG9uIHRoaXMgcGxhdGZvcm0uCitteSAkbG9nc3RhcnQgPSBnZXRfbG9nX3NpemUo JG5vZGUpOworCiskbm9kZS0+cHNxbCgncG9zdGdyZXMnLCB1bmRlZiwgY29ubnN0ciAgPT4g InVzZXI9JHNlc3Npb25fdXNlciIpOworCisjIElmIG5vdCBzdXBwb3J0ZWQsIHRoZW4gc2tp cCB0aGUgcmVzdCBvZiB0aGUgdGVzdC4KK2lmIChmaW5kX2luX2xvZygkbm9kZSwgcXIvcGVl ciBhdXRoZW50aWNhdGlvbiBpcyBub3Qgc3VwcG9ydGVkIG9uIHRoaXMgcGxhdGZvcm0vLCAk bG9nc3RhcnQpKQoreworICAgIHBsYW4gc2tpcF9hbGwgPT4gJ3BlZXIgYXV0aGVudGljYXRp b24gaXMgbm90IHN1cHBvcnRlZCBvbiB0aGlzIHBsYXRmb3JtJzsKK30KKworIyBJdCdzIHN1 cHBvcnRlZCBzbyBsZXQncyB0ZXN0IHBlZXIgYXV0aGVudGljYXRpb24uCisjIFRoaXMgY29u bmVjdGlvbiBzaG91bGQgc3VjY2VlZC4KKyRsb2dzdGFydCA9IGdldF9sb2dfc2l6ZSgkbm9k ZSk7Cit0ZXN0X3JvbGUoJG5vZGUsICRzZXNzaW9uX3VzZXIsICdwZWVyJywgMCk7CisKK29r KCBmaW5kX2luX2xvZygKKyAgICAgICRub2RlLAorICAgICAgcXIvY29ubmVjdGlvbiBhdXRo ZW50aWNhdGVkOiBpZGVudGl0eT0iJHNlc3Npb25fdXNlciIgbWV0aG9kPXBlZXIvLCAkbG9n c3RhcnQpLAorICAgICAgImxvZ2ZpbGU6IGNvbm5lY3Rpb24gYXV0aGVudGljYXRlZCBmb3Ig bWV0aG9kIHBlZXIgYW5kIGlkZW50aXR5ICRzZXNzaW9uX3VzZXIiKTsKKworIyBUaGlzIGNv bm5lY3Rpb24gc2hvdWxkIGZhaWxlZC4KKyRsb2dzdGFydCA9IGdldF9sb2dfc2l6ZSgkbm9k ZSk7Cit0ZXN0X3JvbGUoJG5vZGUsIHFxe3Rlc3RtYXAkc2Vzc2lvbl91c2VyfSwgJ3BlZXIn LCAyKTsKKworb2soIGZpbmRfaW5fbG9nKAorICAgICAgJG5vZGUsCisgICAgICBxci9QZWVy IGF1dGhlbnRpY2F0aW9uIGZhaWxlZCBmb3IgdXNlciAidGVzdG1hcCRzZXNzaW9uX3VzZXIi LywgJGxvZ3N0YXJ0KSwKKyAgICAgICJsb2dmaWxlOiBQZWVyIGF1dGhlbnRpY2F0aW9uIGZh aWxlZCBmb3IgdXNlciB0ZXN0bWFwJHNlc3Npb25fdXNlciIpOworCisjIERlZmluZSBhIHVz ZXIgbmFtZSBtYXAuCiskbm9kZS0+YXBwZW5kX2NvbmYoJ3BnX2lkZW50LmNvbmYnLCBxcXtt eXBlZXJtYXAgJHNlc3Npb25fdXNlciB0ZXN0bWFwJHNlc3Npb25fdXNlcn0pOworCisjIFNl dCBwZ19oYmEuY29uZiB3aXRoIHRoZSBwZWVyIGF1dGhlbnRpY2F0aW9uIGFuZCB0aGUgdXNl ciBuYW1lIG1hcC4KK3Jlc2V0X3BnX2hiYSgkbm9kZSwgJ3BlZXIgbWFwPW15cGVlcm1hcCcp OworCisjIFRoaXMgY29ubmVjdGlvbiBzaG91bGQgbm93IHN1Y2NlZWQuCiskbG9nc3RhcnQg PSBnZXRfbG9nX3NpemUoJG5vZGUpOwordGVzdF9yb2xlKCRub2RlLCBxcXt0ZXN0bWFwJHNl c3Npb25fdXNlcn0sICdwZWVyJywgMCk7CisKK29rKCBmaW5kX2luX2xvZygKKyAgICAgICRu b2RlLAorICAgICAgcXIvY29ubmVjdGlvbiBhdXRoZW50aWNhdGVkOiBpZGVudGl0eT0iJHNl c3Npb25fdXNlciIgbWV0aG9kPXBlZXIvLCAkbG9nc3RhcnQpLAorICAgICAgImxvZ2ZpbGU6 IGNvbm5lY3Rpb24gYXV0aGVudGljYXRlZCBmb3IgbWV0aG9kIHBlZXIgYW5kIGlkZW50aXR5 ICRzZXNzaW9uX3VzZXIiKTsKKworb2soIGZpbmRfaW5fbG9nKAorICAgICAgJG5vZGUsCisg ICAgICBxci9jb25uZWN0aW9uIGF1dGhvcml6ZWQ6IHVzZXI9dGVzdG1hcCRzZXNzaW9uX3Vz ZXIvLCAkbG9nc3RhcnQpLAorICAgICAgImxvZ2ZpbGU6IGNvbm5lY3Rpb24gYXV0aG9yaXpl ZCBmb3IgdXNlciB0ZXN0bWFwJHNlc3Npb25fdXNlciIpOworCitkb25lX3Rlc3RpbmcoKTsK XCBObyBuZXdsaW5lIGF0IGVuZCBvZiBmaWxlCg== --------------VFeIOijtxgu5ppPzvAXpO4EG--