public inbox for [email protected]  

help / color / mirror / Atom feed

From: Bastiaan Wakkie <[email protected]>
To: [email protected] <[email protected]>
Subject: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied
Date: Sat, 11 Oct 2025 12:10:48 +0200
Message-ID: <[email protected]> (raw)



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