Hi Paul,
On Fri, Oct 22, 2021 at 5:12 AM Paul Lockaby <plock...@uw.edu> wrote:
> 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
>
> Thanks for the patch.
We will add this patch in the webserver authentication plugin with some
modifications, so other users can use it.
Thanks,
Khushboo
>
> 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
> plock...@uw.edu / www.cip.uw.edu
>
>
> On Oct 21, 2021, at 5:44 AM, Akshay Joshi <akshay.jo...@enterprisedb.com>
> 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
>
>
>
