RES: PgAdmin 7.0 Import/Export servers function

Additional info:

Trying to import using command line resulted in the following error:

/pgadmin4 $ python ./setup.py --load-servers /var/lib/pgadmin/storage/edson.richter_simfrete.com.br/servers-richter.json
Traceback (most recent call last):
File "/pgadmin4/./setup.py", line 24, in <module>
import config
File "/pgadmin4/config.py", line 25, in <module>
from pgadmin.utils import env, IS_WIN, fs_short_path
File "/pgadmin4/pgadmin/__init__.py", line 24, in <module>
from flask import Flask, abort, request, current_app, session, url_for
ModuleNotFoundError: No module named 'flask'

Thanks,
ER

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

De: Edson Richter<mailto:edsonrichter(at)hotmail(dot)com>
Enviado:domingo, 23 de abril de 2023 13:49
Para: Pgadmin-Support(at)Postgresql(dot) Org<mailto:pgadmin-support(at)postgresql(dot)org>
Assunto: PgAdmin 7.0 Import/Export servers function

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 Safari/537.36"

Could you help me to import the servers file?

This is the error window:

[cid:image003(dot)png(at)01D975EB(dot)C4819010]

Thanks,

ER

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