Thread: jdbc:posgresql problem

jdbc:posgresql problem

From
Vardan Gyurjyan
Date:
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(Unknown Source)
        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:posgresql problem

From
"Dave Cramer"
Date:
Vardan,

This is a security issue with the postgres backend, you need to edit the
pg_hba.conf file and put an entry in for your host

129.57.33.170

Dave

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Vardan Gyurjyan
Sent: Thursday, January 17, 2002 8:13 AM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] jdbc:posgresql problem


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(Unknown Source)
        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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)