Re: [Dspace-tech] Allowing access to Postgres

2007-12-03 Thread James Rutherford
On Mon, Dec 03, 2007 at 12:42:09PM +, Mika Stenberg wrote:
> Im hoping to allow remote access to our postgres running with DSpace
> 1.4.2. Im having problems with this though. Has anyone managed to
> configure Postgres to accept incoming connections from other than
> localhost as well?
> 
> on postgres.conf I have added the following:
> 
> listen_addresses = 'localhost, otto.terkko.helsinki.fi'
> 
> and on pg_hba.conf i added host to listen :
> 
> hostall USERNAMEmd5
> 
> I also opened up the firewall for for 5432. Still I get a message:
> 
> "Is the server running on host "tds.terkko.helsinki.fi" and accepting
>  TCP/IP connections on port 5432?"
> 
> Any ideas, what could be causing this?

On the local machine (as root) try running either

lsof -i tcp:5432

or

telnet localhost 5432

If either of those shows that postgres is indeed listening on that port,
try running the telnet command from the remote machine (something like
telnet otto.terkko.helsinki.fi 5432).

cheers,

Jim

-- 
James Rutherford  |  Hewlett-Packard Limited registered Office:
Research Engineer |  Cain Road,
HP Labs   |  Bracknell,
Bristol, UK   |  Berks
+44 117 312 7066  |  RG12 1HN.
[EMAIL PROTECTED]   |  Registered No: 690597 England

The contents of this message and any attachments to it are confidential
and may be legally privileged. If you have received this message in
error, you should delete it from your system immediately and advise the
sender. To any recipient of this message within HP, unless otherwise
stated you should consider this message and attachments as "HP
CONFIDENTIAL".

-
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell.  From the desktop to the data center, Linux is going
mainstream.  Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech


Re: [Dspace-tech] Allowing access to Postgres

2007-12-03 Thread Mika Stenberg
> On the local machine (as root) try running either
> 
> lsof -i tcp:5432

This gives me a list of postgres processes, so I guess its working fine?


> or
> 
> telnet localhost 5432

This one leaves me hanging, though since it does not fail I think there 
is someone listening on 5432, right?

> 
> If either of those shows that postgres is indeed listening on that port,
> try running the telnet command from the remote machine (something like
> telnet otto.terkko.helsinki.fi 5432).

Trying telnet on another machine however, gives me:
telnet: connect to address 128.214.167.212: Connection refused

Am I missing a setting somewhere ?

-Mika

-
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell.  From the desktop to the data center, Linux is going
mainstream.  Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech


Re: [Dspace-tech] Allowing access to Postgres

2007-12-03 Thread James Rutherford
On Mon, Dec 03, 2007 at 01:34:30PM +, Mika Stenberg wrote:
> > On the local machine (as root) try running either
> >
> > lsof -i tcp:5432
> 
> This gives me a list of postgres processes, so I guess its working fine?

Yes, that means it's definitely listening on the correct port.

> > telnet localhost 5432
> 
> This one leaves me hanging, though since it does not fail I think there
> is someone listening on 5432, right?

That's strange. It should eventually connect with a message like this:

$ telnet localhost 5432
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.

> > If either of those shows that postgres is indeed listening on that port,
> > try running the telnet command from the remote machine (something like
> > telnet otto.terkko.helsinki.fi 5432).
> 
> Trying telnet on another machine however, gives me:
> telnet: connect to address 128.214.167.212: Connection refused

Are you sure your firewall is set up correctly (/sbin/iptables -L)? If
so, try changing listen_addresses to '*' and see if that helps (after
restarting postgres, of course).

cheers,

Jim

-- 
James Rutherford  |  Hewlett-Packard Limited registered Office:
Research Engineer |  Cain Road,
HP Labs   |  Bracknell,
Bristol, UK   |  Berks
+44 117 312 7066  |  RG12 1HN.
[EMAIL PROTECTED]   |  Registered No: 690597 England

The contents of this message and any attachments to it are confidential
and may be legally privileged. If you have received this message in
error, you should delete it from your system immediately and advise the
sender. To any recipient of this message within HP, unless otherwise
stated you should consider this message and attachments as "HP
CONFIDENTIAL".

-
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell.  From the desktop to the data center, Linux is going
mainstream.  Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech