Thread: problem with pg_hba.conf & JDBC (?)

problem with pg_hba.conf & JDBC (?)

From
"Damien S"
Date:
Hi there all.

I'm having a strange problem here:
I get the error message below when executing a SQL query through Tomcat
4.0.3 on a Linux server, with jdk1.4 & PostgreSQL 7.2.1. The user has rights
to insert, update, etc. & there is an entry for the IP address in the
pg_hba.conf file.
But strangely this exception only occurs through the JDBC driver when
deploying a web-app on Tomcat.

Executing statements through MS Access & pgAdmin works as well (from
Windows)

Technology used:
Tomcat 4.0.3
JDK 1.4
SuSE Linux 7.3
JDBC driver 7.0
PostgreSQL 7.2.1


This is the error message I get:
User=damien
Error code=0
SQL state=null
Message=Something unusual has occured to cause the driver to fail. Please
report this exception: java.sql.SQLException: FATAL 1: No pg_hba.conf entry
for host 212.222.11.111, user damien, database testerdb
- Any help would be very welcome.

Cheers, Damien


Re: problem with pg_hba.conf & JDBC (?)

From
pin.o.za@mail.toyota-shokki.co.jp (王斌)
Date:
I have the same problem 8 months ago. The problem is that you have not allowed the connection from your host to the
server.
 
You need to edit the pg_hba.conf file on the server and add your host, or network.


Bin Wang