public inbox for [email protected]
help / color / mirror / Atom feedFrom: Yogesh Mahajan <[email protected]>
To: Shakir Idrisi <[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: Mon, 16 Jun 2025 09:55:41 +0530
Message-ID: <CAMa=N=OV5yPe7uacbH1bqZAp40kd505HhFFX+a4ACocVS6CWBw@mail.gmail.com> (raw)
In-Reply-To: <CAKZfs-rQ_MHhKynKTAh4U1mEvBH_DsfV=+7KQLLSm9wmdqYF+w@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>
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: <CAMa=N=OV5yPe7uacbH1bqZAp40kd505HhFFX+a4ACocVS6CWBw@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