Client authentication via OAuth 2.0

Edit
ID 4412
Title Client authentication via OAuth 2.0
CI (CFBot) Summary
Stats (from CFBot) Patch count: 1, First patch: +0−0, All patches: +0−0
Topic Security
Tags
Created 2023-06-27 20:30:11
Last modified 2025-07-09 21:06:35 (3 months ago)
Latest email 2025-08-08 16:23:30 (2 months ago)
Status
2025-03 (2025-03-01 – 2025-04-08): Committed
2025-01 (2025-01-01 – 2025-01-31): Moved to different CF
2024-11 (2024-11-01 – 2024-11-30): Moved to different CF
2024-09 (2024-09-01 – 2024-09-30): Moved to different CF
2024-07 (2024-07-01 – 2024-07-31): Moved to different CF
2024-03 (2024-03-01 – 2024-04-08): Moved to different CF
2024-01 (2024-01-01 – 2024-01-31): Moved to different CF
2023-11 (2023-11-01 – 2023-12-04): Moved to different CF
2023-09 (2023-09-01 – 2023-09-30): Moved to different CF
2023-07 (2023-07-01 – 2023-07-31): Moved to different CF
Target version
Authors Jacob Champion (jchampion)
Reviewers Peter Eisentraut (petere), Daniel Gustafsson (d_gustafsson), Antonin Houska (a.houska)Become reviewer
Committer Daniel Gustafsson (d_gustafsson)
Links
Emails
[PoC] Federated Authn/z with OAUTHBEARER
First at 2021-06-08 16:37:46 by Jacob Champion <pchampion at vmware.com>
Latest at 2025-08-08 16:23:30 by Jacob Champion <jacob.champion at enterprisedb.com>
Latest attachment (fix_installed_targets.diff) at 2025-07-18 23:31:21 from Jacob Champion <jacob.champion at enterprisedb.com>
    Attachment (fix_installed_targets.diff) at 2025-07-18 23:31:21 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: Yes)
    Attachment (v2-0001-WIP-oauth-run-Autoconf-tests-with-correct-compile.patch) at 2025-07-09 19:28:52 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: Yes)
    Attachment (WIP-oauth-run-Autoconf-tests-with-correct-compiler-f.patch) at 2025-07-09 18:39:41 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: Yes)
    Attachment (0001_oauth_ Fix_CPPFLAGS,_LDFLAGS,_LIBS_when_checking_AsyncDNS_libcurl_support.patch) at 2025-06-20 10:08:35 from Ivan Kush <ivan.kush at tantorlabs.com> (Patch: Yes)
    Attachment (0001-oauth-Correct-SSL-dependency-for-libpq-oauth.a.patch) at 2025-05-02 17:05:26 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: Yes)
    Attachment (0001-oauth-Fix-Autoconf-build-on-macOS.patch) at 2025-05-01 19:24:19 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: Yes)
    Attachment (since-v10.diff.txt) at 2025-04-30 17:59:43 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (since-v9.diff.txt) at 2025-04-29 00:10:06 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (since-v8.diff.txt) at 2025-04-22 23:41:50 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (since-v7.diff.txt) at 2025-04-21 23:19:06 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (v7-0001-oauth-Move-the-builtin-flow-into-a-separate-modul.patch) at 2025-04-18 00:47:42 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (v6-0002-oauth-rename-with-libcurl-to-with-oauth-client.patch) at 2025-04-15 00:13:35 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: Yes)
    Attachment (v5-0001-WIP-split-Device-Authorization-flow-into-dlopen-d.patch) at 2025-04-11 00:12:46 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: Yes)
    Attachment (v4-0001-WIP-split-Device-Authorization-flow-into-dlopen-d.patch) at 2025-04-09 23:08:33 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: Yes)
    Attachment (v3-0001-WIP-split-Device-Authorization-flow-into-dlopen-d.patch) at 2025-04-09 02:57:47 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: Yes)
    Attachment (v2-0001-WIP-split-Device-Authorization-flow-into-dlopen-d.patch) at 2025-04-05 00:27:46 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: Yes)
    Attachment (0002-oauth-Remove-unneeded-timeouts-from-t-002_client.patch) at 2025-04-03 18:02:03 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: Yes)
    Attachment (0001-WIP-split-Device-Authorization-flow-into-dlopen-d-mo.patch) at 2025-03-26 19:09:14 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: Yes)
    Attachment (kqueue_test.c) at 2025-03-07 17:30:52 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (0001-oauth-Use-IPv4-only-issuer-in-oauth_validator-tests.patch) at 2025-03-07 00:35:43 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Fix-OAUTH-on-NetBSD.patch) at 2025-02-28 13:43:52 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (0002-oauth-Improve-validator-docs-on-interruptibility.patch) at 2025-02-25 17:22:40 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: Yes)
    Attachment (0002-oauth-Rename-macro-to-avoid-collisions-on-Windows.patch) at 2025-02-24 09:00:25 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (structfixups.diff) at 2025-02-23 23:45:32 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (fix-gitignore.patch) at 2025-02-20 20:21:45 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: Yes)
    Attachment (v53-0002-cirrus-Temporarily-fix-libcurl-link-error.patch) at 2025-02-19 14:13:35 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (v52-0001-Add-support-for-OAUTHBEARER-SASL-mechanism.patch) at 2025-02-17 23:51:23 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (v51-0001-Add-support-for-OAUTHBEARER-SASL-mechanism.patch) at 2025-02-17 12:03:36 from Daniel Gustafsson <daniel at yesql.se> (Patch: No)
    Attachment (v50-0001-Add-OAUTHBEARER-SASL-mechanism.patch) at 2025-02-15 01:14:16 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (v49-0001-Add-OAUTHBEARER-SASL-mechanism.patch) at 2025-02-13 22:56:29 from Daniel Gustafsson <daniel at yesql.se> (Patch: No)
    Attachment (since-v47.diff.txt) at 2025-02-08 01:56:18 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (since-v46.diff.txt) at 2025-02-07 05:48:19 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (v46-0003-DO-NOT-MERGE-Add-pytest-suite-for-OAuth.patch) at 2025-02-06 22:02:43 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (v45-0004-DO-NOT-MERGE-Add-pytest-suite-for-OAuth.patch) at 2025-01-31 16:23:36 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (since-v43.diff.txt) at 2025-01-28 00:59:36 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (v43review.diff.txt) at 2025-01-27 22:49:50 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (since-v42.diff.txt) at 2025-01-21 16:46:43 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (since-v41.diff.txt) at 2025-01-17 19:02:15 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (since-v40.diff.txt) at 2025-01-13 23:21:31 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (require_auth_portion.diff.txt) at 2025-01-08 17:13:38 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: Yes)
    Attachment (async_auth_portion.diff.txt) at 2024-12-20 22:20:58 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (since-v39.diff.txt) at 2024-12-20 01:00:03 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (since-v38.diff.txt) at 2024-12-12 00:18:28 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (since-v37.diff.txt) at 2024-12-05 18:29:52 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (v37comments.diff.txt) at 2024-11-27 17:27:13 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (since-v36.diff.txt) at 2024-11-26 13:51:20 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (since-v35.diff.txt) at 2024-11-05 23:33:28 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (since-v34.diff.txt) at 2024-10-29 20:34:00 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (backend_with_oauth.txt) at 2024-10-28 13:24:00 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (since-v33.diff.txt) at 2024-10-25 18:22:07 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: Yes)
    Attachment (v33-0001-Add-OAUTHBEARER-SASL-mechanism.patch) at 2024-10-23 16:46:23 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (v32-0001-libpq-add-OAUTHBEARER-SASL-mechanism.patch) at 2024-10-23 15:46:14 from Daniel Gustafsson <daniel at yesql.se> (Patch: No)
    Attachment (v31-0001-Make-SASL-max-message-length-configurable.patch) at 2024-10-18 11:38:29 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (since-v30.diff.txt) at 2024-10-16 17:21:54 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (v4-0002-jsonapi-fully-initialize-dummy-lexer.patch.txt) at 2024-10-15 18:10:21 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: Yes)
    Attachment (v30-0001-Make-SASL-max-message-length-configurable.patch) at 2024-10-10 23:08:50 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: Yes)
    Attachment (v29-0004-Review-comments-2024-09-11.patch) at 2024-09-11 13:44:37 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (since-v27.diff.txt) at 2024-09-03 20:56:07 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (since-v26.diff.txt) at 2024-08-28 16:31:07 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (v26-0001-common-jsonapi-support-libpq-as-a-client.patch) at 2024-08-13 21:11:56 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: Yes)
    Attachment (since-v24.diff.txt) at 2024-08-05 17:53:24 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (since-v23.diff.txt) at 2024-07-10 00:05:18 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (since-v22.diff.txt) at 2024-07-03 17:02:01 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (v22-0004-Review-comments.patch) at 2024-03-28 22:34:02 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (since-v20.diff.txt) at 2024-03-22 18:21:19 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (since-v19.diff.txt) at 2024-03-11 22:51:24 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (since-v18.diff.txt) at 2024-03-01 17:46:27 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (since-v17.diff.txt) at 2024-03-01 01:08:01 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (v17_review_suggestions.txt) at 2024-02-28 17:40:23 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (since-v16.diff.txt) at 2024-02-28 14:05:52 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (since-v15.diff.txt) at 2024-02-24 01:01:28 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (since-v14.diff.txt) at 2024-02-22 14:08:41 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (since-v13.diff.txt) at 2024-02-21 01:00:28 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: No)
    Attachment (since-v12.diff.txt) at 2023-11-08 19:00:18 from Jacob Champion <champion.p at gmail.com> (Patch: No)
    Attachment (since-v11.diff.txt) at 2023-09-06 22:11:23 from Jacob Champion <jchampion at timescale.com> (Patch: No)
    Attachment (since-v10.diff.txt) at 2023-08-30 22:57:39 from Jacob Champion <jchampion at timescale.com> (Patch: No)
    Attachment (since-v9.diff.txt) at 2023-07-26 16:43:14 from Jacob Champion <jchampion at timescale.com> (Patch: No)
    Attachment (since-v8.diff.txt) at 2023-07-17 23:55:06 from Jacob Champion <jchampion at timescale.com> (Patch: No)
    Attachment (since-v7.diff.txt) at 2023-05-19 22:01:11 from Jacob Champion <jchampion at timescale.com> (Patch: No)
    Attachment (since-v5.diff.txt) at 2023-04-27 17:35:20 from Jacob Champion <jchampion at timescale.com> (Patch: No)
    Attachment (v6-0004-common-jsonapi-support-FRONTEND-clients.patch.gz) at 2023-01-25 04:46:15 from mahendrakar s <mahendrakarforpg at gmail.com> (Patch: No)
    Attachment (v3-0001-libpq-add-OAUTHBEARER-SASL-mechanism-and-call-back-hooks.patch.gz) at 2023-01-12 19:08:35 from mahendrakar s <mahendrakarforpg at gmail.com> (Patch: No)
    Attachment (v1-0001-oauth-flows-validation-hook-approach.patch) at 2022-11-23 09:58:32 from mahendrakar s <mahendrakarforpg at gmail.com> (Patch: Yes)
    Attachment (v5-0004-Add-support-for-map-and-custom-auth-options.patch.gz) at 2022-09-23 22:39:19 from Jacob Champion <jchampion at timescale.com> (Patch: No)
    Attachment (v1-0001-oauth-provider-support.patch) at 2022-09-20 05:03:10 from mahendrakar s <mahendrakarforpg at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Add-support-for-custom-authentication-methods.patch) at 2022-03-26 00:00:22 from Jacob Champion <pchampion at vmware.com> (Patch: Yes)
    Attachment (v3-0001-Add-support-for-custom-authentication-methods.patch) at 2022-03-04 19:13:42 from Jacob Champion <pchampion at vmware.com> (Patch: Yes)
    Attachment (v2-0001-common-jsonapi-support-FRONTEND-clients.patch) at 2021-08-25 18:41:39 from Jacob Champion <pchampion at vmware.com> (Patch: Yes)
    Attachment (0001-auth-generalize-SASL-mechanisms.patch) at 2021-06-08 16:37:46 from Jacob Champion <pchampion at vmware.com> (Patch: Yes)
History
When Who What
2025-07-09 21:06:35 Jacob Champion (jchampion) Deleted annotation "actual latest patch" from CAOYmi+ne9_EvK7Z-y78z_6VXnYgXoRbiumMQeWCcy8vHf5t-cw@mail.gmail.com
2025-07-09 18:41:42 Jacob Champion (jchampion) Added annotation "actual latest patch" to CAOYmi+ne9_EvK7Z-y78z_6VXnYgXoRbiumMQeWCcy8vHf5t-cw@mail.gmail.com
2025-02-20 22:26:08 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2025-03 with status: Committed
2025-02-01 19:41:47 Peter Eisentraut (petere) Closed in commitfest 2025-01 with status: Moved to next CF
2025-02-01 19:41:41 Peter Eisentraut (petere) New status: Ready for Committer
2025-02-01 19:41:16 Peter Eisentraut (petere) Changed reviewers to Peter Eisentraut (petere), Daniel Gustafsson (d_gustafsson), Antonin Houska (a.houska)
2025-02-01 19:41:16 Peter Eisentraut (petere) Changed committer to d_gustafsson
2024-12-01 14:32:20 Peter Eisentraut (petere) Closed in commitfest 2024-11 with status: Moved to next CF
2024-11-06 16:22:41 Jacob Champion (jchampion) New status: Needs review
2024-10-18 07:04:44 Antonin Houska (a.houska) New status: Waiting on Author
2024-10-18 05:54:53 Antonin Houska (a.houska) Added a.houska as reviewer
2024-10-01 15:24:53 Peter Eisentraut (petere) Closed in commitfest 2024-09 with status: Moved to next CF
2024-08-01 06:19:55 Corey Huinker (coreyh) Closed in commitfest 2024-07 with status: Moved to next CF
2024-07-22 18:17:58 Jacob Champion (jchampion) New status: Needs review
2024-07-01 12:32:14 Jacob Champion (jchampion) New status: Waiting on Author
2024-05-22 17:41:50 Peter Eisentraut (petere) Added petere as reviewer
2024-04-09 06:24:07 Andrey Borodin (x4m) Closed in commitfest 2024-03 with status: Moved to next CF
2024-01-01 03:45:39 Jacob Champion (jchampion) Closed in commitfest 2024-01 with status: Moved to next CF
2023-12-04 10:02:24 John Naylor (john.naylor) Closed in commitfest 2023-11 with status: Moved to next CF
2023-11-08 19:01:42 Jacob Champion (jchampion) New status: Needs review
2023-11-03 23:48:43 Jacob Champion (jchampion) New status: Waiting on Author
2023-10-02 09:58:13 Peter Eisentraut (petere) Closed in commitfest 2023-09 with status: Moved to next CF
2023-08-01 14:09:28 Jacob Champion (jchampion) Closed in commitfest 2023-07 with status: Moved to next CF
2023-06-27 20:30:28 Jacob Champion (jchampion) Changed authors to Jacob Champion (jchampion)
2023-06-27 20:30:11 Jacob Champion (jchampion) Attached mail thread d1b467a78e0e36ed85a09adf979d04cf124a9d4b.camel@vmware.com
2023-06-27 20:30:11 Jacob Champion (jchampion) Created patch record
Edit