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 1vBYFz-000S8k-N6 for pgadmin-support@arkaria.postgresql.org; Wed, 22 Oct 2025 12:47:59 +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 1vBYFy-00GLAb-LB for pgadmin-support@arkaria.postgresql.org; Wed, 22 Oct 2025 12:47:57 +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 1vBYFy-00GLA5-4R for pgadmin-support@lists.postgresql.org; Wed, 22 Oct 2025 12:47:57 +0000 Received: from mail-ua1-x92d.google.com ([2607:f8b0:4864:20::92d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vBYFt-0039zR-2B for pgadmin-support@lists.postgresql.org; Wed, 22 Oct 2025 12:47:55 +0000 Received: by mail-ua1-x92d.google.com with SMTP id a1e0cc1a2514c-932bced8519so3670346241.1 for ; Wed, 22 Oct 2025 05:47:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1761137272; x=1761742072; 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=/2uCGhLaaKYHJXT/P3xFnyCWj3CyaQGiVEhG8A0bIGQ=; b=IRVTYUY34+Ox0uqzIZvNKcFWp1OblbQECUoU2zQ+W8XxaH5kSuX0fj//q463NyO0ia 92iSdhreHwrLjR9cpnsRyoGS7NlzgOnSyLwHCzxunKgQcche8tcyfago6ysmIW7LcFmF T+z0WQ9sH7g4iMVeMkSGGr8BMkQ3sTy8ATi0SCLD1pamKIdN5DbUaHMW75sMwgq1iECs Tib0Z0jirPAoAtxz7tTTaWp54KdeXsZTFSOMff6FEKKdELug+yLfJVJIgRFFUZ6qA1Cw Xwv4sZWnSA1NOBFHjhBvOSvA4gHq5xsQqolAwSfn8vHUeE9Mj528i/vlFuDG+CH55Lff apxQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761137272; x=1761742072; 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=/2uCGhLaaKYHJXT/P3xFnyCWj3CyaQGiVEhG8A0bIGQ=; b=iudYKVuXml4jciPHyG6wr/gC2asFmFpGZVjRLjK0XT01QgV7vgabHqP+Y152NgrG/U 6hO8SW867mgMXo/wt2UT7SbwRSUNH9/SOwtJi6GGza8tHjQW4iSFpApDhCvZvy7N0ELV IyleqUspa69Pv57zALPHP3xRuSkAf/MG470gtl7j9NeoYbpIcHYZvd17CUp8sW+QfnBx a2o9VI/n7rIJ4wc2aEAJYgA40qoQL12GBNfFNCAQk5fhfc9W03nOaUJbUIm3M0a8cPOQ 7Y2DKmwu9hYihXrKDlQYJxkJW0RCGZ0iobb34P/57JLrAqC1K4+pQFcDJZ0iG5xFQd5m o0XQ== X-Gm-Message-State: AOJu0YyBAK4FJ42Vv70tQq8N5KYGXuv3yg+5s5rbeTsEz4a6eNBVrkZe OwgGrgj9eMKPja99tDeJlEnhWdYRymYnQXMilcdZkWiLcWp597iPdTC+B022jjuKXUbKU4kaM5l rguUfqZAvTpnqNtKHfA9qZNmZlMaIDQ6auSDELkZyTvr5RhRTE3gapQ== X-Gm-Gg: ASbGncumDd2c23SgNnYUc2S2wQBmtyMPSQD/MJxTJ6ihispqZ5PttOuxKRGfAdBudzH 1mkNlqDinUwMo5MhPswhldt3ckkImmkSEG3qGJz6WeZEivAxXX9Ye3RSv28TMtjaJjmxI8U+QRo gyQ3bKkgT4l/KhXVJOazTLZNwcucnCLPOKhL8MBx1kCi5QssX+Qg94F9KNTrZlptmCXWeDh10RH MzhYGzfYxzdKPopqMe2imFu4MUVdj8dKaGO3q2kTEX2lPP8XwzMlnoOXbv1ZZw= X-Google-Smtp-Source: AGHT+IFXl/9Hv1UHJrHrAs/dlWgQqnjubghcMKNELPSRA295+JufruRGMyOmPFbRV+v9CZi9xdaxRMujPSBkhoRSkns= X-Received: by 2002:a05:6102:3a13:b0:5d4:1e69:fda2 with SMTP id ada2fe7eead31-5d7dd464a93mr6920646137.17.1761137272210; Wed, 22 Oct 2025 05:47:52 -0700 (PDT) MIME-Version: 1.0 References: <72B3573D-7E61-4D20-AE8B-8EB6DA2672F8@gmail.com> In-Reply-To: From: Aditya Toshniwal Date: Wed, 22 Oct 2025 18:17:16 +0530 X-Gm-Features: AS18NWDdFdG0KX370u116KU4eWZEeYe2GmgeMFcwurIcmcWn0kNgLq4y6FUR-jI 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="00000000000082d52a0641beb914" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000082d52a0641beb914 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Bastiaan, Check this one - https://github.com/pgadmin-org/pgadmin4/issues/9281 Are you able to get the same behaviour as mentioned? On Wed, Oct 22, 2025 at 12:21=E2=80=AFPM Aditya Toshniwal < aditya.toshniwal@enterprisedb.com> wrote: > 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 >> status 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 f= ile >> 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 >> causing 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 wh= y >> 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= =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 >> 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 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, superviso= r, >> 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 stil= l >> 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 denie= d >> (/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 Toshniwal > pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com* > > "Don't Complain about Heat, Plant a TREE" > --=20 Thanks, Aditya Toshniwal pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com* "Don't Complain about Heat, Plant a TREE" --00000000000082d52a0641beb914 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi=C2=A0Bastiaan,

Check this one -=C2=A0https://github.com/pgadmin-o= rg/pgadmin4/issues/9281
Are you able to get the same behaviour as menti= oned?

On Wed, Oct 22, 2025 at 12:21=E2=80=AFPM A= ditya Toshniwal <ad= itya.toshniwal@enterprisedb.com> wrote:
Hi=C2=A0Bastiaan,

Maybe w= e'll have to add more logs to debug the issue you're facing. If it&= #39;s=C2=A0an internal server error then it should have logged it.

On = Sat, Oct 18, 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"


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