pgadmin4 icon indicating copy to clipboard operation
pgadmin4 copied to clipboard

The pgAdmin 4 server could not be contacted

Open deja94 opened this issue 1 year ago • 0 comments

Hi,

I have tried all of the available versions of the pgAdmin, and still get the following error when trying to start it (as administrator):

pgAdmin Runtime Environment

Python Path: "C:\Program Files\pgAdmin 4\python\python.exe" Runtime Config File: "C:\Users\USERNAME\AppData\Roaming\pgadmin\runtime_config.json" pgAdmin Config File: "C:\Program Files\pgAdmin 4\web\config.py" Webapp Path: "C:\Program Files\pgAdmin 4\web\pgAdmin4.py" pgAdmin Command: "C:\Program Files\pgAdmin 4\python\python.exe -s C:\Program Files\pgAdmin 4\web\pgAdmin4.py" Environment:

  • ADSK_3DSMAX_x64_2017: C:\Program Files\Autodesk\3ds Max 2017\
  • ALLUSERSPROFILE: C:\ProgramData
  • APPDATA: C:\Users\USERNAME\AppData\Roaming
  • CHROME_CRASHPAD_PIPE_NAME: \.\pipe\crashpad_18948_RXNSRJPXRNJIXZIY
  • CHROME_RESTART: NW.js|Whoa! NW.js has crashed. Relaunch now?|LEFT_TO_RIGHT
  • CommonProgramFiles: C:\Program Files\Common Files
  • CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
  • CommonProgramW6432: C:\Program Files\Common Files
  • COMPUTERNAME: xxx
  • ComSpec: C:\WINDOWS\system32\cmd.exe
  • DriverData: C:\Windows\System32\Drivers\DriverData
  • HOMEDRIVE: C:
  • HOMEPATH: \Users\USERNAME
  • LOCALAPPDATA: C:\Users\USERNAME\AppData\Local
  • LOGONSERVER: \DESKTOP-RVTE6BS
  • NUMBER_OF_PROCESSORS: 6
  • OneDrive: C:\Users\USERNAME\OneDrive
  • OS: Windows_NT
  • Path: C:\Program Files\pgAdmin 4\runtime;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0;C:\Windows\System32\OpenSSH;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files\NVIDIA Corporation\NVIDIA NvDLISR;C:\Program Files\Common Files\Autodesk Shared;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0;C:\WINDOWS\System32\OpenSSH;C:\Users\Dejan Rankovic\AppData\Local\Microsoft\WindowsApps;C:\Program Files\PostgreSQL\9.6\bin
  • PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
  • PGADMIN_INT_KEY: 3fad8108-0347-424e-8310-89bf4160cffb
  • PGADMIN_INT_PORT: 5050
  • PGADMIN_SERVER_MODE: OFF
  • PROCESSOR_ARCHITECTURE: AMD64
  • PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 158 Stepping 10, GenuineIntel
  • PROCESSOR_LEVEL: 6
  • PROCESSOR_REVISION: 9e0a
  • ProgramData: C:\ProgramData
  • ProgramFiles: C:\Program Files
  • ProgramFiles(x86): C:\Program Files (x86)
  • ProgramW6432: C:\Program Files
  • PSModulePath: C:\Program Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules
  • PUBLIC: C:\Users\Public
  • SystemDrive: C:
  • SystemRoot: C:\WINDOWS
  • TEMP: C:\Users\DEJANR~1\AppData\Local\Temp
  • TMP: C:\Users\DEJANR~1\AppData\Local\Temp
  • USERDOMAIN: DESKTOP-RVTE6BS
  • USERDOMAIN_ROAMINGPROFILE: DESKTOP-RVTE6BS
  • USERNAME: USERNAME
  • USERPROFILE: C:\Users\USERNAME
  • windir: C:\WINDOWS
  • __COMPAT_LAYER: Installer

Total spawn time to start the pgAdmin4 server: 0.009 Sec Traceback (most recent call last): File "C:\Program Files\pgAdmin 4\web\pgAdmin4.py", line 48, in

import config

File "C:\Program Files\pgAdmin 4\web\config.py", line 33, in from pgadmin.utils import env, IS_WIN, fs_short_path File "C:\Program Files\pgAdmin 4\web\pgadmin_init_.py", line 25, in from flask_socketio import SocketIO File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\flask_socketio_init_.py", line 9, in from socketio import socketio_manage # noqa: F401 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\socketio_init_.py", line 1, in from .client import Client File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\socketio\client.py", line 3, in import engineio File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\engineio_init_.py", line 1, in

from .client import Client

File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\engineio\client.py", line 11, in import requests File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\requests_init_.py", line 147, in

from . import packages, utils

File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\requests\utils.py", line 24, in from . import certs File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\requests\certs.py", line 14, in from certifi import where File "", line 1360, in _find_and_load File "", line 1331, in _find_and_load_unlocked File "", line 935, in _load_unlocked File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\wrapt\importer.py", line 185, in _self_exec_module

notify_module_loaded(module)

File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\wrapt\importer.py", line 118, in notify_module_loaded hook(module) File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\certifi_win32\wrapt_certifi.py", line 27, in apply_patches generate_pem() File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\certifi_win32\wincerts.py", line 121, in generate_pem

for pem in get_pems():
           ^^^^^^^^^^

File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\certifi_win32\wincerts.py", line 41, in get_pems ssl_context = ssl.create_default_context() ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "ssl.py", line 713, in create_default_context

File "ssl.py", line 534, in load_default_certs File "ssl.py", line 526, in _load_windows_store_certs

ssl.SSLError: [ASN1] nested asn1 error (_ssl.c:4028)

Could you please help me in any way? Thanks in advance

deja94 avatar May 03 '24 20:05 deja94