Yogesh Mahajan
75dc42cf24
Allow OAuth 2 login using the username claim if the email is absent from the user profile. #8652
2025-04-23 15:21:25 +05:30
Kristof Hauser
1e00611792
Add support for OAuth2 profile array response, which also takes care of the GitHub Private Email ID issue. #8391
2025-01-28 16:53:56 +05:30
Yogesh Mahajan
5ee0328063
Fix an error during logout from pgAdmin when using OAuth2 authentication with the query tool open.
2025-01-22 21:05:06 +05:30
Akshay Joshi
964d211260
Copyright updated for 2025
2025-01-01 11:26:42 +05:30
Yogesh Mahajan
dd6f6cf1af
Support OIDC in OAuth2 authentication. #7839
2024-09-16 08:36:54 +05:30
Khushboo Vashi
e5012ea9c6
Add debug logs to observe the OpenID token response.
2024-09-04 19:46:40 +05:30
Yogesh Mahajan
c4dc839d7c
Fix issue found while testing keyring related changes. #7076
2024-08-28 11:46:04 +05:30
Yogesh Mahajan
1257ec9969
Revamp the current password saving implementation to keyring and reducing repeated OS user password prompts. #7076
...
The new implementation will store the master password in the keyring instead of storing each and every server password separately. The master password will be used to encrypt/decrypt server password when storing in the pgAdmin config DB.
2024-08-22 16:44:57 +05:30
Akshay Joshi
df2f3460f0
Fix the following SonarQube code smells:
...
1) Use the "RegExp.exec()" method instead.
2) Remove parameter form or provide default value.
3) Extract this nested ternary operation into an independent statement.
4) Replace this character class by the character itself.
5) Unnecessary use of conditional expression for default assignment.
6) Prefer using an optional chain expression instead, as it's more concise and easier to read.
2024-06-11 18:07:22 +05:30
Neville Li
5a3fa59741
Fix id_token KeyError on OAuth2 logout.
2024-04-16 12:19:06 +05:30
Florian
3425bc0349
Ensure that the OAuth2 session is logged out when users log out from pgAdmin. #7193
2024-03-01 12:09:01 +05:30
Akshay Joshi
740ce15bd7
Update copyright notices for 2024
2024-01-01 14:13:48 +05:30
Yogesh Mahajan
4e2aa82ddd
Provide a way to bypass the SSL cert verification for OAuth2 provider. #6095
2023-12-04 11:19:14 +05:30
Everton Seiei Arakaki
682d6597e4
Fix an issue where OAUTH_ADDITIONAL_CLAIMS does not recognise AzureAD with > 150 groups. #6835
2023-11-20 11:33:39 +05:30
Martin Tietz
23c618e1c9
Fix more data type mismatch when checking OAUTH2 claims
2023-11-17 16:30:04 +05:30
Martin Tietz
5bdccb6e63
Fix a data type mismatch when checking OAUTH2 claims
2023-11-17 15:18:07 +05:30
Yogesh Mahajan
1bfd8d7f3c
Fix foreign table api test failures for EPAS.
2023-10-27 12:58:47 +05:30
Everton Seiei Arakaki
02eaf787e9
Add support for additional ID token claim checks for OAuth 2 authentication. #6736
2023-09-05 11:28:18 +05:30
Yogesh Mahajan
cd613ded0a
Ensure user is redirected to login page after failed login. #6704
2023-08-25 10:38:50 +05:30
Aditya Toshniwal
d6cddd8c29
Remove Bootstrap and jQuery from authentication pages and rewrite them in ReactJS. #6295
2023-06-30 16:08:33 +05:30
Yogesh Mahajan
0431cf7fc1
Ensure the user is able to log in if the specified OAUTH2_USERNAME_CLAIM is present in the OAuth2 profile. #6267
2023-05-10 14:39:35 +05:30
Paul Milbank
83ec0f3d90
Add additional logging for successful logins and user creation. #5842
2023-02-13 11:11:05 +05:30
Akshay Joshi
98184e5835
Update copyright notices for 2023
2023-01-02 11:53:55 +05:30
Yogesh Mahajan
acc26744e3
Fixed a missing "jwks_uri" in metadata error that occurred when logging in with an oAuth2 provider like Azure or Google. #5666
2022-12-22 16:54:13 +05:30
Mark Mayo
41508f7f67
python 3 updates
...
- Fix super() calls for python 3
- No need to inherit objects.
- No need for u at the start of strings
- Tidied up some brackets and f-strings too
2022-11-19 10:13:41 +05:30
Leon Maraite
6bc5808c53
Add the possibility to configure the OAuth2 claim which is used for the pgAdmin username. #5468
...
This feature provides the possibility to configure the Oauth2 claim
which should be used as a username. The key in the config.py is called
'OAUTH2_USERNAME_CLAIM'. If you don't provide a custom key, the email
is used as the username, like before. So it is completely backward
compatible.
2022-11-07 13:58:23 +05:30
Aditya Toshniwal
e2b00dda1b
Fixes a redirect vulnerability when the user opens the pgAdmin URL. Fixes #5343
2022-09-19 15:36:10 +05:30
Aditya Toshniwal
04b1e26041
Fixed an issue where server names with special characters are not displayed correctly in the process tab. Fixes #7695
2022-09-15 16:43:37 +05:30
Aditya Toshniwal
2de965d710
1. Use EDB's repo for react-data-grid instead of the personal repo.
...
2. Improved searching in the Search Objects.
3. Fixed react warnings in the query tool.
4. Fixed some SonarQube issues.
2022-09-13 19:13:33 +05:30
Yogesh Mahajan
f28e8126af
Added support for Azure AD OAUTH2 authentication. Fixes #7325
2022-04-21 12:48:10 +05:30
Yogesh Mahajan
b539637426
Fixed an issue where a warning is flashed every time for an email address when
...
authentication sources are internal and ldap. Fixes #6999
2022-02-16 13:34:24 +05:30
Akshay Joshi
2786f7ac5a
Update copyright notices for 2022
2022-01-04 13:54:25 +05:30
Akshay Joshi
d644b4f94e
1) Replace Flask-BabelEx with Flask-Babel. Fixes #6088
...
2) Upgrade Flask to version 2. Fixes #7010
2021-11-24 17:22:57 +05:30
Khushboo Vashi
3786954a65
Added support for OAuth 2 authentication. Fixes #5940
...
Initial patch sent by: Florian Sabonchi
2021-09-09 12:40:53 +05:30
Nico Rikken
d13d2c6dda
Introduced OAUTH2_SCOPE variable for the Oauth2 scope configuration. Fixes #6627
2021-08-31 14:36:14 +05:30
Khushboo Vashi
3590c9172c
Fixed an issue where the user unable to login with OAuth2 when LDAP & OAuth2 configured as login sources. Fixes #6594
2021-07-09 21:50:50 +05:30
Khushboo Vashi
5ee8045916
Informative error should be shown if Oauth2 profile does not have email id registered. Fixes #6590
2021-07-07 17:58:49 +05:30
Khushboo Vashi
48ca83f31d
Added support for OAuth 2 authentication. Fixes #5940
...
Initial patch sent by: Florian Sabonchi
2021-07-06 13:22:58 +05:30