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 1w2u3P-000iJV-38 for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Mar 2026 16:47:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w2u3O-00CWsc-2J for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Mar 2026 16:47:30 +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 1w2u3O-00CWsS-1S for pgsql-hackers@lists.postgresql.org; Wed, 18 Mar 2026 16:47:30 +0000 Received: from mail-qv1-xf35.google.com ([2607:f8b0:4864:20::f35]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w2u3L-00000000xt6-0OAH for pgsql-hackers@lists.postgresql.org; Wed, 18 Mar 2026 16:47:29 +0000 Received: by mail-qv1-xf35.google.com with SMTP id 6a1803df08f44-89a07f66f4eso1718076d6.1 for ; Wed, 18 Mar 2026 09:47:26 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773852445; cv=none; d=google.com; s=arc-20240605; b=P+1KHuGiHEWUdXV2nJp8oL9ecC86x6XSeKgP4wa0Sk0KWFpaHg85KAF9n708qMYosL RCXnVOPyf7tPDejjwIQoQQWR6Jdlf8hhOHfObwGD66Su8dUq793COX1zAIBBPj6S8VAG 5YadlJL55sL36MoL8ZQrBbi+zvliFsTrR8Kb6+h/70ZNoBFFj1kxCIXSOH3ub8ARPAMx sPvn2VmvQuzWaqf+Ug3TpNzu2xv29OsRJPNDVAhx88KWmgBP59kzo2NWKHahbN91q2BH UZozCxexbEu0iIKbd4Cn+ZcFBFV3ULgKo1YwlSKdmi7wpVqRCJr16inhGfPe7xrJoNzG C7vg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=zLtQtsSnFQT9t8D4vlwnsqsjWMCHk7xBD281JNKj99c=; fh=6B80WXUH1dJzE5FLlU/lPUv/eBSIlXoac7HTdBGm8/U=; b=aVU8XRP9kwYy190Hjtm6qx4BdmehSO4c0mBWiQuorMTbao1KmIyB19peVhFzLVn7xO CC/gMwnuXSyBLCcSyoZvF9qmo9JMDI51w8y5pPlgp2d73BrPQrOxaH+MgumlmdIOHbpY I6KnezkggaaZ9XcLlxtEZYrRkK2u8WHF4LzkoCW5foZ4s3Pd8hKoWZsBpbGX6bVXcXd0 s5VBeQoMaEBIm7UYtkULGntC5cgHKcH4fp2xqQTkKjRQiS4iwlSdS9oyEs6jfsE6x20W lhgMdQdWogv4iTtwbp3YyxhzuEE8fy4slJeJeXV7Oavs/ZdzzlVsCxb0kusxkWWzQgEl 3QpQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1773852445; x=1774457245; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=zLtQtsSnFQT9t8D4vlwnsqsjWMCHk7xBD281JNKj99c=; b=Tvt2eBp7WAZMNKDJ9cFotf8Uhe5u/RXpUrwOYSxeRWZhH1Y6KRdU1EofPrNittMq7H qyWLiCb5xOFNdRMUzSIUoUtsX6UyOOrcA26+YzfAKTdXwgMANLbgWRTCKKDwcAiBNUxg HYCSfxtsN153vhmlJztp6/YYfBxjvt72DLrbjA2qxt74M0HgswaSm6I7JjgEfnFWWc2z LHGYFDagjQtk7Gh27DXYMY6SMo9gd1tAhIh6B6bd8JgA/ShJTA+UxagPg6Qu+49Ky3QL B/QbZAvNUJasQ7qT5TTlXjn9/TKNmaUJsmTvJSSZKbdSJ/adUVewGIavyVIhl2gddYXz rfcw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773852445; x=1774457245; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=zLtQtsSnFQT9t8D4vlwnsqsjWMCHk7xBD281JNKj99c=; b=IEIfZ30yCwY3RzGPgUADKfbpKOziQJ4Vu+Wu3v1Gv/0kzknwQOwz2YKA1Ef+TZIr+Z qEiQlirvIFWdS3yHn9Ye3IBQCXVxB0IZTl8an6ORWZzG8q/3np8Tpb2RQy9eQi3ffN0E PuGDblW6lOG+fuC3xExHwPcAyj5DpWhN9LOXEAmLayAsMYp9gr2e64S4r+eu38aRdFSW 3bzqH3hJ0MGSutVuGU3zg/TpoQM/gjyTUWH8cSCTKqI3tP6TnEgmLHWZzq9bgFmkh6Aw JalGX+TqL1FbOaHhZ5d/qX0xfoVrGGpk+L3jsEMsOZx88ELKXDufG993Ifp8GgBAT+h3 JdIA== X-Gm-Message-State: AOJu0YzbahFSheCX+u5EwBC+xrdIc3zLWLHYfTVeYd7DDBLw0mrkJ4pH ZEFrTm+oOrJbPsWVFNnc8v0avZzPn4uo/bhTuWDjlzuaQV90o6W3LcapNTPCTFEckRdAj1v2SDJ P01wfmYToWBavxXXOZPJQ4BBcI6k5AKZ+/xKszkH0 X-Gm-Gg: ATEYQzy1/D58BVrpn1xT52Y0WybRSqykUV+Kxkju4NduRJ97IACxacxQLUBZUTtjvjP 4oSEfMiMtc3CRuF/+7LFRotn7nEDCpz9LqDRklXDnc8X+WoCgARLWU6VGHqT6TZA+LBMHKrcfRa Zj5mKHbNRdW7O01tEpKmcOIFGshgvVpWKfcSlbrY5R8Df+Ig7pAUJV54D79NkKGi1ADtO4Z8Q6W PDikR1zHft0/FMzVlHawby+F5lMayh4uV3Tbs7CSLyBJ2zvR/HQJzFf5fmq8vo9XZm1cJf7/bXV GLI/XpNhCg== X-Received: by 2002:a05:6214:d6a:b0:89c:44f9:e87b with SMTP id 6a1803df08f44-89c6b5af971mr61738476d6.49.1773852444978; Wed, 18 Mar 2026 09:47:24 -0700 (PDT) MIME-Version: 1.0 References: <202601241015.y5uvxd7oxnfs@alvherre.pgsql> In-Reply-To: From: Jacob Champion Date: Wed, 18 Mar 2026 09:47:14 -0700 X-Gm-Features: AaiRm50osqhsS7lQseK0aI6P7v3RTdWaTumnVsYenMqmkzzk__Yvh3faieJcTBQ Message-ID: Subject: Re: unclear OAuth error message To: =?UTF-8?Q?=C3=81lvaro_Herrera?= Cc: Pg Hackers , Zsolt Parragi Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Jan 26, 2026 at 2:17=E2=80=AFPM Jacob Champion wrote: > For that code path I suspect we could get rid of the entire message, > because of what you mentioned later: auth_failed() is already going to > give us that. The validator can log what's important if needed, or > not. We could add some DEBUGs, maybe, so that you can still figure out > what's going on if a validator fails silently? I only just remembered that this is exactly what logdetail is designed to do. It's passed in from CheckSASLAuth, but OAuth doesn't make use of it. (My original patchset carried a TODO for this for a long time, but I lost it at some point...) I have a parallel patchset that also needs logdetail, so this fix can piggyback on some of that work. --Jacob