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

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