Re: [Dspace-tech] PostgreSQL refuse access
Got it!!! Not the network, not PostgreSQL, and not really DSpace - of course it was me. To show my colleagues the status of my test installation of DSpace I changed in dspace.cfg all occurrences of 'localhost' to the network name. And this was 1 occurrence too much: After resetting to 'localhost' the line db.url = jdbc:postgresql://localhost:5432/dspace the connection was back! Thanks to everyone who helped and wondered. :-) Best regards Robert --- Christian Voelker schrieb: Hello, Am 20.11.2007 um 13:23 schrieb Robert Roggenbuck: begin pg_hba.conf# local all postgres ident sameuser # TYPE DATABASEUSERCIDR-ADDRESS METHOD # local is for Unix domain socket connections only local all all ident sameuser # IPv4 local connections: hostall all 127.0.0.1/32 md5 # IPv6 local connections: hostall all ::1/128 md5 # DSpace settings: hostdspace dspace 127.0.0.1 255.255.255.255 md5 # hostdspace dspace 131.173.148.100 255.255.255.255 md5 end pg_hba.conf First, I would try a very open setting temporarily and also find out whether the notation of the mask as /32 is accepted. I would use a config with a single line like one of these to start with: hostall all 127.0.0.1255.255.255.0 password or hostall all 127.0.0.10.0.0.0 trust or hostall all 0.0.0.0 0.0.0.0 trust (check the state of your firewall before) I guess the last active line in your pg_hba.conf will never be evaluated because host all all matches all requests for db dspace by user dspace before they come to this line. But that should not stop your config from working. Then, did you update anything that might have placed a different version of the jdbc driver in a generic place where java might pick it up before it looks into your dspace directory? Or anything that might have modified the jdbc driver? Allways the same stupid questions but that is all that comes to my mind. Bye, Christian - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] PostgreSQL refuse access
Thanks for Your hint. The result of 'lsof -i tcp:5432' is: COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME postgres 5384 postgres3u IPv4 17284 TCP localhost:postgresql (LISTEN) This looks quite ok. Or should there are more processes / files? Regards Robert James Rutherford schrieb: Robert Roggenbuck wrote: Connection denied. Check the hostname and portnumber and be sure the the database server accept TCP/IP-connections. Did you check this? Try running lsof -i tcp:5432 as root on the database server to see if postgres is listening for TCP connections. cheers, Jim - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] PostgreSQL refuse access
On Tue, Nov 20, 2007 at 08:58:04AM +, Robert Roggenbuck wrote: Thanks for Your hint. The result of 'lsof -i tcp:5432' is: COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME postgres 5384 postgres3u IPv4 17284 TCP localhost:postgresql (LISTEN) This looks quite ok. Or should there are more processes / files? No, this is fine. The only thing I can think of then is that either something changed in your pg_hba.conf to deny access to your DSpace user or your dspace.cfg has been updated, and the incorrect password is in there. Is the database running on the same machine as tomcat? 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. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] PostgreSQL refuse access
James Rutherford schrieb: No, this is fine. The only thing I can think of then is that either something changed in your pg_hba.conf to deny access to your DSpace user or your dspace.cfg has been updated, and the incorrect password is in there. Is the database running on the same machine as tomcat? The database runs on the same machine as Tomcat. The password in dspace.cfg is correct (and without trailing spaces). I added one line in pg_hba.conf after (!) the connection failes - but without success (it is the last line in the following snippet): begin pg_hba.conf# local all postgres ident sameuser # TYPE DATABASEUSERCIDR-ADDRESS METHOD # local is for Unix domain socket connections only local all all ident sameuser # IPv4 local connections: hostall all 127.0.0.1/32 md5 # IPv6 local connections: hostall all ::1/128 md5 # DSpace settings: hostdspace dspace 127.0.0.1 255.255.255.255 md5 # hostdspace dspace 131.173.148.100 255.255.255.255 md5 end pg_hba.conf Greetings Robert - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] PostgreSQL refuse access
Robert Roggenbuck wrote: Connection denied. Check the hostname and portnumber and be sure the the database server accept TCP/IP-connections. Did you check this? Try running lsof -i tcp:5432 as root on the database server to see if postgres is listening for TCP connections. 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. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech