public inbox for [email protected]
help / color / mirror / Atom feedFrom: Bastiaan Wakkie <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied
Date: Sat, 18 Oct 2025 17:20:59 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
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 <[email protected]> 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
>
>
>
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]
Subject: Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied
In-Reply-To: <[email protected]>
* 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