public inbox for [email protected]
help / color / mirror / Atom feedFrom: Shakir Idrisi <[email protected]>
To: Yogesh Mahajan <[email protected]>
Cc: pgadmin-support lists.postgresql.org <[email protected]>
Subject: Re: Issue with pgAdmin 4 Login Behind NGINX Reverse Proxy at /pgadmin4 Path
Date: Sun, 3 Aug 2025 22:21:36 +0530
Message-ID: <CAKZfs-ryzv8EZufktnkhqA7kxKjy-rqy=VXVR8Q-2rkYwW+B5w@mail.gmail.com> (raw)
In-Reply-To: <CAKZfs-qnoXgPCssReVoFzWTfr4C8QhdZRPX34SiRfNpbqhmruA@mail.gmail.com>
References: <CAKZfs-q0xwvyL5mQ5-Q5cMSzK0bHa03VjeNRzyCBVze-fa_CeQ@mail.gmail.com>
<CAMa=N=PgeekhtrE+bJn2atLui8sqqSDxdD3ScqSCMws+WenjOQ@mail.gmail.com>
<CAKZfs-rJF=D5JBfcuRpYLrYQTmbHJ9eGJf4ShDzbp34Wq7ewVA@mail.gmail.com>
<CAMa=N=Pa2shPSCNoCjWh2YXUJQ0n0dHOJrrzkHCpwj5p_hW8Hg@mail.gmail.com>
<CAKZfs-rM_x+N0Uf6xM8cmyzCzrm6R=kw-iXRNxFhnJmoGfvrKQ@mail.gmail.com>
<CAKZfs-rQ_MHhKynKTAh4U1mEvBH_DsfV=+7KQLLSm9wmdqYF+w@mail.gmail.com>
<CAMa=N=OV5yPe7uacbH1bqZAp40kd505HhFFX+a4ACocVS6CWBw@mail.gmail.com>
<CAKZfs-o-H6wg5NqQzaMNf_oUu45mN9XuUAuShCLmtCFNiScXLw@mail.gmail.com>
<CAKZfs-o+JgJ81EW+32=U20XdDnZswdQ6v5XbiqxWMmrUSy6Wpw@mail.gmail.com>
<CAMa=N=Me-QjTnrjzor3sePBeCzTcNiQh+FEdYJup8oevtvxNOg@mail.gmail.com>
<CAKZfs-qnoXgPCssReVoFzWTfr4C8QhdZRPX34SiRfNpbqhmruA@mail.gmail.com>
Hi,
Any update on this?
On Thu, Jul 31, 2025, 7:27 PM Shakir Idrisi <[email protected]> wrote:
> Hi,
>
> I am facing an issue when I try to access the pgadmin of https after
> logging in; it shows a blank page. Can you please help me figure it out?
>
> This is the config I am using.
>
>
>
> *location = /pgadmin4 { return 301 /pgadmin4/;}*
>
>
>
>
>
>
>
>
>
>
>
>
>
> *location ^~ /pgadmin4/ { proxy_pass http://unix:/tmp/pgadmin4.sock;
> proxy_set_header Host $host;proxy_set_header X-Real-IP
> $remote_addr;proxy_set_header X-Forwarded-For
> $proxy_add_x_forwarded_for;proxy_set_header X-Forwarded-Proto
> $scheme;proxy_set_header X-Forwarded-Host $host;proxy_set_header
> X-Script-Name /pgadmin4;proxy_http_version 1.1; proxy_read_timeout 300;
> proxy_connect_timeout 60;}*
>
> In the browser console of I am getting this error.
> *Object { message: "Request failed with status code
> 401", name: "AxiosError", code: "ERR_BAD_REQUEST", config: {…}, request: XMLHttpRequest, response: {…}, status: 401, stack: "".....*
>
> On Mon, Jun 23, 2025 at 9:12 AM Yogesh Mahajan <
> [email protected]> wrote:
>
>> Hi,
>>
>> Can you please try modifying '/pgadmin4' like below -
>> `location = /pgadmin4 {
>> return 301 /pgadmin4/;
>> }`
>>
>> You can use webserver /kerberos authentication method for automatic
>> login. With internal authentication method, you will required to enter your
>> userid/password. You may also use OAuth2.
>>
>> Thanks,
>> Yogesh Mahajan
>> EnterpriseDB
>>
>>
>> On Fri, Jun 20, 2025 at 1:24 PM Shakir Idrisi <[email protected]> wrote:
>>
>>> Hi,
>>>
>>> One more question, can I use autologin in pgAdmin4? I am using the
>>> internal method for authentication.
>>>
>>> On Fri, Jun 20, 2025 at 11:38 AM Shakir Idrisi <[email protected]>
>>> wrote:
>>>
>>>> Hi,
>>>>
>>>> Thanks, it worked.
>>>>
>>>> I am facing an issue when I try to access the pgadmin of https after
>>>> logging in; it shows a blank page. Can you please help me figure it out?
>>>>
>>>> This is the config I am using for the proxy in HTTPS and HTTP vhblock
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> *location = /pgadmin4 { rewrite ^ /pgadmin4/; }location ^~ /pgadmin4/
>>>> { proxy_pass http://unix:/tmp/pgadmin4.sock; proxy_set_header Host
>>>> $host; proxy_set_header X-Real-IP $remote_addr; proxy_set_header
>>>> X-Forwarded-For $proxy_add_x_forwarded_for; proxy_set_header
>>>> X-Forwarded-Proto $scheme; proxy_set_header X-Forwarded-Host $host;
>>>> proxy_set_header X-Script-Name /pgadmin4; proxy_http_version 1.1;
>>>> proxy_read_timeout 300; proxy_connect_timeout 60;}*
>>>>
>>>> In the browser console of I am getting this error.
>>>> *Object { message: "Request failed with status code 401", name:
>>>> "AxiosError", code: "ERR_BAD_REQUEST", config: {…}, request:
>>>> XMLHttpRequest, response: {…}, status: 401, stack: "".....*
>>>>
>>>> On Mon, Jun 16, 2025 at 9:56 AM Yogesh Mahajan <
>>>> [email protected]> wrote:
>>>>
>>>>> Hi,
>>>>>
>>>>> You can use the command 'update-user' for user update.
>>>>>
>>>>> To explore more options, you can use the command below with pgadmin
>>>>> venv.
>>>>>
>>>>>
>>>>> `python3.12 setup.py update-user --help `
>>>>>
>>>>>
>>>>>
>>>>> Typical command would be -
>>>>>
>>>>>
>>>>> `python3.12 setup.py update-user <user_id> --password <new_password>
>>>>> --role Administrator --sqlite-path <pgadmin_db_path>`
>>>>>
>>>>>
>>>>>
>>>>> Thanks,
>>>>> Yogesh Mahajan
>>>>> EnterpriseDB
>>>>>
>>>>>
>>>>> On Sat, Jun 14, 2025 at 5:09 PM Shakir Idrisi <[email protected]>
>>>>> wrote:
>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> I hope you're doing well.
>>>>>>
>>>>>> pgAdmin is now working properly. Earlier, I ran the setup-db command
>>>>>> and set the admin username and password.
>>>>>>
>>>>>> Now, after reinstalling pgAdmin, I noticed that the data directory
>>>>>> (including pgadmin.db) was not removed. I would like to either reuse the
>>>>>> old admin password or reset it if needed.
>>>>>>
>>>>>> Is there a way to reset the admin user's password using a command in
>>>>>> this case?
>>>>>> Your guidance would be greatly appreciated.
>>>>>>
>>>>>> Thank you for your help.
>>>>>>
>>>>>> On Tue, Jun 10, 2025, 9:57 PM Shakir Idrisi <[email protected]>
>>>>>> wrote:
>>>>>>
>>>>>>> Ok, I will check.
>>>>>>>
>>>>>>> On Tue, Jun 10, 2025, 5:26 PM Yogesh Mahajan <
>>>>>>> [email protected]> wrote:
>>>>>>>
>>>>>>>> Hi,
>>>>>>>>
>>>>>>>> I could reproduce the error when I have multiple workers. Maybe you
>>>>>>>> can try restarting the Guicorn service.
>>>>>>>> Can you please try once in the private browser window?
>>>>>>>>
>>>>>>>> Thanks,
>>>>>>>> Yogesh Mahajan
>>>>>>>> EnterpriseDB
>>>>>>>>
>>>>>>>>
>>>>>>>> On Tue, Jun 10, 2025 at 3:54 PM Shakir Idrisi <[email protected]>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> HI,
>>>>>>>>>
>>>>>>>>> I have used this command, and I have created a systemd file to
>>>>>>>>> start and stop the service.
>>>>>>>>>
>>>>>>>>> *ExecStart=/var/w-data/pgadmin4/pgadmin_venv/bin/gunicorn \*
>>>>>>>>> * --workers 1 \*
>>>>>>>>> * --threads=25 \*
>>>>>>>>> * --bind unix:/tmp/pgadmin4.sock \*
>>>>>>>>> * --chdir
>>>>>>>>> /var/w-data/pgadmin4/pgadmin_venv/lib/python3.11/site-packages/pgadmin4 \*
>>>>>>>>> * --umask 007 \*
>>>>>>>>> * pgAdmin4:app*
>>>>>>>>>
>>>>>>>>> Also, when I try multiple times then it will log in and show a
>>>>>>>>> blank dashboard, or sometimes it will show a dashboard but not work
>>>>>>>>> properly. In the console log, I see the following error
>>>>>>>>>
>>>>>>>>> [image: image.png]
>>>>>>>>>
>>>>>>>>> On Tue, Jun 10, 2025 at 3:26 PM Yogesh Mahajan <
>>>>>>>>> [email protected]> wrote:
>>>>>>>>>
>>>>>>>>>> Hi,
>>>>>>>>>>
>>>>>>>>>> Can you please share your guicorn command?
>>>>>>>>>> How many workers are you spawning? It should be 1.
>>>>>>>>>>
>>>>>>>>>> Thanks,
>>>>>>>>>> Yogesh Mahajan
>>>>>>>>>> EnterpriseDB
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Tue, Jun 10, 2025 at 12:34 PM Shakir Idrisi <[email protected]>
>>>>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>>> Hi,
>>>>>>>>>>>
>>>>>>>>>>> I've installed *pgAdmin 4* on my Linux server and configured it
>>>>>>>>>>> behind *Gunicorn and NGINX*, accessible at:
>>>>>>>>>>> https://domain.com/pgadmin4/.
>>>>>>>>>>>
>>>>>>>>>>> The login page loads correctly. However, after entering valid
>>>>>>>>>>> credentials, I'm redirected back to the login page without any error
>>>>>>>>>>> message. Occasionally, I see a *CSRF token* error, which
>>>>>>>>>>> disappears after a page refresh, but the login still fails.
>>>>>>>>>>>
>>>>>>>>>>> In the browser console or network tab, I sometimes see 401
>>>>>>>>>>> errors or issues loading static assets.
>>>>>>>>>>>
>>>>>>>>>>> Here's the NGINX configuration I'm currently using to reverse
>>>>>>>>>>> proxy pgAdmin via a Unix socket:
>>>>>>>>>>>
>>>>>>>>>>> *nginx*
>>>>>>>>>>> location /pgadmin4/ {
>>>>>>>>>>> proxy_pass http://unix:/tmp/pgadmin4.sock:/;
>>>>>>>>>>>
>>>>>>>>>>> # Proxy headers
>>>>>>>>>>> proxy_set_header Host $host;
>>>>>>>>>>> proxy_set_header X-Real-IP $remote_addr;
>>>>>>>>>>> proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
>>>>>>>>>>> proxy_set_header X-Forwarded-Proto $scheme;
>>>>>>>>>>>
>>>>>>>>>>> # Inform pgAdmin it's served under a subpath
>>>>>>>>>>> proxy_set_header X-Script-Name /pgadmin4;
>>>>>>>>>>>
>>>>>>>>>>> # Optional: timeouts and static asset handling
>>>>>>>>>>> proxy_read_timeout 300;
>>>>>>>>>>> proxy_connect_timeout 60;
>>>>>>>>>>> }
>>>>>>>>>>>
>>>>>>>>>>> Could you please advise:
>>>>>>>>>>>
>>>>>>>>>>> 1.
>>>>>>>>>>>
>>>>>>>>>>> Is there something wrong with the proxy setup?
>>>>>>>>>>> 2.
>>>>>>>>>>>
>>>>>>>>>>> Do I need to handle static assets or cookies differently
>>>>>>>>>>> when using a subpath (/pgadmin4)?
>>>>>>>>>>> 3.
>>>>>>>>>>>
>>>>>>>>>>> Are there any additional settings required in the pgAdmin
>>>>>>>>>>> config to work correctly behind a sub-URI with NGINX?
>>>>>>>>>>>
>>>>>>>>>>> Thanks in advance for your guidance.
>>>>>>>>>>>
>>>>>>>>>>
Attachments:
[image/png] image.png (90.4K, 3-image.png)
download | view image
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Issue with pgAdmin 4 Login Behind NGINX Reverse Proxy at /pgadmin4 Path
In-Reply-To: <CAKZfs-ryzv8EZufktnkhqA7kxKjy-rqy=VXVR8Q-2rkYwW+B5w@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox