RE: Problems connecting PGAdmin to server

[Samuel Holmes]

I think it’s more likely to be my university’s WiFi.  I use the same computer 
at home as I do in university (my laptop).  How do I check to make sure that 
Heroku isn’t blocking traffic?

So if I speak to my university’s IT department, what do I need to tell them?  
Is it just a case of opening that port, or do I need to do something else?

Thanks,

[Ulster University]
Samuel Holmes
PhD Researcher
T: 028 9036 8132
E: holme...@ulster.ac.uk W: www.ulster.ac.uk<http://www.ulster.ac.uk/>
Social: Twitter: @SamuelH1982
 LinkedIn: samuelholmes82<http://www.linkedin.com/in/samuelholmes82>


From: David G. Johnston [mailto:david.g.johns...@gmail.com]
Sent: 29 January 2018 16:03
To: Samuel Holmes <holme...@ulster.ac.uk>
Cc: pgadmin-support@lists.postgresql.org
Subject: Re: Problems connecting PGAdmin to server

On Mon, Jan 29, 2018 at 8:46 AM, Samuel Holmes 
<holme...@ulster.ac.uk<mailto:holme...@ulster.ac.uk>> wrote:
I am using Pgadmin as a frontend to maintain a Postgresql database hosted on 
Heroku.  If I connect to the database from my home wifi connection, it connects 
successfully.  It also connects successfully if I tether using my mobile phone. 
 However if I use my university’s student WiFi, I cannot connect and I get the 
following error:

could not connect to server: Connection timed out (0x274C/10060) Is the 
server running on host  () and accepting TCP/IP 
connections on port 5432?

How do I even begin to troubleshoot this?  I have checked that Pgadmin has 
permission in my firewall (it does), and I have checked that port, username, 
host, and password are correct (which they are as it works from home).  I 
thought maybe the port was blocked, so I used an online port checker – while it 
DID say port 5432 was closed on my university WiFi it also says this when 
tethered with my phone – but the connection DOES work on my phone.

Two simple possibilities:
Heroku is blocking on their (the server) side, not yours (the client).​
The University is blocking outbound traffic on that port.

I suspect you can check and configure the first one; the second one you'd need 
to inquire with your university's IT department.

You are using the same machine at home and at the university?  If so that 
should preclude it being your machine (though its possible your firewall has 
different settings when connected to the different wifi networks).

Online port checkers are prone to false negatives.

David J.



This email and any attachments are confidential and intended solely for the use 
of the addressee and may contain information which is covered by legal, 
professional or other privilege. If you have received this email in error 
please notify the system manager at postmas...@ulster.ac.uk and delete this 
email immediately. Any views or opinions expressed are solely those of the 
author and do not necessarily represent those of Ulster University.
The University's computer systems may be monitored and communications carried 
out on them may be recorded to secure the effective operation of the system and 
for other lawful purposes. Ulster University does not guarantee that this email 
or any attachments are free from viruses or 100% secure. Unless expressly 
stated in the body of a separate attachment, the text of email is not intended 
to form a binding contract. Correspondence to and from the University may be 
subject to requests for disclosure by 3rd parties under relevant legislation.
The Ulster University was founded by Royal Charter in 1984 and is registered 
with company number RC000726 and VAT registered number GB672390524.The primary 
contact address for Ulster University in Northern Ireland is Cromore Road, 
Coleraine, Co. Londonderry BT52 1SA

Re: Problems connecting PGAdmin to server

[David G. Johnston]

On Mon, Jan 29, 2018 at 8:46 AM, Samuel Holmes 
wrote:

> I am using Pgadmin as a frontend to maintain a Postgresql database hosted
> on Heroku.  If I connect to the database from my home wifi connection, it
> connects successfully.  It also connects successfully if I tether using my
> mobile phone.  However if I use my university’s student WiFi, I cannot
> connect and I get the following error:
>
>
>
> could not connect to server: Connection timed out (0x274C/10060) Is
> the server running on host  () and accepting TCP/IP
> connections on port 5432?
>
>
>
> How do I even begin to troubleshoot this?  I have checked that Pgadmin has
> permission in my firewall (it does), and I have checked that port,
> username, host, and password are correct (which they are as it works from
> home).  I thought maybe the port was blocked, so I used an online port
> checker – while it DID say port 5432 was closed on my university WiFi it
> also says this when tethered with my phone – but the connection DOES work
> on my phone.
>

Two simple possibilities:
Heroku is blocking on their (the server) side, not yours (the client).​
The University is blocking outbound traffic on that port.

I suspect you can check and configure the first one; the second one you'd
need to inquire with your university's IT department.

You are using the same machine at home and at the university?  If so that
should preclude it being your machine (though its possible your firewall
has different settings when connected to the different wifi networks).

Online port checkers are prone to false negatives.

David J.

Problems connecting PGAdmin to server

[Samuel Holmes]

Hi there,

I'm having an issue with Pgadmin and I'd appreciate some input as I cannot find 
anything online!

I am using Pgadmin as a frontend to maintain a Postgresql database hosted on 
Heroku.  If I connect to the database from my home wifi connection, it connects 
successfully.  It also connects successfully if I tether using my mobile phone. 
 However if I use my university's student WiFi, I cannot connect and I get the 
following error:

could not connect to server: Connection timed out (0x274C/10060) Is the 
server running on host  () and accepting TCP/IP 
connections on port 5432?

How do I even begin to troubleshoot this?  I have checked that Pgadmin has 
permission in my firewall (it does), and I have checked that port, username, 
host, and password are correct (which they are as it works from home).  I 
thought maybe the port was blocked, so I used an online port checker - while it 
DID say port 5432 was closed on my university WiFi it also says this when 
tethered with my phone - but the connection DOES work on my phone.

I really need this to be working, as it means that I cannot access the database 
from within university - pointless as it is part of my course to do so!

Thanks,

Sam



This email and any attachments are confidential and intended solely for the use 
of the addressee and may contain information which is covered by legal, 
professional or other privilege. If you have received this email in error 
please notify the system manager at postmas...@ulster.ac.uk and delete this 
email immediately. Any views or opinions expressed are solely those of the 
author and do not necessarily represent those of Ulster University.
The University's computer systems may be monitored and communications carried 
out on them may be recorded to secure the effective operation of the system and 
for other lawful purposes. Ulster University does not guarantee that this email 
or any attachments are free from viruses or 100% secure. Unless expressly 
stated in the body of a separate attachment, the text of email is not intended 
to form a binding contract. Correspondence to and from the University may be 
subject to requests for disclosure by 3rd parties under relevant legislation.
The Ulster University was founded by Royal Charter in 1984 and is registered 
with company number RC000726 and VAT registered number GB672390524.The primary 
contact address for Ulster University in Northern Ireland is Cromore Road, 
Coleraine, Co. Londonderry BT52 1SA