Hi Akshay, I want to really thank you and Khushboo Vashi for this new feature
to authenticate via REMOTE_USER.
However, it's clear from the functionality that it only addresses working with
pgAdmin when it is embedded inside uWSGI or mod_wsgi, and that's OK :)
To make it work with headers that come from another server, I added these lines
to my config_local.py file:
# monkey patch the authentication class to use headers instead of
environments
from flask import request
import pgadmin.authenticate.webserver
def get_user(self):
username = request.headers.get("X-Forwarded-User")
if not username or username == "(null)":
username
return username
pgadmin.authenticate.webserver.WebserverAuthentication.get_user = get_user
I wanted to share this with the list, too, in case someone else wants to add
this functionality to their system. Thanks a ton!
-Paul
Paul Lockaby (he/him) / Senior Data Engineer
Center for an Informed Public / University of Washinton
[email protected]<mailto:[email protected]> / www.cip.uw.edu<http://www.cip.uw.edu>
On Oct 21, 2021, at 5:44 AM, Akshay Joshi
<[email protected]<mailto:[email protected]>> wrote:
The pgAdmin Development Team is pleased to announce pgAdmin 4 version 6.1.
This release of pgAdmin 4 includes 30 bug fixes and new features. For more
details please see the release notes at:
https://www.pgadmin.org/docs/pgadmin4/6.1/release_notes_6_1.html.
pgAdmin is the leading Open Source graphical management tool for PostgreSQL.
For more information, please see:
https://www.pgadmin.org/
Notable changes in this release include:
Features:
*
Added support for indent guides in the browser tree.
*
Added support for advanced table fields like the foreign key, the primary key
in the ERD tool.
*
Added support to allow tables to be dragged to the ERD Tool.
*
Added index creation when generating SQL in the ERD tool.
*
Added support for authentication via the web server (REMOTE_USER).
*
Added support to enable/disable rules.
Bugs/Housekeeping:
*
Fixed OAuth2 integration redirect issue.
*
Ensure that the query highlighting color in the query tool should be less
intensive.
*
Fixed an issue where the browser tree doesn't show all contents on changing
resolution.
*
Ensure that columns should be displayed in the order of creation instead of
alphabetical order in the browser tree.
*
Fixed background color issue in the browser tree.
*
Added support for composite foreign keys in the ERD tool.
*
Fixed an issue where the users are unable to load the databases behind an HTTP
reverse proxy.
*
Fixed an issue where each click to refresh the collection node, the number of
objects decreasing by tens or more.
*
Fixed browser tree sort order regression issue.
* Fixed an issue where the blank string is stored instead of NULL in the
server table of an SQLite database.
Builds for Windows and macOS are available now, along with a Python Wheel,
Docker Container, RPM, DEB Package, and source code tarball from:
https://www.pgadmin.org/download/
--
Akshay Joshi
pgAdmin Project
