Hi,
I tried replying to your email yesterday, but it bounced saying the email
address was invalid....?
Anyway, you need to edit your pg_hba.conf file in your postgresql installation
and entering a line that allows (trust) your ip address direct access to the
database via PGAdminIII. Here is a snippet of our pg_hba.conf file:
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all
trust
# IPv4 local connections:
host all all 127.0.0.1/32
trust
# IPv6 local connections:
host all all ::1/128
trust
# Jeff, Sue, anyone else who needs direct access to the database
host all all 123.123.123.12/32 trust
host all all 123.123.123.26/32 trust
.
.
.
You'll need to add a line that looks like this:
Host dspace dspace 192.168.1.24 trust
After you save the file, you'll need to do a server configuration reload by
executing:
./your_postgres_installation_directory/bin/pg_ctl reload
Hope this helps,
Sue
Sue Walker-Thornton
ConITS Contract
NASA Langley Research Center
Integrated Library Systems ~ Developer/DBA
130 Research Drive
Hampton, VA 23666
Office: (757) 224-4074
Fax: (757) 224-4001
Mobile: (757) 506-9903
Email: susan.m.thorn...@nasa.gov<mailto:susan.m.thorn...@nasa.gov>
________________________________
From: Alpesh Sarvaiya [mailto:alpesh.sarva...@pyther.com]
Sent: Wednesday, March 03, 2010 2:09 AM
To: DSpace-tech@lists.sourceforge.net
Subject: [Dspace-tech] Dspace database connection error
Hello Sir,
I have install postgreSQL 8.4 server in windowXP on IP 192.168.1.24 with port
9500 and trying to access the database "dspace" that is created in postgreSQL
7.4 install on debian linux on host 192.168.1.32 with port 5432. So problem is
that when I start the pgadminIII from window xp and click on File-->Add Server..
It shows the dialog box to connect with database that is created on linux as I
told above. I have entered the following entry in the field
plz see "enry.jpg" that is attached with email.
And gives the following error
Access to database denied
The server doesn't grant access to the database: the server reports
FATAL: no pg_hba.conf entry for host "192.168.1.24", user "dspace", database
"dspace", SSL off
To access a database on a PostgreSQL server, you first have to grant primary
access to the server for your client (Host Based Authentication). PostgreSQL
will check the pg_hba.conf file if a pattern that matches your client address /
username / database is present and enabled before any SQL GRANT access control
lists are evaluated.
The initial settings in pg_hba.conf are quite restrictive, in order to avoid
unwanted security holes caused by unreviewed but mandatory system settings.
You'll probably want to add something like
host all all 192.168.0.0/24<http://192.168.0.0/24> md5
This example grants MD5 encrypted password access to all databases to all users
on the private network 192.168.0.0/24<http://192.168.0.0/24>.
You can use the pg_hba.conf editor that is built into pgAdmin III to edit the
pg_hba.conf configuration file. After changing pg_hba.conf, you need to trigger
a server configuration reload using pg_ctl or by stopping and restarting the
server process.
Thank You in advance,
Alpesh
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
