Lightning Admin Community Forums
May 27, 2011, 09:14:07 PM
Welcome, Guest. Please login or register.

Login with username, password and session length
News: Version 1.3.4 Build 20 released on January 16th, 2007
 
   Home   Help Login Register  
Pages: [1]
  Reply  |  Print  
Author Topic: Connecting to a remote host?  (Read 2466 times)
kalpax2005
Guest
« on: February 25, 2007, 02:16:32 AM »
Quote

I'm trying to connect pgla to a postgres 8.1 installation on ubuntu which resides on a server on my lan. I think I'm pretty close but something is missing the boat. The server ip address is 192.168.1.10. The workstation ip address is 192.168.2.100. The server firewall allows connections on port 5432. I am past the 'is the server open on port 5432?' errors, now it's 'missing or erroneous pg_hba.conf'. I've added a line like this to that file:

host all all 192.168.2.100 md5

It's in keeping with the other entries. Also I edited the postgresql.conf file so that listen_address = '*'

Any clues? I'd love to keep using pgla for admin of this server.
Logged
Support Administrator
Administrator
PGLA Level3

Posts: 214


« Reply #1 on: February 25, 2007, 05:28:05 PM »
Quote

I'm trying to connect pgla to a postgres 8.1 installation on ubuntu which resides on a server on my lan. I think I'm pretty close but something is missing the boat. The server ip address is 192.168.1.10. The workstation ip address is 192.168.2.100. The server firewall allows connections on port 5432. I am past the 'is the server open on port 5432?' errors, now it's 'missing or erroneous pg_hba.conf'. I've added a line like this to that file:

host all all 192.168.2.100 md5

It's in keeping with the other entries. Also I edited the postgresql.conf file so that listen_address = '*'

Any clues? I'd love to keep using pgla for admin of this server.

I connect to servers on Linux all the time, this has nothing to do with Lightning Admin itself.  I would suggest that you make sure the pg_hba.conf has is owned by the postgres
user and make sure you did not mess up the internals of the file.  I have seen where having to many tabs between colunms would cause the server to not read the file correctly.
I would also make sure you have reloaded the server after you make changes to the pg_hba.conf file.
i.e. /etc/init.d/postgresql reload.

Hope that helps.

Logged
kalpax2005
Guest
« Reply #2 on: February 26, 2007, 10:42:33 PM »
Quote

I knew it was an issue of ignorance and not really about pgla, but thought I'd ask in this more generic forum. I found out in the pg mailing list that a netmask was all that was lacking

host   all   all   192.168.2.100/32   md5

Did the trick. How excellent to be able to user pgla on a remote database like this!
Logged
Support Administrator
Administrator
PGLA Level3

Posts: 214


« Reply #3 on: February 27, 2007, 05:17:06 PM »
Quote

I knew it was an issue of ignorance and not really about pgla, but thought I'd ask in this more generic forum. I found out in the pg mailing list that a netmask was all that was lacking

host   all   all   192.168.2.100/32   md5

Did the trick. How excellent to be able to user pgla on a remote database like this!

Glad you got it working, I figured it was something minor.  I should have posted a example line from one of mine, then I would have spotted that right away.

Logged
kalpax2005
Guest
« Reply #4 on: September 26, 2007, 01:01:01 PM »
Quote

Not a pgla issue per se but I wonder why I need to use an ip address like this:

host   all   all   192.168.1.100/32   md5

when the pc with pgla or pgadmin is at 192.168.2.100?
Logged
Carley
Guest


« Reply #5 on: May 20, 2011, 10:52:00 PM »
Quote

HHIS I suhlod have thought of that!
Logged
Bucky
Guest


« Reply #6 on: May 21, 2011, 02:11:06 PM »
Quote

I'm irmpseesd! You've managed the almost impossible.
Logged
Pages: [1]
  Reply  |  Print  
 
Jump to:  

Powered by SMF 1.1.4 | SMF © 2006-2007, Simple Machines LLC