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 1nhPaj-0007vr-1G for pgadmin-hackers@arkaria.postgresql.org; Thu, 21 Apr 2022 05:42:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nhPah-0007rO-Qs for pgadmin-hackers@arkaria.postgresql.org; Thu, 21 Apr 2022 05:42:55 +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 1nhPah-0007pH-JQ for pgadmin-hackers@lists.postgresql.org; Thu, 21 Apr 2022 05:42:55 +0000 Received: from mail-yb1-xb2b.google.com ([2607:f8b0:4864:20::b2b]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nhPae-0007qn-Fa for pgadmin-hackers@postgresql.org; Thu, 21 Apr 2022 05:42:54 +0000 Received: by mail-yb1-xb2b.google.com with SMTP id m132so6826145ybm.4 for ; Wed, 20 Apr 2022 22:42:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=mime-version:from:date:message-id:subject:to; bh=94R1XnUSiR/ve8NrlLYvjhVRCr6g+BMSFrLB5GIBK+0=; b=OkVZdK64nDEO8KXeYYPnCa0i8HJ5DFMyLWKdr7mujmChz0aIr6e/VOE754xnBTtbZ0 p5pqpu6DlKA+I3/Vzdvy6OsGKVlpdyuU5AI4cHNYdAovCCZUsV7YsWmjecLgZFRSI5LS qQ8o7MjwVfd21Twkptbc93pJRuAHFedVjDuPI/P+2XZRrPY3r8BKnGtP7jMH2C5B7pSt JYwZpd/TYxosjxzbcZnktWdP2Y93kU60xh6tfb587k7NQzN/ECyfmRfOXPFVk5ahqilN Eb7Q3dT+Qj+OoLii6PUng4KYaJNOz2zqh+KCoxQnEKFDXsBlvQS5bV9ldzxxoDv7qZ2r ZU8w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=94R1XnUSiR/ve8NrlLYvjhVRCr6g+BMSFrLB5GIBK+0=; b=7nVCjhjOhBx7NlUgWTVbhhOogkxShzsFhgrRcRA9Ceqd5alrL+7qb45DbZNUf4VXWp D8o5RiPukZO597rnMsS206zAPz/+prnw9L2wilO/rsXvQTP7R2SvLvKJmB99Ef530eCy SqxM0Cw/chu7W6KdXj7De9S6B8qN2QBWhHeus+1s5qw6Vl+9Rx7+83Oq7WBBnwnINh31 JSOrzyeUP4ZraTxM3LVSRrsfS1CSkmJdlchjc8YuHmU5hW5PiriocdIQsX3LgnKxNW5y wAgQbXkRqKatC/zu8hxA+j12C4esI2ZZXszQEDDz91aZkWL+pHpftDDMQoOfMSuxtXwI oIdQ== X-Gm-Message-State: AOAM531200h1a8WffyolLdkk1nxgX4m59YYFD6aqA9dSSvzbAHS8lVAm xip0JSKdMRLrrhpBHeaCntu1GmtPubUlBz7Ug+P0ep7OR8T0A0shD1vfr6jFK8kiMrTbcxcLdts 6rhiWisa8Z3sWJjvOdqroNtmaW0mzOg1tAxj4aR+jBjYtj6uIfRVMOf4ZaCCmucSGETsuX0eNNP f/IOdi6R8W0za1tUfxNnJk7Ho1BizuatkkZpvxiPJPEKUcsql++MueLfPEi9sKc3Q= X-Google-Smtp-Source: ABdhPJytU8W9XPsUxGr8Alax3iADg22IEWunzcxg60BUXClhsYf5HQidee0OquEdtePWK8zi4KV7Zr/GHzpFUZuoQa8= X-Received: by 2002:a5b:c51:0:b0:641:15b5:40fc with SMTP id d17-20020a5b0c51000000b0064115b540fcmr22572063ybr.19.1650519771227; Wed, 20 Apr 2022 22:42:51 -0700 (PDT) MIME-Version: 1.0 From: Yogesh Mahajan Date: Thu, 21 Apr 2022 11:12:15 +0530 Message-ID: Subject: Feature #7325 - Support for Azure AD OAUTH2 authentication To: pgadmin-hackers Content-Type: multipart/mixed; boundary="000000000000aaed4905dd2394f7" X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000aaed4905dd2394f7 Content-Type: multipart/alternative; boundary="000000000000aaed4705dd2394f5" --000000000000aaed4705dd2394f5 Content-Type: text/plain; charset="UTF-8" Hi, Please find the attached patch which adds support for Azure AD authentication method. Thanks, Yogesh Mahajan EnterpriseDB --000000000000aaed4705dd2394f5 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

Please= find the attached=C2=A0patch which=C2=A0adds support=C2=A0for Azure AD aut= hentication method.

Thanks,
Yogesh Mahajan
EnterpriseDB
--000000000000aaed4705dd2394f5-- --000000000000aaed4905dd2394f7 Content-Type: application/octet-stream; name="RM_7325_v1.patch" Content-Disposition: attachment; filename="RM_7325_v1.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_l28ktxnt0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2F1dGhlbnRpY2F0ZS9vYXV0aDIucHkgYi93ZWIvcGdh ZG1pbi9hdXRoZW50aWNhdGUvb2F1dGgyLnB5CmluZGV4IDkzNWQxMTBhNy4uNzEzNGYzZWEyIDEw MDY0NAotLS0gYS93ZWIvcGdhZG1pbi9hdXRoZW50aWNhdGUvb2F1dGgyLnB5CisrKyBiL3dlYi9w Z2FkbWluL2F1dGhlbnRpY2F0ZS9vYXV0aDIucHkKQEAgLTExOSw3ICsxMTksMTQgQEAgY2xhc3Mg T0F1dGgyQXV0aGVudGljYXRpb24oQmFzZUF1dGhlbnRpY2F0aW9uKToKIAogICAgIGRlZiBsb2dp bihzZWxmLCBmb3JtKToKICAgICAgICAgcHJvZmlsZSA9IHNlbGYuZ2V0X3VzZXJfcHJvZmlsZSgp Ci0gICAgICAgIGlmICdlbWFpbCcgbm90IGluIHByb2ZpbGUgb3Igbm90IHByb2ZpbGVbJ2VtYWls J106CisgICAgICAgIGVtYWlsID0gTm9uZQorICAgICAgICBpZiAnZW1haWwnIGluIHByb2ZpbGUg b3IgJ21haWwnIGluIHByb2ZpbGU6CisgICAgICAgICAgICBpZiBwcm9maWxlWydlbWFpbCddOgor ICAgICAgICAgICAgICAgIGVtYWlsID0gcHJvZmlsZVsnZW1haWwnXQorICAgICAgICAgICAgZWxz ZToKKyAgICAgICAgICAgICAgICBlbWFpbCA9IHByb2ZpbGVbJ21haWwnXQorCisgICAgICAgIGlm IG5vdCBlbWFpbCBvciBlbWFpbCA9PSAnJzoKICAgICAgICAgICAgIGN1cnJlbnRfYXBwLmxvZ2dl ci5leGNlcHRpb24oCiAgICAgICAgICAgICAgICAgIkFuIGVtYWlsIGlkIGlzIHJlcXVpcmVkIHRv IGxvZ2luIGludG8gcGdBZG1pbi4gIgogICAgICAgICAgICAgICAgICJQbGVhc2UgdXBkYXRlIHlv dXIgT2F1dGgyIHByb2ZpbGUuIgpAQCAtMTI4LDEwICsxMzUsMTAgQEAgY2xhc3MgT0F1dGgyQXV0 aGVudGljYXRpb24oQmFzZUF1dGhlbnRpY2F0aW9uKToKICAgICAgICAgICAgICAgICAiQW4gZW1h aWwgaWQgaXMgcmVxdWlyZWQgdG8gbG9naW4gaW50byBwZ0FkbWluLiAiCiAgICAgICAgICAgICAg ICAgIlBsZWFzZSB1cGRhdGUgeW91ciBPYXV0aDIgcHJvZmlsZS4iKQogCi0gICAgICAgIHVzZXIs IG1zZyA9IHNlbGYuX19hdXRvX2NyZWF0ZV91c2VyKHByb2ZpbGUpCisgICAgICAgIHVzZXIsIG1z ZyA9IHNlbGYuX19hdXRvX2NyZWF0ZV91c2VyKGVtYWlsKQogICAgICAgICBpZiB1c2VyOgogICAg ICAgICAgICAgdXNlciA9IGRiLnNlc3Npb24ucXVlcnkoVXNlcikuZmlsdGVyX2J5KAotICAgICAg ICAgICAgICAgIHVzZXJuYW1lPXByb2ZpbGVbJ2VtYWlsJ10sIGF1dGhfc291cmNlPU9BVVRIMiku Zmlyc3QoKQorICAgICAgICAgICAgICAgIHVzZXJuYW1lPWVtYWlsLCBhdXRoX3NvdXJjZT1PQVVU SDIpLmZpcnN0KCkKICAgICAgICAgICAgIGN1cnJlbnRfYXBwLmxvZ2luX21hbmFnZXIubG9nb3V0 X3ZpZXcgPSBcCiAgICAgICAgICAgICAgICAgT0F1dGgyQXV0aGVudGljYXRpb24uTE9HT1VUX1ZJ RVcKICAgICAgICAgICAgIHJldHVybiBsb2dpbl91c2VyKHVzZXIpLCBOb25lCkBAIC0xNjEsMTcg KzE2OCwxNyBAQCBjbGFzcyBPQXV0aDJBdXRoZW50aWNhdGlvbihCYXNlQXV0aGVudGljYXRpb24p OgogICAgICAgICByZXR1cm4gRmFsc2UsIHNlbGYub2F1dGgyX2NsaWVudHNbCiAgICAgICAgICAg ICBzZWxmLm9hdXRoMl9jdXJyZW50X2NsaWVudF0uYXV0aG9yaXplX3JlZGlyZWN0KHJlZGlyZWN0 X3VybCkKIAotICAgIGRlZiBfX2F1dG9fY3JlYXRlX3VzZXIoc2VsZiwgcmVzcCk6CisgICAgZGVm IF9fYXV0b19jcmVhdGVfdXNlcihzZWxmLCBlbWFpbCk6CiAgICAgICAgIGlmIGNvbmZpZy5PQVVU SDJfQVVUT19DUkVBVEVfVVNFUjoKLSAgICAgICAgICAgIHVzZXIgPSBVc2VyLnF1ZXJ5LmZpbHRl cl9ieSh1c2VybmFtZT1yZXNwWydlbWFpbCddLAorICAgICAgICAgICAgdXNlciA9IFVzZXIucXVl cnkuZmlsdGVyX2J5KHVzZXJuYW1lPWVtYWlsLAogICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIGF1dGhfc291cmNlPU9BVVRIMikuZmlyc3QoKQogICAgICAgICAgICAgaWYg bm90IHVzZXI6CiAgICAgICAgICAgICAgICAgcmV0dXJuIGNyZWF0ZV91c2VyKHsKLSAgICAgICAg ICAgICAgICAgICAgJ3VzZXJuYW1lJzogcmVzcFsnZW1haWwnXSwKLSAgICAgICAgICAgICAgICAg ICAgJ2VtYWlsJzogcmVzcFsnZW1haWwnXSwKKyAgICAgICAgICAgICAgICAgICAgJ3VzZXJuYW1l JzogZW1haWwsCisgICAgICAgICAgICAgICAgICAgICdlbWFpbCc6IGVtYWlsLAogICAgICAgICAg ICAgICAgICAgICAncm9sZSc6IDIsCiAgICAgICAgICAgICAgICAgICAgICdhY3RpdmUnOiBUcnVl LAogICAgICAgICAgICAgICAgICAgICAnYXV0aF9zb3VyY2UnOiBPQVVUSDIKICAgICAgICAgICAg ICAgICB9KQogCi0gICAgICAgIHJldHVybiBUcnVlLCB7J3VzZXJuYW1lJzogcmVzcFsnZW1haWwn XX0KKyAgICAgICAgcmV0dXJuIFRydWUsIHsndXNlcm5hbWUnOiBlbWFpbH0K --000000000000aaed4905dd2394f7--