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@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Dario Silva Prieto
Sent: October 15, 2001 3:11 PM
To: pgsql-jdbc@postgresql.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