Обсуждение: jdbc:postgresql problem

Поиск
Список
Период
Сортировка

jdbc:postgresql problem

От
Vardan Gyurjyan
Дата:
Hi,
when I'm trying to access database from the remote host using  jdbc I'll

get following error message:

----------------------------------
PostgreSQL basic test v6.3 rev 1

Connecting to Database URL = jdbc:postgresql://polaris:5432/coda_lg_db
Exception caught.
Something unusual has occured to cause the driver to fail. Please report

this exception: Exception: java.sql.SQLException: No pg_hba.conf entry
for host 129.57.33.170, user coda, database coda_lg_db
Stack Trace:

java.sql.SQLException: No pg_hba.conf entry for host 129.57.33.170, user

coda, database coda_lg_db       at org.postgresql.Connection.openConnection(Unknown Source)       at
org.postgresql.Driver.connect(UnknownSource)       at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)       at basic.<init>(basic.java:37)       at
basic.main(basic.java:197)
End of Stack Trace

---------------------------

Please help me to solve this problem.
Thanking you in advance ,
vardan






Re: jdbc:postgresql problem

От
Holger Krug
Дата:
On Thu, Jan 17, 2002 at 08:04:26AM -0500, Vardan Gyurjyan wrote:
> java.sql.SQLException: No pg_hba.conf entry for host 129.57.33.170, user

pg_hba.conf is the configuration file for PostgreSQL's Host Based
Access control. The message means, that you're not allowed to access
PostgreSQL from the host you're using. Make the amendments needed in
pg_hba.conf. The comments in pg_hba.conf should help you.

PS.: Actually I think your question should go to the pgsql-general list,
not to pgsql-hackers. 

-- 
Holger Krug
hkrug@rationalizer.com