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

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 PM Aditya Toshniwal <
aditya(dot)toshniwal(at)enterprisedb(dot)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 PM Bastiaan Wakkie <bwakkie(at)gmail(dot)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
>> and “Access denied (…)” 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 file
>> 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 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 … weirdly enough.
>>
>> Could it be that I open the query tool always tool in a new tab? I’m 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 <bwakkie(at)gmail(dot)com> 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 = 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 = "/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?
>> >
>> > ... 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*
> <https://www.enterprisedb.com/>
> "Don't Complain about Heat, Plant a TREE"
>

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com*
<https://www.enterprisedb.com/>
"Don't Complain about Heat, Plant a TREE"