[Dspace-tech] No pg_hba.conf entry for host ...

[Mark Huppert]

Dear Colleagues

I have been trying to upgrade to v1.1 from 1.01,
following your instructions. But no luck getting
it to work - it's not talking to our pgsql v7.3.2.
The 1.01 version did partially work - but not browsing.
Our site is at: http://slave.anu.edu.au:8080/dspace/

I think this is a pgsql error being
sent to dspace (see below for error). Despite the
error msg, we actually DO have
a pg_hba.conf entry for this ip address:

<quote>
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD

local all all trust
host all all 127.0.0.1 255.255.255.255 trust
host dspace dspace 150.203.2.89 255.255.255.0 trust
</quote>

The pg_hba.conf file is located here, as it should be:

/usr/local/pgsql/data/

I restarted pgsql with these options to make sure (postmaster.opts):
/usr/local/pgsql/bin/./postmaster '-i' '-D' '/usr/local/pgsql/data/'

I checked to see that all jar files are in /dspace/lib.

<error>
Stack Trace: java.sql.SQLException: FATAL: No pg_hba.conf entry for host 150.203.2.89, user dspace, database dspace at org.postgresql.Connection.openConnection(Unknown Source) at org.postgresql.Driver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at org.apache.commons.dbcp ... etc
</error>

--
_______________________________________________
Mark Huppert <mark.h...@anu.edu.au>
Web Development Coordinator
SIS/Library, Division of Information
RG Menzies Building No. 2
Australian National University
Canberra ACT 0200 http://anulib.anu.edu.au
+61 02 6125 2752 / fax +61 02 6125 3215

[Tansley, Robert]

Can you connect to PostgreSQL from the machine running DSpace with psql? You could try connecting using TCP/IP, e.g. with:

psql -U dspace -W -h localhost -p 5432 dspace

(-W for password prompt, -p 5432 to force a TCP/IP connection.) If the above command works, your PostgreSQL configuration is OK and there must be something up with the DSpace side of things. In this case you could check that the JDBC drivers are correct (as explained in previous messages.)

Robert Tansley / Hewlett-Packard Laboratories / (+1) 617 551 7624

> -------------------------------------------------------
> Enterprise Linux Forum Conference & Expo, June 4-6, 2003,
> Santa Clara The only event dedicated to issues related to
> Linux enterprise solutions www.enterpriselinuxforum.com
>
> _______________________________________________
> DSpace-tech mailing list
> DSpac...@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/d> space-tech
>