Content-Type: multipart/alternative;
 boundary="------------RpY8BK6HDh8cR2eM6UTBXd8V"
Message-ID: <b0032df7-8365-4ebc-a0d1-add2890ef52d@gmail.com>
Date: Sat, 11 Oct 2025 12:10:48 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
From: Bastiaan Wakkie <bwakkie@gmail.com>
Subject: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500
 error/Access denied
To: "pgadmin-support@lists.postgresql.org"
 <pgadmin-support@lists.postgresql.org>
Content-Language: en-US, nl
Archived-At: 
 <https://www.postgresql.org/message-id/b0032df7-8365-4ebc-a0d1-add2890ef52d%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------RpY8BK6HDh8cR2eM6UTBXd8V
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit


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


--------------RpY8BK6HDh8cR2eM6UTBXd8V
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html data-lt-installed="true">
  <head>
    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body style="padding-bottom: 1px;">
    <br>
    <br>
    Hi all,<br>
    <br>
    <br>
    Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500
    error/Access denied<br>
    <br>
    The rest of the pgadmin4 application is working like normal..<br>
    <br>
    I can run any sql queries without problems, just cannot load or save
    any files!<br>
    <br>
    <br>
    What did I do/remember:<br>
    <br>
    1) recently updated postgresql to 17.5 on manjaro rolling release.<br>
    <br>
    2) I remember that I went to the root of the storage when it started
    to act weird. Not sure this is connected though<br>
    <br>
    3) When I try opening any file stored in the storage, I'm getting
    ... <br>
    "Request failed with status code 500" <br>
    ... 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).<br>
    <br>
    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.<br>
    <br>
    5) ...I changed CONSOLE_LOG_LEVEL = 10 in the hope to see more but
    alas... <br>
    <br>
    6) ...I enabled postgresql log to see something comes up there, but
    no postgresql seems quietly doing it's thing..<br>
    <br>
    7) I checked the ...<br>
    STORAGE_DIR = "/data/databases/pgadmin4/storage"<br>
    ... and all is owned by the pgadmin user.<br>
    <br>
    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.<br>
    <br>
    9) BUT when I create a new sql script and try to save it or "save
    as" I am getting an "Access denied" message :<br>
    "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)"<br>
    (The message keeps appending my last attempts, btw)<br>
    <br>
    <br>
    Did anybody else had this problem before?<br>
    <br>
    ... and know how to fix it? <br>
    <br>
    ... or knows a way to track down the 500 error of the app.<br>
    <br>
    <br>
    or is this git issue material?<br>
    <br>
    Cheers,<br>
    <br>
    Bastiaan<br>
    <br>
    <br>
    <br>
  </body>
</html>

--------------RpY8BK6HDh8cR2eM6UTBXd8V--