Failed connection over SSH Tunnel

From: John Anwana <it-support(at)g6-global(dot)com>
To: "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Failed connection over SSH Tunnel
Date: 2022-09-06 15:28:22
Message-ID: AM6PR0302MB3205028C9B8577D1FACE7E229D7E9@AM6PR0302MB3205.eurprd03.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hello,

I am having problem using PG Admin 4 to connect to my ubuntu server hosting a PostgreSQL database.

It appears to successfully connect over the ssh tunnel, because it shows a different ssh specific error if I use the wrong username or password

However, I get this error message:

Unable to connect to server: connection to server at 127.0.0.1, port 8761 failed: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.

My question is thus, why is PG Admin trying to connect using port 8761 instead of 5432 as specified in the register server dialog box?

Each time I try again, I get another error with a different pot, almost as if PG admin is using random ports to connect with the DB.

Attached are screenshots of my config.

[cid:image005(dot)png(at)01D8C20D(dot)AC598160]

[cid:image006(dot)png(at)01D8C20D(dot)AC598160]

I would appreciate any assistance on this matter,

Regards,
John Anwana
IT Support
G6 Global | Delivering Critical Communications
[cid:image001(dot)png(at)01D8C20D(dot)8B769F00]
m. +44 (0)7755 2023717
|
t. +44 (0)1454 610050
e. it-support(at)g6-global(dot)com<mailto:it-support(at)g6-global(dot)com>
|
w. www.g6-global.com<http://www.g6-global.com/>
skype. Jayanwana
|
The Old Workshop, Hortham Farm, Bristol BS32 4JW UK
[cid:image002(dot)png(at)01D8C20D(dot)8B769F00]<https://www.linkedin.com/in/andy-clark-86618223/>
[cid:image003(dot)png(at)01D8C20D(dot)8B769F00]<https://twitter.com/andyclark_g6>
[cid:image004(dot)png(at)01D8C20D(dot)8B769F00]<https://www.facebook.com/profile.php?id=100000032137882>
This email and the information it contains may be privileged and/or confidential. It is for the intended addressee(s) only. The unauthorised use, disclosure or copying of this email or any information it contains; Is prohibited and could, in certain circumstances, be a criminal offence. If you are not an intended recipient, please notify the originator support(at)g6-global(dot)com<mailto:support(at)g6-global(dot)com> immediately.
Calcom Holdings Ltd (trading as G6 Global) is a company registered in the United Kingdom . Registered number: 3740662 . Registered office: The Old Workshop, Hortham Farm, Bristol, BS32 4JW.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Rohan Nautiyal (TMNA) 2022-09-06 16:54:28 Opening multiple instances of PgAdmin4 v6
Previous Message Igor Olenev 2022-09-06 11:38:23 Re: Error