Re: SSH Tunnel Broken on version 6.14 - Mailing list pgadmin-support

I’ve been using PGAdmin V5.0 to SSH Tunnel to an AWS RDS PostgreSQL DB through an AWS EC2 VM for quite a while now with no problems.

The tunnel uses a pem key with a password.

Luckily I didn’t uninstall this version as I can still get connected, however yesterday I installed V6.14 but keep getting a ‘cannot establish SSH gateway’ error message as follows!!

 

********************************************************************************

2022-10-11 20:22:48,238: ERROR      pgadmin:        Could not establish session to SSH gateway

Traceback (most recent call last):

  File "C:\Program Files\pgAdmin 4\v6\web\pgadmin\utils\driver\psycopg2\server_manager.py", line 587, in create_ssh_tunnel

    self.tunnel_object.start()

  File "C:\Program Files\pgAdmin 4\v6\python\lib\site-packages\sshtunnel.py", line 1331, in start

    self._raise(BaseSSHTunnelForwarderError,

  File "C:\Program Files\pgAdmin 4\v6\python\lib\site-packages\sshtunnel.py", line 1174, in _raise

    raise exception(reason)

sshtunnel.BaseSSHTunnelForwarderError: Could not establish session to SSH gateway

2022-10-11 20:22:48,243: ERROR      pgadmin:        Could not connect to server(#7) - 'Ubipix Database'.

Error: Failed to create the SSH tunnel.

Error: Could not establish session to SSH gateway

********************************************************************************

 

The startup log is as follows:

********************************************************************************

ALLOW_SAVE_PASSWORD = True

ALLOW_SAVE_TUNNEL_PASSWORD = False

APP_COPYRIGHT = "Copyright (C) 2013 - 2022, The pgAdmin Development Team"

APP_ICON = "pg-icon"

APP_NAME = "pgAdmin 4"

APP_RELEASE = 6

APP_REVISION = 14

APP_SUFFIX = ""

APP_VERSION = "6.14"

APP_VERSION_EXTN = ('.css', '.js', '.html', '.svg', '.png', '.gif', '.ico')

APP_VERSION_INT = 61400

APP_VERSION_PARAM = "ver"

AUTHENTICATION_SOURCES = ['internal']

AUTO_DISCOVER_SERVERS = True

AZURE_CREDENTIAL_CACHE_DIR = "........\Roaming\pgadmin\azurecredentialcache"

CA_FILE = "C:\Program Files\pgAdmin 4\v6\web\cacert.pem"

CHECK_EMAIL_DELIVERABILITY = False

CHECK_SESSION_FILES_INTERVAL = 24

CHECK_SUPPORTED_BROWSER = True

COMPRESS_LEVEL = 9

COMPRESS_MIMETYPES = ['text/html', 'text/css', 'text/xml', 'application/json', 'application/javascript']

COMPRESS_MIN_SIZE = 500

CONSOLE_LOG_FORMAT = "%(asctime)s: %(levelname)s        %(name)s:      %(message)s"

CONSOLE_LOG_LEVEL = 30

CONTENT_SECURITY_POLICY = "default-src ws: http: data: blob: 'unsafe-inline' 'unsafe-eval';"

COOKIE_DEFAULT_DOMAIN = None

COOKIE_DEFAULT_PATH = "/"

DATA_DIR = ".......\AppData\Roaming\pgadmin"

DEBUG = False

DEFAULT_BINARY_PATHS = {'pg': '$DIR/../runtime', 'ppas': ''}

DEFAULT_SERVER = "127.0.0.1"

DEFAULT_SERVER_PORT = 5050

DESKTOP_USER = "pgadmin4@pgadmin.org"

EFFECTIVE_SERVER_PORT = 58388

ENABLE_BINARY_PATH_BROWSING = False

ENABLE_PSQL = True

ENHANCED_COOKIE_PROTECTION = True

FILE_LOG_FORMAT = "%(asctime)s: %(levelname)s        %(name)s: %(message)s"

FILE_LOG_LEVEL = 30

HELP_PATH = "../../../docs/en_US/html/"

IS_WIN = True

KERBEROS_CCACHE_DIR = ".......\AppData\Roaming\pgadmin\krbccache"

KRB_APP_HOST_NAME = "127.0.0.1"

KRB_AUTO_CREATE_USER = True

KRB_KTNAME = "<KRB5_KEYTAB_FILE>"

LANGUAGES = {'en': 'English', 'zh': 'Chinese (Simplified)', 'cs': 'Czech', 'fr': 'French', 'de': 'German', 'it': 'Italian', 'ja': 'Japanese', 'ko': 'Korean', 'pl': 'Polish', 'pt_BR': 'Portuguese (Brazilian)', 'ru': 'Russian', 'es': 'Spanish'}

LDAP_ANONYMOUS_BIND = False

LDAP_AUTO_CREATE_USER = True

LDAP_BASE_DN = "<Base-DN>"

LDAP_BIND_USER = None

LDAP_CA_CERT_FILE = ""

LDAP_CERT_FILE = ""

LDAP_CONNECTION_TIMEOUT = 10

LDAP_DN_CASE_SENSITIVE = False

LDAP_KEY_FILE = ""

LDAP_SEARCH_BASE_DN = "<Search-Base-DN>"

LDAP_SEARCH_FILTER = "(objectclass=*)"

LDAP_SEARCH_SCOPE = "SUBTREE"

LDAP_SERVER_URI = "ldap://<ip-address>:<port>"

LDAP_USERNAME_ATTRIBUTE = "<User-id>"

LDAP_USE_STARTTLS = False

LOGIN_ATTEMPT_FIELDS = ['password']

LOGIN_BANNER = ""

LOG_FILE = ".......\AppData\Roaming\pgadmin\pgadmin4.log"

LOG_ROTATION_AGE = 1440

LOG_ROTATION_MAX_LOG_FILES = 90

LOG_ROTATION_SIZE = 10

MAIL_DEBUG = False

MAIL_PORT = 25

MAIL_SERVER = "localhost"

MAIL_USERNAME = ""

MAIL_USE_SSL = False

MAIL_USE_TLS = False

MASTER_PASSWORD_REQUIRED = True

MAX_LOGIN_ATTEMPTS = 3

MAX_QUERY_HIST_STORED = 20

MAX_SESSION_IDLE_TIME = 60

MFA_EMAIL_SUBJECT = None

MFA_ENABLED = False

MFA_FORCE_REGISTRATION = False

MFA_SUPPORTED_METHODS = ['email', 'authenticator']

MODULE_BLACKLIST = ['test']

NODE_BLACKLIST = []

OAUTH2_AUTO_CREATE_USER = True

OAUTH2_CONFIG = [{'OAUTH2_NAME': None, 'OAUTH2_DISPLAY_NAME': '<Oauth2 Display Name>', 'OAUTH2_CLIENT_ID': None, 'OAUTH2_CLIENT_SECRET': None, 'OAUTH2_TOKEN_URL': None, 'OAUTH2_AUTHORIZATION_URL': None, 'OAUTH2_API_BASE_URL': None, 'OAUTH2_USERINFO_ENDPOINT': None, 'OAUTH2_SCOPE': None, 'OAUTH2_ICON': None, 'OAUTH2_BUTTON_COLOR': None}]

ON_DEMAND_RECORD_COUNT = 1000

OVERRIDE_USER_INACTIVITY_TIMEOUT = True

PG_DEFAULT_DRIVER = "psycopg2"

PROXY_X_FOR_COUNT = 1

PROXY_X_HOST_COUNT = 0

PROXY_X_PORT_COUNT = 1

PROXY_X_PREFIX_COUNT = 0

PROXY_X_PROTO_COUNT = 1

SECURITY_EMAIL_SENDER = "no-reply@localhost"

SECURITY_EMAIL_SUBJECT_PASSWORD_CHANGE_NOTICE = "Your password for pgAdmin 4 has been changed"

SECURITY_EMAIL_SUBJECT_PASSWORD_NOTICE = "Your pgAdmin 4 password has been reset"

SECURITY_EMAIL_SUBJECT_PASSWORD_RESET = "Password reset instructions for pgAdmin 4"

SECURITY_EMAIL_VALIDATOR_ARGS = {'check_deliverability': False}

SEND_FILE_MAX_AGE_DEFAULT = 31556952

SERVER_MODE = False

SESSION_COOKIE_DOMAIN = None

SESSION_COOKIE_HTTPONLY = True

SESSION_COOKIE_NAME = "pga4_session"

SESSION_COOKIE_SAMESITE = "Lax"

SESSION_COOKIE_SECURE = False

SESSION_DB_PATH = "......\AppData\Roaming\pgadmin\sessions"

SESSION_EXPIRATION_TIME = 7

SESSION_SKIP_PATHS = ['/misc/ping']

SETTINGS_SCHEMA_VERSION = 33

SHOW_GRAVATAR_IMAGE = True

SQLALCHEMY_TRACK_MODIFICATIONS = False

SQLITE_PATH = ".......\AppData\Roaming\pgadmin\pgadmin4.db"

SQLITE_TIMEOUT = 500

STORAGE_DIR = "......\AppData\Roaming\pgadmin\storage"

STRICT_TRANSPORT_SECURITY = "max-age=31536000; includeSubDomains"

STRICT_TRANSPORT_SECURITY_ENABLED = False

SUPPORT_SSH_TUNNEL = True

TEST_SQLITE_PATH = "......\AppData\Roaming\pgadmin\test_pgadmin4.db"

THREADED_MODE = True

UPGRADE_CHECK_ENABLED = True

UPGRADE_CHECK_KEY = "pgadmin4"

UPGRADE_CHECK_URL = "https://www.pgadmin.org/versions.json"

USER_INACTIVITY_TIMEOUT = 0

WEBSERVER_AUTO_CREATE_USER = True

WEBSERVER_REMOTE_USER = "REMOTE_USER"

WEB_SERVER = "Python"

WTF_CSRF_HEADERS = ['X-pgA-CSRFToken']

X_CONTENT_TYPE_OPTIONS = "nosniff"

X_FRAME_OPTIONS = "SAMEORIGIN"

X_XSS_PROTECTION = "1; mode=block"

********************************************************************************

 

Sent from Mail for Windows