RES: PgAdmin 7.0 Import/Export servers function

From: Edson Richter <edsonrichter(at)hotmail(dot)com>
To: Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
Cc: "Pgadmin-Support(at)Postgresql(dot) Org" <pgadmin-support(at)postgresql(dot)org>
Subject: RES: PgAdmin 7.0 Import/Export servers function
Date: 2023-04-24 13:24:36
Message-ID: CPVP215MB18237083ED787776411992E2CF679@CPVP215MB1823.LAMP215.PROD.OUTLOOK.COM
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Ok, thanks - it seems the problem is my setup. I’ve been upgrading since early days of pgAdmin 4.7 or 4.8 – can’t remember now – may be something wen’t not so well.
Would you mind to guide me how can I debug this issue?
Or where do I get detailed logs (besides docker logs)?
Can I activate a higher log level to debug this issue?

Thanks in advance,

ER

Enviado do Email<https://go.microsoft.com/fwlink/?LinkId=550986> para Windows

De: Akshay Joshi<mailto:akshay(dot)joshi(at)enterprisedb(dot)com>
Enviado:segunda-feira, 24 de abril de 2023 06:14
Para: Edson Richter<mailto:edsonrichter(at)hotmail(dot)com>
Cc:Pgadmin-Support(at)Postgresql(dot) Org<mailto:pgadmin-support(at)postgresql(dot)org>
Assunto: Re: PgAdmin 7.0 Import/Export servers function

Hi Edson

I am not able to reproduce the issue. Performed exact steps as mentioned above

[cid:image001(dot)png(at)01D97696(dot)F6FB8130]

Import/Export Dialog

[cid:image002(dot)png(at)01D97696(dot)F6FB8130]

On Sun, Apr 23, 2023 at 10:19 PM Edson Richter <edsonrichter(at)hotmail(dot)com<mailto:edsonrichter(at)hotmail(dot)com>> wrote:
Pgadmin 7.0 running on Docker/Linux.

- What I’m doing: migrating from one (old) username to anoter (new) username.
- Both users have the role “Admin”.
- I can login both users, so there are no permissions or access issues.

Steps done:

1. Login with old username, and exported all servers in a file called “servers-richter.json”
2. Copied file from “storage/old-username” to “storage/new-username” (I’ve used the old lazy way, via docker exec -ti ... /bin/sh)
3. Logout from old username, and login as new username
4. Open the “import servers” window, and the file appears there
5. I select the file, and click next: error “Access denied (/servers-richter.json)”

Permissions are set:

“-rw-r--r-- 1 pgadmin root 58637 Apr 23 16:21 servers-richter.json”

In log, I see the following line of error:

“::ffff:192.168.0.30 - - [23/Apr/2023:16:37:14 +0000] "POST /import_export_servers/load_servers HTTP/1.1" 401 100 "https://192.168.0.251:15000/browser/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0<http://112.0.0.0> Safari/537.36"

Could you help me to import the servers file?

This is the error window:

[cid:image003(dot)png(at)01D97696(dot)F6FB8130]

Thanks,

ER

Enviado do Email<https://go.microsoft.com/fwlink/?LinkId=550986> para Windows

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Aykan Inal 2023-04-25 06:10:36 howto export txt
Previous Message Akshay Joshi 2023-04-24 09:13:47 Re: PgAdmin 7.0 Import/Export servers function