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 1nhQB6-0001JJ-Tb for pgadmin-hackers@arkaria.postgresql.org; Thu, 21 Apr 2022 06:20:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nhQB5-00008g-34 for pgadmin-hackers@arkaria.postgresql.org; Thu, 21 Apr 2022 06:20:31 +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 1nhQB4-00008X-R9 for pgadmin-hackers@lists.postgresql.org; Thu, 21 Apr 2022 06:20:30 +0000 Received: from mail-yw1-x112b.google.com ([2607:f8b0:4864:20::112b]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nhQB2-0001W9-N2 for pgadmin-hackers@postgresql.org; Thu, 21 Apr 2022 06:20:30 +0000 Received: by mail-yw1-x112b.google.com with SMTP id 00721157ae682-2f18982c255so41667827b3.1 for ; Wed, 20 Apr 2022 23:20:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=sRSlYuoXRh6GNQD8UDGmTNOD3pB9gqW/KYHhVEBLTNY=; b=H43eEnLVi5jOQ2KgOCJf+RyLfBxablnkdYs2TqoSfFM+oU44FRMXXd4hRZ9rqPTaVZ 8ZZz9svK3twZFkh3sGGRNOjuruof+7nokF31NWsdZbSrWXgLV1KNw+bCmV7dp6ZWkxL7 xkFNJJ4eCTue3Wpgr4Nt8Gy2H9SzihzjzMzf20Ji5gJR8c6ejKApyVT0Fyfv+gUzMtvx XhXVRBKtC3tNrSY6Y8CCyVR6B0yRoczV5I6kQNU0tiA83dPoF1qb4v/jnNjfLc3Btf6x rApEnHSYFH8ctyENpwS0dOKsrQH0v7oRhivGO9AUGwX1R6GNIe+m13yHF84LWJMgRzSW sceQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=sRSlYuoXRh6GNQD8UDGmTNOD3pB9gqW/KYHhVEBLTNY=; b=uhPjxLTKR93CQEMUPsWRR2Ga/L4ousCpw+KCXghmyQxHQMXtIOVhLVk5Q0cKEgFYok NeAucB1nWL0abjSjzFEwUpv57OCoTrjFPuJjHZkv4i5LFZ/Q6zI+gdzma82wqN5/bz58 BCd4x/e1s2S9Kz3BXVMGbmdu0uWI2rtA2U3tm7rp/k1ucLwflGwSyICxew//Sa9Mz44D eJkQP98PXu5f0QUdvgnqm4vGqI8LvAm7Qp0WOTHPODPz3UZFergw9Nmw9aVzvUBALrs1 Cz666kq6gaVfWq7CWso4fM8tsG0TnRsmkhKDX9q124XxQKf2F3ql5x/etCdiOyanIPTw m6Fg== X-Gm-Message-State: AOAM531XF0MNgl3JQN8DMRCw7kon1Sh8xzobw2hgyK2Vr9iLwTP5bdCD s8/edb/cx1CbevECrkOoX+xH14eJXZU81Da7g1W54YB/6wEa92n2FFEXOSu52nTMQ1bpNHRHFNP P70OUZed7LWtF7T/suhECwbXIXz1y5pONxZUVcss4gRMJyBc3Fyhbsp2qEByp3GVrJW9nvhlxBA vgfGvYYFw5V5iTmF9KXNLX1A/Pfrm7Sv7PYxnescAZfK8bAIHY2JujbZkCio1kGtg= X-Google-Smtp-Source: ABdhPJx9WrUspYsfrYahBtMJZDWd1F+xi4krGy9hskW6aP7GNcYJLpa8J3vBPtjqzLt1W/bRRJhhDfq2jNRuUhEOgF0= X-Received: by 2002:a81:d512:0:b0:2f1:8982:3b4a with SMTP id i18-20020a81d512000000b002f189823b4amr19485272ywj.123.1650522026126; Wed, 20 Apr 2022 23:20:26 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Yogesh Mahajan Date: Thu, 21 Apr 2022 11:49:49 +0530 Message-ID: Subject: Re: Feature #7325 - Support for Azure AD OAUTH2 authentication To: pgadmin-hackers Content-Type: multipart/mixed; boundary="0000000000001004b005dd241b40" 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 --0000000000001004b005dd241b40 Content-Type: multipart/alternative; boundary="0000000000001004ae05dd241b3e" --0000000000001004ae05dd241b3e Content-Type: text/plain; charset="UTF-8" Hi, Please ignore the previous patch. Here is the updated one. Thanks, Yogesh Mahajan EnterpriseDB On Thu, Apr 21, 2022 at 11:12 AM Yogesh Mahajan < yogesh.mahajan@enterprisedb.com> wrote: > Hi, > > Please find the attached patch which adds support for Azure AD > authentication method. > > Thanks, > Yogesh Mahajan > EnterpriseDB > --0000000000001004ae05dd241b3e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

Please= ignore the previous patch. Here is the updated one.

Thanks,
Yogesh Mahajan
= EnterpriseDB


On Thu, Apr 21, 2022 at 11:12 AM Yogesh Mahajan <yogesh.mahajan@enterprisedb.com&= gt; wrote:
Hi,
<= div class=3D"gmail_default" style=3D"font-family:verdana,sans-serif;font-si= ze:small">
Please find the attached=C2=A0patch which=C2= =A0adds support=C2=A0for Azure AD authentication method.
Thanks,
Yogesh Mahajan=
EnterpriseDB
--0000000000001004ae05dd241b3e-- --0000000000001004b005dd241b40 Content-Type: application/octet-stream; name="RM_7325_v2.patch" Content-Disposition: attachment; filename="RM_7325_v2.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_l28m6adq0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2F1dGhlbnRpY2F0ZS9vYXV0aDIucHkgYi93ZWIvcGdh ZG1pbi9hdXRoZW50aWNhdGUvb2F1dGgyLnB5CmluZGV4IDkzNWQxMTBhNy4uMDdkMzk4MzgwIDEw MDY0NAotLS0gYS93ZWIvcGdhZG1pbi9hdXRoZW50aWNhdGUvb2F1dGgyLnB5CisrKyBiL3dlYi9w Z2FkbWluL2F1dGhlbnRpY2F0ZS9vYXV0aDIucHkKQEAgLTg4LDYgKzg4LDcgQEAgY2xhc3MgT0F1 dGgyQXV0aGVudGljYXRpb24oQmFzZUF1dGhlbnRpY2F0aW9uKToKICAgICBvYXV0aF9vYmogPSBP QXV0aChGbGFzayhfX25hbWVfXykpCiAgICAgb2F1dGgyX2NsaWVudHMgPSB7fQogICAgIG9hdXRo Ml9jb25maWcgPSB7fQorICAgIGVtYWlsX2tleXMgPSBbJ21haWwnLCAnZW1haWwnXQogCiAgICAg ZGVmIF9faW5pdF9fKHNlbGYpOgogICAgICAgICBmb3Igb2F1dGgyX2NvbmZpZyBpbiBjb25maWcu T0FVVEgyX0NPTkZJRzoKQEAgLTExOSw3ICsxMjAsMTEgQEAgY2xhc3MgT0F1dGgyQXV0aGVudGlj YXRpb24oQmFzZUF1dGhlbnRpY2F0aW9uKToKIAogICAgIGRlZiBsb2dpbihzZWxmLCBmb3JtKToK ICAgICAgICAgcHJvZmlsZSA9IHNlbGYuZ2V0X3VzZXJfcHJvZmlsZSgpCi0gICAgICAgIGlmICdl bWFpbCcgbm90IGluIHByb2ZpbGUgb3Igbm90IHByb2ZpbGVbJ2VtYWlsJ106CisgICAgICAgIGVt YWlsX2tleSA9IFwKKyAgICAgICAgICAgIFt2YWx1ZSBmb3IgdmFsdWUgaW4gc2VsZi5lbWFpbF9r ZXlzIGlmIHZhbHVlIGluIHByb2ZpbGUua2V5cygpXQorICAgICAgICBlbWFpbCA9IHByb2ZpbGVb ZW1haWxfa2V5WzBdXSBpZiAobGVuKGVtYWlsX2tleSkgPiAwKSBlbHNlIE5vbmUKKworICAgICAg ICBpZiBub3QgZW1haWwgb3IgZW1haWwgPT0gJyc6CiAgICAgICAgICAgICBjdXJyZW50X2FwcC5s b2dnZXIuZXhjZXB0aW9uKAogICAgICAgICAgICAgICAgICJBbiBlbWFpbCBpZCBpcyByZXF1aXJl ZCB0byBsb2dpbiBpbnRvIHBnQWRtaW4uICIKICAgICAgICAgICAgICAgICAiUGxlYXNlIHVwZGF0 ZSB5b3VyIE9hdXRoMiBwcm9maWxlLiIKQEAgLTEyOCwxMCArMTMzLDEwIEBAIGNsYXNzIE9BdXRo MkF1dGhlbnRpY2F0aW9uKEJhc2VBdXRoZW50aWNhdGlvbik6CiAgICAgICAgICAgICAgICAgIkFu IGVtYWlsIGlkIGlzIHJlcXVpcmVkIHRvIGxvZ2luIGludG8gcGdBZG1pbi4gIgogICAgICAgICAg ICAgICAgICJQbGVhc2UgdXBkYXRlIHlvdXIgT2F1dGgyIHByb2ZpbGUuIikKIAotICAgICAgICB1 c2VyLCBtc2cgPSBzZWxmLl9fYXV0b19jcmVhdGVfdXNlcihwcm9maWxlKQorICAgICAgICB1c2Vy LCBtc2cgPSBzZWxmLl9fYXV0b19jcmVhdGVfdXNlcihlbWFpbCkKICAgICAgICAgaWYgdXNlcjoK ICAgICAgICAgICAgIHVzZXIgPSBkYi5zZXNzaW9uLnF1ZXJ5KFVzZXIpLmZpbHRlcl9ieSgKLSAg ICAgICAgICAgICAgICB1c2VybmFtZT1wcm9maWxlWydlbWFpbCddLCBhdXRoX3NvdXJjZT1PQVVU SDIpLmZpcnN0KCkKKyAgICAgICAgICAgICAgICB1c2VybmFtZT1lbWFpbCwgYXV0aF9zb3VyY2U9 T0FVVEgyKS5maXJzdCgpCiAgICAgICAgICAgICBjdXJyZW50X2FwcC5sb2dpbl9tYW5hZ2VyLmxv Z291dF92aWV3ID0gXAogICAgICAgICAgICAgICAgIE9BdXRoMkF1dGhlbnRpY2F0aW9uLkxPR09V VF9WSUVXCiAgICAgICAgICAgICByZXR1cm4gbG9naW5fdXNlcih1c2VyKSwgTm9uZQpAQCAtMTYx LDE3ICsxNjYsMTcgQEAgY2xhc3MgT0F1dGgyQXV0aGVudGljYXRpb24oQmFzZUF1dGhlbnRpY2F0 aW9uKToKICAgICAgICAgcmV0dXJuIEZhbHNlLCBzZWxmLm9hdXRoMl9jbGllbnRzWwogICAgICAg ICAgICAgc2VsZi5vYXV0aDJfY3VycmVudF9jbGllbnRdLmF1dGhvcml6ZV9yZWRpcmVjdChyZWRp cmVjdF91cmwpCiAKLSAgICBkZWYgX19hdXRvX2NyZWF0ZV91c2VyKHNlbGYsIHJlc3ApOgorICAg IGRlZiBfX2F1dG9fY3JlYXRlX3VzZXIoc2VsZiwgZW1haWwpOgogICAgICAgICBpZiBjb25maWcu T0FVVEgyX0FVVE9fQ1JFQVRFX1VTRVI6Ci0gICAgICAgICAgICB1c2VyID0gVXNlci5xdWVyeS5m aWx0ZXJfYnkodXNlcm5hbWU9cmVzcFsnZW1haWwnXSwKKyAgICAgICAgICAgIHVzZXIgPSBVc2Vy LnF1ZXJ5LmZpbHRlcl9ieSh1c2VybmFtZT1lbWFpbCwKICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICBhdXRoX3NvdXJjZT1PQVVUSDIpLmZpcnN0KCkKICAgICAgICAgICAg IGlmIG5vdCB1c2VyOgogICAgICAgICAgICAgICAgIHJldHVybiBjcmVhdGVfdXNlcih7Ci0gICAg ICAgICAgICAgICAgICAgICd1c2VybmFtZSc6IHJlc3BbJ2VtYWlsJ10sCi0gICAgICAgICAgICAg ICAgICAgICdlbWFpbCc6IHJlc3BbJ2VtYWlsJ10sCisgICAgICAgICAgICAgICAgICAgICd1c2Vy bmFtZSc6IGVtYWlsLAorICAgICAgICAgICAgICAgICAgICAnZW1haWwnOiBlbWFpbCwKICAgICAg ICAgICAgICAgICAgICAgJ3JvbGUnOiAyLAogICAgICAgICAgICAgICAgICAgICAnYWN0aXZlJzog VHJ1ZSwKICAgICAgICAgICAgICAgICAgICAgJ2F1dGhfc291cmNlJzogT0FVVEgyCiAgICAgICAg ICAgICAgICAgfSkKIAotICAgICAgICByZXR1cm4gVHJ1ZSwgeyd1c2VybmFtZSc6IHJlc3BbJ2Vt YWlsJ119CisgICAgICAgIHJldHVybiBUcnVlLCB7J3VzZXJuYW1lJzogZW1haWx9Cg== --0000000000001004b005dd241b40--