Postgres Pro
Downloads
Home   >   mailing lists

Thread: Urgent problems with my conection

Urgent problems with my conection

From
"Dario Silva Prieto"
Date:
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

Re: Urgent problems with my conection

From
"Nick Fankhauser"
Date:
> host    SIGED    192.9.200.199    255.255.255.0    trust

This looks correct. Are the permissions on the pg_hba.conf file set so the
postgres user can read it?

I think postgres will look in /etc/postgresql/pg_hba.conf if there is no
readable file in the data directory. You might try editing this file to see
if it helps.

-Nick

Re: Urgent problems with my conection

From
"Dave Cramer"
Date:
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