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 1vBShS-00GrNl-LP for pgadmin-support@arkaria.postgresql.org; Wed, 22 Oct 2025 06:51:58 +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 1vBShQ-00DtHY-M0 for pgadmin-support@arkaria.postgresql.org; Wed, 22 Oct 2025 06:51:55 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vBShQ-00DtHK-9n for pgadmin-support@lists.postgresql.org; Wed, 22 Oct 2025 06:51:55 +0000 Received: from mail-vk1-xa29.google.com ([2607:f8b0:4864:20::a29]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vBShM-00377I-0y for pgadmin-support@lists.postgresql.org; Wed, 22 Oct 2025 06:51:53 +0000 Received: by mail-vk1-xa29.google.com with SMTP id 71dfb90a1353d-54c0a10990fso2267369e0c.2 for ; Tue, 21 Oct 2025 23:51:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1761115911; x=1761720711; 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=NoGFWudbcDPBUkWM3nhkraLQ2BhkYzgPDZb6R9i6EE4=; b=YWURthSCdq0XVdVj8AeRajnTaVm1Welg1ZxWa4zzMeYEIfuipuAxszeYjJev67LJRm 13Zhlhd4CaYeNMG7ikrpeKz7WLf8ykgIVQrQjH4reOM5ianKQau2OgsdSb3f4sFurfEh awd6lG4Q5SF7UVfqd9U/l+FLMgabo5Ij+kZk8ByFcebSmsBGCIi6R+210eO3JNfVx9f6 3CFti6bjXvEjxcwoJJ208571n/nZ1fZjKl/orZBQuRHOj7d+QeVHEuFMNkQh+gA+o/n5 eDIVYqHgEdDs7juyuQtIcOI4DqyTsF4rjrN/TM7Udl3xyYH2+XQ0rRw07fSRgeSe/1Ny bgBQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761115911; x=1761720711; 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=NoGFWudbcDPBUkWM3nhkraLQ2BhkYzgPDZb6R9i6EE4=; b=G8LEUWrh+89+EqRtdAeVb0Yd/QcI3nFC2BzicfRY3a0s1nQve1T+OaBqhGmwu3unHn cqBacaGXtJvRVhdIecoBhQJ5502bkS02+3LB50htfl6mRp2ho9vYi8zngdtSKOsbjYvv cN+PsZHEPRCZS4tyy1f9ocub8o0lPLfnuPbLKrALiPfzpH4CLAkLMEsMAC/qZfG/Saac 3iSVLoszgrSwGwOeOwVJAVJKbnx4tPYglZfrjd0+YPCfrW4QtJHQ5aK/v8MHCWzNCm1X xEAeP+tSOooK3s2YsyzL4H96VPy2TB5yOIleNaU9tSftvaeoJVkDujrDDFcs48W9cber dVwA== X-Gm-Message-State: AOJu0Yxas4O2aNhCbNjobIzB6g1xBHN/2ch3+Z8KpqAUsPldd6BkqcFP Sg8urFfYMV26pLazdVqD/iXkeyjjdEk93sg9Kj7U618tp7Ghp6II8Ulwne5gPKlMPi4RAqrGgWB i7OsafzFxZCw+jQaqhl6vROTkZfNbQg4puGgeMeQ3 X-Gm-Gg: ASbGncuCmh9EahIwDYvqg40HZMHy8IQvL8L1EhQHhdqDyxWGAkKCU2nGBPQ7B0+csJC JUDq1nzyjsHDIDRaruI1vhcdvVQ/GldR6TAx5F7Chpum9aAbM0NAP7wbT1YCnbbsRTu28XDl4Rn EEcvyBsHkELArCMO331uOfkaNXz+1PK0OjSyfjooefKnSVACgMLS/yZJZeuPLIjZaYp9ePMq5TB Puy2mdKoXwoHEupl6ygiGYQ3LyieFqfECOp+Pf7O8COtSQ3zTktMnltQRr9ApE= X-Google-Smtp-Source: AGHT+IFf406f1IhMVhxfB6aXbHGrtnAHkqg2Zjknb+TYrGhd4f7cywyvz0ikGAa0tsjun2XGDtIYSRmPkUba0ciNjX8= X-Received: by 2002:a05:6102:32d3:b0:5d5:f912:f891 with SMTP id ada2fe7eead31-5d7dd5698efmr5489575137.19.1761115911171; Tue, 21 Oct 2025 23:51:51 -0700 (PDT) MIME-Version: 1.0 References: <72B3573D-7E61-4D20-AE8B-8EB6DA2672F8@gmail.com> In-Reply-To: <72B3573D-7E61-4D20-AE8B-8EB6DA2672F8@gmail.com> From: Aditya Toshniwal Date: Wed, 22 Oct 2025 12:21:14 +0530 X-Gm-Features: AS18NWBd3ZF2LJsZAsv9ZlFlryOibuW0ON86mahr2HyljSTmgGfcRfTmcRCe5yI 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="0000000000004b48930641b9c03c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000004b48930641b9c03c Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Bastiaan, Maybe we'll have to add more logs to debug the issue you're facing. If it's an internal server error then it should have logged it. On Sat, Oct 18, 2025 at 8:51=E2=80=AFPM Bastiaan Wakkie = wrote: > UPDATE: > > After upgrading to 9.9 still the same problem. > > Im getting... > When saving: ... and [! Request failed with status code 500] error popup > and =E2=80=9CAccess denied (=E2=80=A6)=E2=80=9D in the Message pane. > When opening an already stored file: ... an [! Request failed with statu= s > code 500] error popup. > > If Im logged in as pgadmin on the server (the user running the app) and I > could create a file in the storage directory. I even tried to make one fi= le > world readable (chmod 777) but still I am getting the above errors. I do > see any file created directly in the storage. > > I also started Firefox 144.0 without extensions to see if this was causin= g > the problem. But not as I expected as an 500 error indicates something > server side. But I am ticking off any possible way to trace why this > problem is happening. > > Still nowhere I am able to detect any indication in the log files. > > The only thing that works is creating a new folder via the storage manage= r > and rename files =E2=80=A6 weirdly enough. > > Could it be that I open the query tool always tool in a new tab? I=E2=80= =99m have > trouble finding the setting to disable this btw to test this hypothesis. > I also note that options/storage/last storage is set to None. While the > last directory changes when I move around. > > Ps running pgadmin4 in a venv with python 3.13.7 > > Thx, > Bastiaan > > > On 11 Oct 2025, at 12:10, 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 an= y > 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 a= n > 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 th= e > 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? > > > > ... 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" --0000000000004b48930641b9c03c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi=C2=A0Bastiaan,

Maybe we'll have to add more logs t= o debug the issue you're facing. If it's=C2=A0an internal server er= ror then it should have logged it.

On Sat, Oct 1= 8, 2025 at 8:51=E2=80=AFPM Bastiaan Wakkie <bwakkie@gmail.com> wrote:
UPDATE:

After upgrading to 9.9 still the same problem.

Im getting...
When saving: ... and [! Request failed with status code 500] error popup an= d=C2=A0 =E2=80=9CAccess denied (=E2=80=A6)=E2=80=9D in the Message pane. When opening an already stored file: ... an=C2=A0 [! Request failed with st= atus code 500] error=C2=A0 popup.

If Im logged in as pgadmin on the server (the user running the app) and I c= ould create a file in the storage directory. I even tried to make one file = world readable (chmod 777) but still I am getting the above errors. I do se= e any file created directly in the storage.

I also started Firefox 144.0 without extensions to see if this was causing = the problem. But not as I expected as an 500 error indicates something serv= er side. But I am ticking off any possible way to trace why this problem is= happening.

Still nowhere I am able to detect any indication in the log files.

The only thing that works is creating a new folder via the storage manager = and rename files =E2=80=A6 weirdly enough.

Could it be that I open the query tool always tool in a new tab? I=E2=80=99= m have trouble finding the setting to disable this btw to test this hypothe= sis.
I also note that options/storage/last storage is set to None. While the las= t directory changes when I move around.

Ps running pgadmin4 in a venv with python 3.13.7

Thx,
Bastiaan

> On 11 Oct 2025, at 12:10, Bastiaan Wakkie <bwakkie@gmail.com> wrote:
>
>
>
> Hi all,
>
>
> Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 erro= r/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 a= ny 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 t= o 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 a= las...
>
> 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 t= he storage folder and I will see them in the storage (manager) but still un= able 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 affe= cted. Access denied (/new script.sql)Access denied (/new_file.sql)Access de= nied (/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
>
>
>





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