public inbox for [email protected]
help / color / mirror / Atom feedOpening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied
7+ messages / 2 participants
[nested] [flat]
* Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied
@ 2025-10-11 10:10 Bastiaan Wakkie <[email protected]>
2025-10-13 05:04 ` Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied Aditya Toshniwal <[email protected]>
2025-10-18 15:20 ` Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied Bastiaan Wakkie <[email protected]>
0 siblings, 2 replies; 7+ messages in thread
From: Bastiaan Wakkie @ 2025-10-11 10:10 UTC (permalink / raw)
To: [email protected] <[email protected]>
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied
2025-10-11 10:10 Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied Bastiaan Wakkie <[email protected]>
@ 2025-10-13 05:04 ` Aditya Toshniwal <[email protected]>
1 sibling, 0 replies; 7+ messages in thread
From: Aditya Toshniwal @ 2025-10-13 05:04 UTC (permalink / raw)
To: Bastiaan Wakkie <[email protected]>; +Cc: [email protected] <[email protected]>
Hi Bastiaan,
Can you share pgAdmin logs (whatever it has)?
Also check the permission of /data/databases/pgadmin4/<USER> directory.
On Sat, Oct 11, 2025 at 3:41 PM 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
>
>
>
>
--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com*
<https://www.enterprisedb.com/;
"Don't Complain about Heat, Plant a TREE"
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied
2025-10-11 10:10 Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied Bastiaan Wakkie <[email protected]>
@ 2025-10-18 15:20 ` Bastiaan Wakkie <[email protected]>
2025-10-22 06:51 ` Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied Aditya Toshniwal <[email protected]>
1 sibling, 1 reply; 7+ messages in thread
From: Bastiaan Wakkie @ 2025-10-18 15:20 UTC (permalink / raw)
To: [email protected] <[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
>
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied
2025-10-11 10:10 Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied Bastiaan Wakkie <[email protected]>
2025-10-18 15:20 ` Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied Bastiaan Wakkie <[email protected]>
@ 2025-10-22 06:51 ` Aditya Toshniwal <[email protected]>
2025-10-22 12:47 ` Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied Aditya Toshniwal <[email protected]>
0 siblings, 1 reply; 7+ messages in thread
From: Aditya Toshniwal @ 2025-10-22 06:51 UTC (permalink / raw)
To: Bastiaan Wakkie <[email protected]>; +Cc: [email protected] <[email protected]>
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 <[email protected]> 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 <[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
> >
> >
> >
>
>
>
>
--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com*
<https://www.enterprisedb.com/;
"Don't Complain about Heat, Plant a TREE"
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied
2025-10-11 10:10 Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied Bastiaan Wakkie <[email protected]>
2025-10-18 15:20 ` Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied Bastiaan Wakkie <[email protected]>
2025-10-22 06:51 ` Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied Aditya Toshniwal <[email protected]>
@ 2025-10-22 12:47 ` Aditya Toshniwal <[email protected]>
2025-10-23 07:44 ` Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied Bastiaan Wakkie <[email protected]>
0 siblings, 1 reply; 7+ messages in thread
From: Aditya Toshniwal @ 2025-10-22 12:47 UTC (permalink / raw)
To: Bastiaan Wakkie <[email protected]>; +Cc: [email protected] <[email protected]>
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 <
[email protected]> 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 <[email protected]> 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 <[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
>> >
>> >
>> >
>>
>>
>>
>>
>
> --
> 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"
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied
2025-10-11 10:10 Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied Bastiaan Wakkie <[email protected]>
2025-10-18 15:20 ` Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied Bastiaan Wakkie <[email protected]>
2025-10-22 06:51 ` Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied Aditya Toshniwal <[email protected]>
2025-10-22 12:47 ` Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied Aditya Toshniwal <[email protected]>
@ 2025-10-23 07:44 ` Bastiaan Wakkie <[email protected]>
2025-10-23 14:16 ` Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied Aditya Toshniwal <[email protected]>
0 siblings, 1 reply; 7+ messages in thread
From: Bastiaan Wakkie @ 2025-10-23 07:44 UTC (permalink / raw)
To: Aditya Toshniwal <[email protected]>; +Cc: [email protected] <[email protected]>
Hi Aditya,
Yes!!
I can confirm that it was exactly the same problem. Somehow, the last
storage went into this 'None' state.
I altered the SELECT statement (from issues/9281) to also see the pid
SELECT p.name, up.pid, up.uid, up.value FROM user_preferences AS up JOIN
preferences AS p ON p.id = up.pid order by p.name;
which gave me:
...
> last_storage|220|1|None
... and then...
UPDATE user_preferences SET value='my_storage' WHERE pid=220 AND uid=1;
... Solved it!
All I remember before I went into this 'None' state is that I went
somewhere to the root of the storage (maybe via the storage manager)
where I normally don't go.
Thanks problem solved!
Cheers,
Bastiaan
On 10/22/25 14:47, Aditya Toshniwal wrote:
> 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
> <[email protected]> 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
> <[email protected]> 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
> <[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
> >
> >
> >
>
>
>
>
>
> --
> 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"
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied
2025-10-11 10:10 Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied Bastiaan Wakkie <[email protected]>
2025-10-18 15:20 ` Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied Bastiaan Wakkie <[email protected]>
2025-10-22 06:51 ` Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied Aditya Toshniwal <[email protected]>
2025-10-22 12:47 ` Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied Aditya Toshniwal <[email protected]>
2025-10-23 07:44 ` Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied Bastiaan Wakkie <[email protected]>
@ 2025-10-23 14:16 ` Aditya Toshniwal <[email protected]>
0 siblings, 0 replies; 7+ messages in thread
From: Aditya Toshniwal @ 2025-10-23 14:16 UTC (permalink / raw)
To: Bastiaan Wakkie <[email protected]>; +Cc: [email protected] <[email protected]>
Hi Bastiaan,
Glad to hear that you're able to proceed with the workaround.
We need to fix the root cause.
On Thu, Oct 23, 2025 at 1:14 PM Bastiaan Wakkie <[email protected]> wrote:
> Hi Aditya,
>
> Yes!!
>
>
> I can confirm that it was exactly the same problem. Somehow, the last
> storage went into this 'None' state.
>
>
> I altered the SELECT statement (from issues/9281) to also see the pid
>
> SELECT p.name, up.pid, up.uid, up.value FROM user_preferences AS up JOIN
> preferences AS p ON p.id = up.pid order by p.name;
>
> which gave me:
>
> ...
>
> > last_storage|220|1|None
> ... and then...
>
> UPDATE user_preferences SET value='my_storage' WHERE pid=220 AND uid=1;
>
> ... Solved it!
>
>
> All I remember before I went into this 'None' state is that I went
> somewhere to the root of the storage (maybe via the storage manager) where
> I normally don't go.
>
>
> Thanks problem solved!
>
> Cheers,
>
> Bastiaan
>
>
> On 10/22/25 14:47, Aditya Toshniwal wrote:
>
> 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 <
> [email protected]> 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 <[email protected]>
>> 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 <[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
>>> >
>>> >
>>> >
>>>
>>>
>>>
>>>
>>
>> --
>> 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"
>
>
--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com*
<https://www.enterprisedb.com/;
"Don't Complain about Heat, Plant a TREE"
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2025-10-23 14:16 UTC | newest]
Thread overview: 7+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-10-11 10:10 Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied Bastiaan Wakkie <[email protected]>
2025-10-13 05:04 ` Aditya Toshniwal <[email protected]>
2025-10-18 15:20 ` Bastiaan Wakkie <[email protected]>
2025-10-22 06:51 ` Aditya Toshniwal <[email protected]>
2025-10-22 12:47 ` Aditya Toshniwal <[email protected]>
2025-10-23 07:44 ` Bastiaan Wakkie <[email protected]>
2025-10-23 14:16 ` Aditya Toshniwal <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox