RES: PgAdmin 7.0 Import/Export servers function - Mailing list pgadmin-support

From Edson Richter
Subject RES: PgAdmin 7.0 Import/Export servers function
Date
Msg-id CPVP215MB1823EB869D304C298600E183CF669@CPVP215MB1823.LAMP215.PROD.OUTLOOK.COM
Whole thread Raw
In response to PgAdmin 7.0 Import/Export servers function  (Edson Richter <edsonrichter@hotmail.com>)
List pgadmin-support

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 para Windows

 

De: Edson Richter
Enviado:domingo, 23 de abril de 2023 13:49
Para: Pgadmin-Support@Postgresql. 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:

 

 

 

Thanks,

 

ER

 

Enviado do Email para Windows

 

 

Attachment

pgadmin-support by date:

Previous
From: Edson Richter
Date:
Subject: PgAdmin 7.0 Import/Export servers function
Next
From: Akshay Joshi
Date:
Subject: Re: PgAdmin 7.0 Import/Export servers function