Re: SSH Tunnel Broken on version 6.14

Hi Paul

Compared to version 5, only the *sshtunnel* package has been upgraded.

On Thu, Oct 13, 2022 at 10:00 PM Paul & Caroline Lewis <
paulcaz80(at)hotmail(dot)com> wrote:

> Thanks for input guys but not sure what else I can check to help.
>
> Suggestions welcome and I'll try.
>
>
>
> Not a big issue my side as I can connect with version 5.0 but I’m sure
> you’d rather know what might be wrong!!
>
>
>
> Anyway, my setup is.
>
> PostgreSQL is 14.1 running on an AWS RDS service.
>
> Tunnel VM is an old AWS EC2 VM running Ubuntu 14. (Can try a newer version
> if possible issue there.)
>
> My machine is Windows 10.
>
> My PEM key is password protected.
>
>
>
> The strange bit is that I can currently connect fine from PGAdmin V5.0 but
> get the SSH gateway error when I try PGAdmin V6.14 on the same setup.
>
> I have V5 and V6 running on the same Windows 10 Machine.
>
> 1 difference in the 2 connections involves the connection dialogue, in
> images below.
>
> Both versions pop up a dialogue to enter the key password and database
> password.
>
> But V5.0 dialogue doesn't request my PEM key password only the DB
> password, the V6 dialogue defaults to wanting me to enter it the key
> password first then the DB password.
>
> Whether I enter the key password or not V6 just results in the error shown
> in image below.
>
>
>
> I can SSH fine through Putty with that PEM key to the VM and the VM can
> connect fine to the DB.
>
>
>
> Regards
>
>
>
> Paul
>
>
>
> PGAdmin V6.14 Images
>
>
>
> PGAdmin V5.0 Images
>
>
>
>
>
> Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for
> Windows
>
>
>
> *From: *Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
> *Sent: *Thursday 13 October 2022 07:05
> *To: *Paul & Caroline Lewis <paulcaz80(at)hotmail(dot)com>
> *Cc: *pgadmin-support(at)lists(dot)postgresql(dot)org
> *Subject: *Re: SSH Tunnel Broken on version 6.14
>
>
>
> Hi Paul
>
>
>
> I am not able to reproduce the issue. I have tried today with
> the following setup:
>
> 1. VM 1 (Ubuntu 22) : PostgreSQL 13 install on this machine.
> 2. VM 2 (Windows 10): pgAdmin v6.14 installed on this machine.
> 3. Base Machine (OSX Monterey): Used for creating the SSH tunnel
> between the database server and pgAdmin. Public key created on the Windows
> machine is saved on this machine.
>
>
>
> Please refer to the attached screenshots.
>
>
>
> On Wed, Oct 12, 2022 at 3:30 PM Paul & Caroline Lewis <
> paulcaz80(at)hotmail(dot)com> wrote:
>
> 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(at)pgadmin(dot)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(at)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 <https://go.microsoft.com/fwlink/?LinkId=550986> for
> Windows
>
>
>
>
>
>
> --
>
> <http://www.enterprisedb.com>
>
> *Akshay Joshi*
>
> Principal Software Architect
>
> +91 9767888246
>
> *www.enterprisedb.com* <http://www.enterprisedb.com>
>
>
>
>
>

--

<http://www.enterprisedb.com>

Akshay Joshi

Principal Software Architect

+91 9767888246

www.enterprisedb.com