Access Denied error both opening & saving scripts

[adrian-tt]

Access Denied error both opening & saving scripts

[anilsahoo20]

Hi @adrian-tt
We are not able to reproduce the issue.
Can you please share the screen recording?

[adrian-tt]

Video taken after connecting to postgresql database, opening query dialog.

Peek.2024-04-19.12-44.mp4

[anilsahoo20]

Hi @adrian-tt
Please share the file permission details from where you are selecting file in query tool.

Run ls -la

Please share the screenshot and the location of data directory, that you can find from Help->About PgAdmin 4.

[adrian-tt]

ah_pgadmin4-85.txt

Had already added rw to group and other to see if that worked (did not)

adrian@ah2022:~$ ls -la ~/.pgadmin/
total 6408
drwxrw-r-- 5 adrian adrian 4096 Apr 19 14:46 .
drwxr-xr-x 191 adrian adrian 28672 Apr 19 12:41 ..
drwxrwxr-x 2 adrian adrian 4096 Jun 12 2023 azurecredentialcache
-rw------- 1 adrian adrian 4575232 Apr 19 14:46 pgadmin4.db
-rw-rw-r-- 1 adrian adrian 1888256 Jan 16 17:57 pgadmin4.db.prev.bak
-rw-rw-r-- 1 adrian adrian 42010 Apr 15 11:57 pgadmin4.log
drwxrw---- 3 adrian adrian 4096 Apr 19 10:27 sessions
drwxrwxrwx 3 adrian adrian 4096 Jun 12 2023 storage

adrian@ah2022:~$ ls -la ~/.pgadmin/storage/
total 12
drwxrwxrwx 3 adrian adrian 4096 Jun 12 2023 .
drwxrw-r-- 5 adrian adrian 4096 Apr 19 14:46 ..
drwxrwxrw- 22 adrian adrian 4096 Apr 16 08:50 adrian.heath_tracktrans.com

adrian@ah2022:~$ ls -la ~/.pgadmin/storage/adrian.heath_tracktrans.com/a*.sql
-rw-rwxrw- 1 adrian adrian 967 Apr 11 2019 /home/adrian/.pgadmin/storage/adrian.heath_tracktrans.com/add_ems_to_subs.sql
-rw-rwxrw- 1 adrian adrian 517 Apr 8 2020 /home/adrian/.pgadmin/storage/adrian.heath_tracktrans.com/aims_dab_log_query.sql
-rw-rwxrw- 1 adrian adrian 1494 May 22 2020 /home/adrian/.pgadmin/storage/adrian.heath_tracktrans.com/aims_feb_jobs.sql
-rw-rwxrw- 1 adrian adrian 378 Nov 15 2019 /home/adrian/.pgadmin/storage/adrian.heath_tracktrans.com/alto_loads.sql
-rw-rwxrw- 1 adrian adrian 401627 Jul 19 2021 /home/adrian/.pgadmin/storage/adrian.heath_tracktrans.com/aws_epodjobs_import.sql
-rw-rwxrw- 1 adrian adrian 864 Nov 1 15:44 /home/adrian/.pgadmin/storage/adrian.heath_tracktrans.com/aws_prod_emails.sql

[adrian-tt]

Looks to be (data/file) corruption at my end.

Steps to test & resolve

1. Created new pgadmin user
2. Added one of the existing PostgreSQL servers
3. Connected to existing database
4. Opened query dialog, entered 'select current_database()' and successfully saved to test.sql file
5. Disconnected from psql server
6. Logged out of pgadmin
7. Stopped pgadmin
8. Renamed ~/.pgadmin/storage/original_user directory to original_user_broken
9. Copied ~/.pgadmin/storage/new_user to original_user
10. Restarted pgadmin
11. Logged in as original user
12. Connected to server and same database as (2)
13. Opened query dialog; newly created file from (4) visable in file list
14. Failed to open file
15. Logged out of pgadmin
16. Logged in as new_user
17. Deleted original user
18. Recreated original user
19. Copied storage/origin_user_broken files into storage/recreated_user
20. Logged in as recreated_user
21. Able to open original files and save new ones