Re: Problem to connect from host via JDBC ...

Thomas,

Can you send me the results of netstat -nlp | grep 5432

Dave

-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of tsmets(at)brutele(dot)be
Sent: Tuesday, March 05, 2002 3:47 AM
To: pgsql jdbc
Subject: [JDBC] Problem to connect from host via JDBC ...

I configured the postgres DB to start with :
/usr/bin/postmaster -o -i -D ${PGDATA}
which I manually start with the "-d 5 & "@ the end.

The "psql" commands works fine locally.

pg_hda.conf contains the following line :
# The same, over Unix-socket connections:
#
# local all 192.168.1.0 255.255.255.0 trust
host all 192.168.1.0 255.255.255.0 trust

Of course my network is 192.168.1.0 with a subnetmask of 255.255.255.0

Trying to connect from another machine via JDBC gives the following
error: "1109 [main] WARN org.test.JDBCPostgres.TestJDBCPostgres -
Message: Connection refused. Check that the hostname and port is
correct, and that the postmaster is running with the -i flag, which
enables TCP/IP networking."

Which is definitevely the case :
$ ps -ef | grep post
postgres 6525 6456 0 14:40 pts/0 00:00:00
/usr/bin/postmaster -o -i -D /da

Does some one knows what is going wrong ?

Thomas,

--
Thomas SMETS
rue J. Wytsmanstraat 62
1050 Bruxelles
yahoo-id: smetsthomas

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org