Error on fresh-installed PostgreSQL + PGadmin

Поиск

Список

Период

Сортировка

От	Тимофей Пан
Тема	Error on fresh-installed PostgreSQL + PGadmin
Дата	15 февраля 2023 г. 07:01:03
Msg-id	e1e7285d-4244-8b1f-e44d-fddc979998a2@sspv.pro обсуждение исходный текст
Список	pgadmin-support

Дерево обсуждения

Hello. I'm getting an error on launching PGadmin4 right after installing "postgresql-12.14-1-windows-x64" on Windows Server 2012R2 Build 9600.
The error saying "The pgAdmin 4 server could not be contacted:

pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "C:\Program Files\PostgreSQL\12\pgAdmin 4\python\python.exe"
Runtime Config File: "C:\Users\Администратор.DOBRO\AppData\Roaming\pgadmin\runtime_config.json"
pgAdmin Config File: "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\config.py"
Webapp Path: "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgAdmin4.py"
pgAdmin Command: "C:\Program Files\PostgreSQL\12\pgAdmin 4\python\python.exe -s C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgAdmin4.py"
Environment:
- ALLUSERSPROFILE: C:\ProgramData
- APPDATA: C:\Users\Администратор.DOBRO\AppData\Roaming
- CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_1428_KWJZEMYPAOXYAGDS
- CHROME_RESTART: NW.js|Произошел сбой NW.js. Перезапустить?|LEFT_TO_RIGHT
- CLIENTNAME: DDADMIN
- CommonProgramFiles: C:\Program Files\Common Files
- CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
- CommonProgramW6432: C:\Program Files\Common Files
- COMPUTERNAME: EPS
- ComSpec: C:\Windows\system32\cmd.exe
- FP_NO_HOST_CHECK: NO
- HOMEDRIVE: C:
- HOMEPATH: \Users\Администратор.DOBRO
- LOCALAPPDATA: C:\Users\Администратор.DOBRO\AppData\Local
- LOGONSERVER: \\DC1
- NUMBER_OF_PROCESSORS: 4
- OS: Windows_NT
- Path: C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files\Microsoft SQL Server\120\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\;C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\;C:\Program Files (x86)\Intel\UCRT\;C:\Program Files\Intel\UCRT\;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT
- PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
- PGADMIN_INT_KEY: bacd94c2-cabf-4152-9e40-a3fce8054470
- PGADMIN_INT_PORT: 61917
- PGADMIN_SERVER_MODE: OFF
- PROCESSOR_ARCHITECTURE: AMD64
- PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 158 Stepping 9, GenuineIntel
- PROCESSOR_LEVEL: 6
- PROCESSOR_REVISION: 9e09
- ProgramData: C:\ProgramData
- ProgramFiles: C:\Program Files
- ProgramFiles(x86): C:\Program Files (x86)
- ProgramW6432: C:\Program Files
- PSModulePath: C:\Windows\system32\WindowsPowerShell\v1.0\Modules\;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\PowerShell\Modules\
- PUBLIC: C:\Users\Public
- SESSIONNAME: RDP-Tcp#7
- SystemDrive: C:
- SystemRoot: C:\Windows
- TEMP: C:\Users\0061~1.DOB\AppData\Local\Temp\2
- TMP: C:\Users\0061~1.DOB\AppData\Local\Temp\2
- USERDNSDOMAIN: DOBRO.LOCAL
- USERDOMAIN: DOBRO
- USERDOMAIN_ROAMINGPROFILE: DOBRO
- USERNAME: Администратор
- USERPROFILE: C:\Users\Администратор.DOBRO
- windir: C:\Windows
--------------------------------------------------------

Total spawn time to start the pgAdmin4 server: 0.014 Sec
Traceback (most recent call last):
File "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgAdmin4.py", line 38, in <module>

    import config
File "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\config.py", line 25, in <module>
    from pgadmin.utils import env, IS_WIN, fs_short_path
File "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgadmin\__init__.py", line 24, in <module>
    from flask_socketio import SocketIO
File "C:\Program Files\PostgreSQL\12\pgAdmin 4\python\lib\site-packages\flask_socketio\__init__.py", line 21, in <module>
    import socketio
File "C:\Program Files\PostgreSQL\12\pgAdmin 4\python\lib\site-packages\socketio\__init__.py", line 3, in <module>
    from .client import Client
File "C:\Program Files\PostgreSQL\12\pgAdmin 4\python\lib\site-packages\socketio\client.py", line 7, in <module>
    import engineio
File "C:\Program Files\PostgreSQL\12\pgAdmin 4\python\lib\site-packages\engineio\__init__.py", line 3, in <module>
    from .client import Client
File "C:\Program Files\PostgreSQL\12\pgAdmin 4\python\lib\site-packages\engineio\client.py", line 6, in <module>
    import ssl
File "ssl.py", line 99, in <module>
ImportError: DLL load failed while importing _ssl: �� ."

I've been trying to find the answer to that on the internet for a while, but all what i could find was to open pgadmin as administrator etc.

Please, can you help me resolve the problem with PGAdmin4?

С уважением,

Пан Тимофей Владимирович
ООО «ССПВ»
Специалист ИТ отдела
Моб. номер: +79133997762
Вн. номер: *911
г. Новосибирск, ул. Станционная 30А
t.pan@sspv.pro
SSPV.pro