Re: [Dspace-tech] Allowing access to Postgres
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
> 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
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