Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v8AkY-00DuX8-LV for pgadmin-support@arkaria.postgresql.org; Mon, 13 Oct 2025 05:05:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1v8AkV-004CGC-St for pgadmin-support@arkaria.postgresql.org; Mon, 13 Oct 2025 05:05:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v8AkV-004CG4-Jo for pgadmin-support@lists.postgresql.org; Mon, 13 Oct 2025 05:05:32 +0000 Received: from mail-ua1-x92f.google.com ([2607:f8b0:4864:20::92f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v8AkT-001rtP-1O for pgadmin-support@lists.postgresql.org; Mon, 13 Oct 2025 05:05:31 +0000 Received: by mail-ua1-x92f.google.com with SMTP id a1e0cc1a2514c-92cbfab6c0dso2494238241.3 for ; Sun, 12 Oct 2025 22:05:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1760331927; x=1760936727; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=EadgrJuqqsKy6qJcUbRa0G9ns7MKT4s/zNT2/4KCrWc=; b=GP53tEn4cMAXYYwzRsHGEMmKRosTObQ+lJl6Z2r6dBNZ1ml0r+67F25MPzIdp7dOuh rcp5aDpAxCeNMlUZ3mC7Utn07Qq6vdkMUcfU0L3YX1CCAiXNeRZYSDg5STZrutSdVTYY nzM2Bv80xDiC2dqpxzMzqUBDfhfyHrjy/RiQguLns9/dQ6UJcijFIZ3U2JEliaPEdZ6h gaVOvIm0ogD2Kmg0Au+XP3b9Ua7sUzdg1C7l9ys6q+bv/euGlTnixq0ijkqw8twxezzO w/mNhwjBfnTuygWm+qopB34Up6oX3bZ/FYQDagGDMj6FzM1GLKpduqQ6AJrZN0WzKopw YwGg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1760331927; x=1760936727; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=EadgrJuqqsKy6qJcUbRa0G9ns7MKT4s/zNT2/4KCrWc=; b=Dk/7QvpxZkVn6ahARAYt6eSI0PeueRdCi43v9jDEzIHYO9C7Hgdxpy0vepgaGVFliw /gqiRiqT0aA04K99Ggx3F2bHGKfvoacUejo2d5FcpbGLAL0G96dDUYj4y4vwVYMw1VEa yppIuk17YMBvuYEwTRlAHD3y+5Fx+oN8p8SwvtMgFF/5hGMuNTgoHgs8UecDGjKx5fWT qzDG/JT1uPGU8gycSi7VCxraJkua2QF4/BwZDZc0sHH3aelK44Pwr4b9g5sq5IYkHXq6 aGkuxkEkODJ7CaFHSHIyecC+zSV/hqjAyV15vqor8FEpHIS74Kj8v/rmteYxurAdz72R Y8og== X-Gm-Message-State: AOJu0YwO3J8KlPV6ijq0+KZ/p4gpVa/7CK4ORHB5OenbSUcCWb+QnaNd cYoxyZeY0mAQhwll6Txvy2A4YwQO77xU+5IRtqBrZQeewAzNlr0qw/XzSn5zeQlzy3tIcrMTCae G258WXfS9xJwDUxBfhYv/WvbgpGQc0hD3aGrdYnruXDSBthPP1HVBDA== X-Gm-Gg: ASbGncsMHuV9C7eG5r4/jXqO4K0f3mwJ/Q4raFTaqnSXrzrTzJMkylENUq63EF7wZK9 5Cq3aJEQgouVT4zf69D2h6LRvNvCoF51SC67GM2NVlx7iinZg+Tff4hFepWysLx4MgS09wQGSYG g4/OB3lUoXaT31Lr/jOSi+m4AVJne/yJawzlNiRmgYy+/9N+Q6/Ch2w977fFX/pgu2d5EyL1ypi 8AupNlOy+dUXj3MtQ1HwqUA4WBcGySEg+Uc1bNb+CtAIOHF+tre1hkliMhtthvFXzHjXBU= X-Google-Smtp-Source: AGHT+IGUCF2pABAsVFKa0MqlYFFT9J2s5krnS/Os55Wl02ZIOSKcnj7/R3Kz6svZfRaK6tOqV+WET8y2y+aXIyFXxA4= X-Received: by 2002:a05:6102:c8b:b0:5d5:f6ae:38ff with SMTP id ada2fe7eead31-5d5f6ae3e01mr5628461137.44.1760331926662; Sun, 12 Oct 2025 22:05:26 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Aditya Toshniwal Date: Mon, 13 Oct 2025 10:34:49 +0530 X-Gm-Features: AS18NWDB0htaZaVrQP2eZ19drFABX386E-W97JWYNPsrTaMA5CxgXEVALORomrQ Message-ID: Subject: Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied To: Bastiaan Wakkie Cc: "pgadmin-support@lists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000002d012106410337db" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000002d012106410337db Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Bastiaan, Can you share pgAdmin logs (whatever it has)? Also check the permission of /data/databases/pgadmin4/ directory. On Sat, Oct 11, 2025 at 3:41=E2=80=AFPM Bastiaan Wakkie = wrote: > > > Hi all, > > > Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 > error/Access denied > > The rest of the pgadmin4 application is working like normal.. > > I can run any sql queries without problems, just cannot load or save any > files! > > > What did I do/remember: > > 1) recently updated postgresql to 17.5 on manjaro rolling release. > > 2) I remember that I went to the root of the storage when it started to > act weird. Not sure this is connected though > > 3) When I try opening any file stored in the storage, I'm getting ... > "Request failed with status code 500" > ... error in the application but I cannot find *anywhere* in the logs an > indication of what is happening (Also not in my postgresql, supervisor, > nginx or journalctl logs). > > 4) I updated pgadmin4 from 9.6 to 9.8 like I always do (pip install -U > pgadmin4) to see if this would fix it but the problem persists. > > 5) ...I changed CONSOLE_LOG_LEVEL =3D 10 in the hope to see more but alas= ... > > 6) ...I enabled postgresql log to see something comes up there, but no > postgresql seems quietly doing it's thing.. > > 7) I checked the ... > STORAGE_DIR =3D "/data/databases/pgadmin4/storage" > ... and all is owned by the pgadmin user. > > 8) Via the command line I can add/delete/remove files/directories in the > storage folder and I will see them in the storage (manager) but still > unable to open or save any file. > > 9) BUT when I create a new sql script and try to save it or "save as" I a= m > getting an "Access denied" message : > "Successfully run. Total query runtime: 311 msec. 14603 rows affected. > Access denied (/new script.sql)Access denied (/new_file.sql)Access denied > (/two.new.sql)" > (The message keeps appending my last attempts, btw) > > > Did anybody else had this problem before? > > ... and know how to fix it? > > ... or knows a way to track down the 500 error of the app. > > > or is this git issue material? > > Cheers, > > Bastiaan > > > > --=20 Thanks, Aditya Toshniwal pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com* "Don't Complain about Heat, Plant a TREE" --0000000000002d012106410337db Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi=C2=A0Bastiaan,

Can you share pgA= dmin logs (whatever it has)?
Also check the permission of=C2=A0/d= ata/databases/pgadmin4/<USER> directory.

On Sat, Oct 11, 2025 at 3:41=E2=80=AFPM Bastiaan Wakkie <bwakkie@gmail.com> wrote:
=20 =20 =20


Hi all,


Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied

The rest of the pgadmin4 application is working like normal..

I can run any sql queries without problems, just cannot load or save any files!


What did I do/remember:

1) recently updated postgresql to 17.5 on manjaro rolling release.

2) I remember that I went to the root of the storage when it started to act weird. Not sure this is connected though

3) When I try opening any file stored in the storage, I'm getting ...=C2=A0
"Request failed with status code 500"=C2=A0
... error in the application but I cannot find *anywhere* in the logs an indication of what is happening (Also not in my postgresql, supervisor, nginx or journalctl logs).

4) I updated pgadmin4 from 9.6 to 9.8 like I always do (pip install -U pgadmin4) to see if this would fix it but the problem persists.

5) ...I changed CONSOLE_LOG_LEVEL =3D 10 in the hope to see more but alas...=C2=A0

6) ...I enabled postgresql log to see something comes up there, but no postgresql seems quietly doing it's thing..

7) I checked the ...
STORAGE_DIR =3D "/data/databases/pgadmin4/storage"
... and all is owned by the pgadmin user.

8) Via the command line I can add/delete/remove files/directories in the storage folder and I will see them in the storage (manager) but still unable to open or save any file.

9) BUT when I create a new sql script and try to save it or "save as" I am getting an "Access denied" message :
"Successfully run. Total query runtime: 311 msec. 14603 rows affected. Access denied (/new script.sql)Access denied (/new_file.sql)Access denied (/two.new.sql)"
(The message keeps appending my last attempts, btw)


Did anybody else had this problem before?

... and know how to fix it?=C2=A0

... or knows a way to track down the 500 error of the app.


or is this git issue material?

Cheers,

Bastiaan





--
Thanks,
Aditya Toshniw= al
pgAdmin Hacker=C2=A0| Sr. Staff SDE II=C2= =A0| enterprisedb.com
"Don't Complain about Heat, Plant a TREE"
--0000000000002d012106410337db--