| From: | Jacob Champion <jacob(dot)champion(at)enterprisedb(dot)com> |
|---|---|
| To: | Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com> |
| Cc: | Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>, Daniel Gustafsson <daniel(at)yesql(dot)se>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Michael Paquier <michael(at)paquier(dot)xyz>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: Improve OAuth discovery logging |
| Date: | 2026-03-17 00:24:58 |
| Message-ID: | CAOYmi+nsK1dSXaB+oicoyA6kM9ymygCLhSiKtkg1ph_P1uhYOQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Mar 16, 2026 at 12:45 PM Zsolt Parragi
<zsolt(dot)parragi(at)percona(dot)com> wrote:
> I tried to figure out if this is fine or not, but isn't it the same as
> the existing ereport(ERROR, ...) calls everywhere in the sasl/scram
> code?
Those are *also* not good, IMHO; they're what I had in mind when I
said "it's unusual/invisible". (ERROR is upgraded to FATAL here, so
they're also misleading.) OAuth inherited a few of those from SCRAM to
avoid divergent behavior for protocol violations, but I don't really
want to lock that usage into the SASL architecture by myself,
especially not for normal operation. CheckSASLAuth should ideally have
control over the logic flow.
(It might be nice to make it possible to throw ERRORs from inside
authentication code without bypassing the top level. Then maybe we
could square that with our treatment of logdetail et al. But we'd have
to decide how we want protocol errors to interact with the hook.)
On Mon, Mar 16, 2026 at 11:14 AM Jacob Champion
<jacob(dot)champion(at)enterprisedb(dot)com> wrote:
> I'm working on a three-patch set to add FATAL_CLIENT_ONLY, the new
> abandoned state, and the log fix making use of both.
Attached as v8.
--Jacob
| Attachment | Content-Type | Size |
|---|---|---|
| v8-0001-Add-FATAL_CLIENT_ONLY-to-ereport-elog.patch | application/octet-stream | 3.0 KB |
| v8-0003-oauth-Don-t-log-discovery-connections-by-default.patch | application/octet-stream | 4.6 KB |
| v8-0002-sasl-Allow-backend-mechanisms-to-abandon-exchange.patch | application/octet-stream | 8.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Haibo Yan | 2026-03-17 00:28:02 | Re: Eliminating SPI / SQL from some RI triggers - take 3 |
| Previous Message | Tomas Vondra | 2026-03-17 00:15:23 | Re: EXPLAIN: showing ReadStream / prefetch stats |