Thread: Re: Cannot Access Remote Server [SOLVED]
On Fri, Aug 19, 2011 at 05:47, Tom Browder <tom.browder@gmail.com> wrote: > On Fri, Aug 19, 2011 at 01:09, Guillaume Lelarge <guillaume@lelarge.info> wrote: >> On Thu, 2011-08-18 at 20:41 -0500, Tom Browder wrote: >>> >> I have a remote server running postgresql (9.0.4). I have been able >>> >> to use the dbms via ssh and via phppgadmin. >>> >> >>> >> Now I would like to use pgadminIII but I cannot get the server >>> >> connection. I am running the Ubuntu version og pgadmin (1.10.5). > ... >> Any firewalls, routers that could block the connection? > >> Have you tried to connect with psql from the same computer than pgAdmin? > > Just tried--no contact. > > I muddled around in my notes--had same trouble I now see with mysql > and had to open up its port with iptables. I just tried the same > thing for postgresql and did: > > # iptables -A INPUT -p tcp --destination-port 5432 -s x.x.x.x > > where x.x.x.x is my external IP from my home network. I restarted > postgresql just in case but no connection. SOLVED!! I redid the iptables command because the line above is incorrect, it should read: # iptables -A INPUT -p tcp --destination-port 5432 -s x.x.x.x -j ACCEPT Note that the previous rule had to be deleted which I did by editing the file /etc/iptables/default and removing it and saving the file (I think there is a safer way but I didn't know how and was afraid I might remove the wrong rule). Note also there are some differences between Ubuntu and Fedora, for example the location of the rules file. If I have to do this again I would save file /etc/iptabes/default before I start messing with it. After deleting the old rule and making the corrected rule with the iptables command I did: # /etc/init.d/iptables save # /etc/init.d/iptables restart and I got in! Thanks Thom. Best regards, -Tom (Thomas)
On 19 August 2011 13:13, Tom Browder <tom.browder@gmail.com> wrote:
SOLVED!!
I redid the iptables command because the line above is incorrect, it
should read:
# iptables -A INPUT -p tcp --destination-port 5432 -s x.x.x.x -j ACCEPT
Note that the previous rule had to be deleted which I did by editing
the file /etc/iptables/default and removing it and saving the file (I
think there is a safer way but I didn't know how and was afraid I
might remove the wrong rule).
Note also there are some differences between Ubuntu and Fedora, for
example the location of the rules file. If I have to do this again I
would save file /etc/iptabes/default before I start messing with it.
After deleting the old rule and making the corrected rule with the
iptables command I did:
# /etc/init.d/iptables save
# /etc/init.d/iptables restart
and I got in!
Thanks Thom.
Well it was Guillaume who guided you in that direction, not I. :)
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
On Fri, Aug 19, 2011 at 07:15, Thom Brown <thom@linux.com> wrote: > On 19 August 2011 13:13, Tom Browder <tom.browder@gmail.com> wrote: >> >> SOLVED!! ... >> Note also there are some differences between Ubuntu and Fedora, for >> example the location of the rules file. If I have to do this again I >> would save file /etc/iptabes/default before I start messing with it. >> >> After deleting the old rule and making the corrected rule with the >> iptables command I did: >> >> # /etc/init.d/iptables save >> # /etc/init.d/iptables restart >> >> and I got in! >> >> Thanks Thom. > > Well it was Guillaume who guided you in that direction, not I. :) And thanks to Guillaume for his guidance and patience. Best regards, -Tom