pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
problem with pg_hba.conf & JDBC (?)
2+ messages / 2 participants
[nested] [flat]

* problem with pg_hba.conf & JDBC (?)
@ 2002-10-22 13:12 Damien S <damienscarl@hotmail.com>
  2002-10-22 23:10 ` Re: problem with pg_hba.conf & JDBC (?) pin.o.za@mail.toyota-shokki.co.jp
  0 siblings, 1 reply; 2+ messages in thread

From: Damien S @ 2002-10-22 13:12 UTC (permalink / raw)
  To: pgsql-interfaces

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: problem with pg_hba.conf & JDBC (?)
  2002-10-22 13:12 problem with pg_hba.conf & JDBC (?) Damien S <damienscarl@hotmail.com>
@ 2002-10-22 23:10 ` pin.o.za@mail.toyota-shokki.co.jp
  0 siblings, 0 replies; 2+ messages in thread

From: pin.o.za@mail.toyota-shokki.co.jp @ 2002-10-22 23:10 UTC (permalink / raw)
  To: Damien S <damienscarl@hotmail.com>; +Cc: pgsql-interfaces

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2002-10-22 23:10 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-10-22 13:12 problem with pg_hba.conf & JDBC (?) Damien S <damienscarl@hotmail.com>
2002-10-22 23:10 ` pin.o.za@mail.toyota-shokki.co.jp

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox