Re: Urgent problems with my conection

Dario,

If the host 199.9.200.199 has psql on it, then try connecting to the
database via psql, other than that try changing the line

host SIGED 192.9.200.199 255.255.255.0 trust

To

host siged 192.9.200.199 255.255.255.0 trust

Finally if that doesn't work try

host all 192.9.200.199 255.255.255.0 trust

Dave
-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Dario Silva Prieto
Sent: October 15, 2001 3:11 PM
To: pgsql-jdbc(at)postgresql(dot)org
Subject: [JDBC] Urgent problems with my conection

Hello.

I have a server with postgresql 7.0 in mandrake 7.2. I can make a
conection in the local machine, but when try to connect from other
machine in my network appear the following message

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 192.9.200.199, user ADMIN, database SIGED Stack Trace:

java.sql.SQLException: No pg_hba.conf entry for host 192.9.200.199, user
ADMIN, database SIGED
at org.postgresql.Connection.openConnection(Connection.java:170)
at org.postgresql.Driver.connect(Driver.java:122)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at db.Database.<init>(Database.java:26)
at db.Database.main(Database.java:52)
End of Stack Trace

at org.postgresql.Driver.connect(Driver.java:131)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at db.Database.<init>(Database.java:26)
at db.Database.main(Database.java:52)

I read the FAQ and the documentation and say that i have to modify the
pg_hba.conf file in the data directory. I modified this file and see
like this.

local all
host SIGED 192.9.200.199 255.255.255.0 trust

Please i'm a new user with linux and postgresql, and i have to make the
server for tomorrow :) please if you can know what happend and tell me
will be great.

Best Regards.

PD: Sorry i don't speak or write in english verry well.

Dario Silva
Merida - Venezuela

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html