Client authentication via OAuth 2.0

Edit

ID 4412

Title Client authentication via OAuth 2.0

Topic Security

Created 2023-06-27 20:30:11

Last modified 2025-02-01 19:41:47 (1 day, 3 hours ago)

Latest email 2025-01-31 16:23:36 (2 days, 6 hours ago)

Status

2025-03: Ready for Committer

2025-01: Moved to next CF

2024-11: Moved to next CF

2024-09: Moved to next CF

2024-07: Moved to next CF

2024-03: Moved to next CF

2024-01: Moved to next CF

2023-11: Moved to next CF

2023-09: Moved to next CF

2023-07: Moved to next 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 CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/4412
git checkout commitfest/cf/4412

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-01-31 16:23:36 by Daniel Gustafsson <daniel at yesql.se>
Latest 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>
    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-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