Thread: trying to connect to pg from within a local network
// __ trying to connect from 10.0.31.62
~
Hi,
~
I need to connect to a pg Windows installation that I have within the
same network
~
as listen_address I have listed: localhost, 127.0.0.1, 10.0.31.5, 10.0.31.62
~
10.0.31.5 is this "localhost" in the 10.0.31.* local network and
10.0.31.62 is me
~
I have check all I can think of and it still does not work. Why can't
I connect to pg from within the local network?
~
Thanks
lbrtchx
~
C:\cmllpz\prjx\java\JDBC\PG>java PG00Test
// __ aDrvr: |org.postgresql.Driver|
// __ aDBURL: |jdbc:postgresql://10.0.31.5:5432/postgres|
// __ Class.forName(org.postgresql.Driver): |class org.postgresql.Driver|
// __ (Driver)KDrvr.newInstance() :|org.postgresql.Driver@1893efe|
// __ DriverManager.registerDriver(OKDrvr);
org.postgresql.util.PSQLException: Connection refused. Check that the
hostname and port are correct and that the postmaster is accepting
TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:122)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:18)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:382)
at org.postgresql.Driver.connect(Driver.java:260)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at PG00.<init>(PG00Test.java:26)
at PG00Test.main(PG00Test.java:213)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:518)
at java.net.Socket.connect(Socket.java:468)
at java.net.Socket.<init>(Socket.java:365)
at java.net.Socket.<init>(Socket.java:179)
at org.postgresql.core.PGStream.<init>(PGStream.java:59)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
... 11 more
// __ database connection could not be set up!
C:\cmllpz\prjx\java\JDBC\PG>ipconfig -all
Windows IP Configuration
Host Name . . . . . . . . . . . . : BGN-2008
Primary Dns Suffix . . . . . . . : exchange.thetrade.org
Node Type . . . . . . . . . . . . : Unknown
IP Routing Enabled. . . . . . . . : No
WINS Proxy Enabled. . . . . . . . : No
DNS Suffix Search List. . . . . . : exchange.thetrade.org
thetrade.org
Ethernet adapter Local Area Connection:
Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : Broadcom 440x 10/100
Integrated Controller
Physical Address. . . . . . . . . : 00-16-E6-45E-F5-27
Dhcp Enabled. . . . . . . . . . . : Yes
Autoconfiguration Enabled . . . . : Yes
IP Address. . . . . . . . . . . . : 10.0.31.62
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 10.0.31.1
DHCP Server . . . . . . . . . . . : 10.0.31.1
DNS Servers . . . . . . . . . . . : 10.0.1.23
10.0.1.74
Lease Obtained. . . . . . . . . . : Tuesday, January 15, 2008 9:18:55 PM
Lease Expires . . . . . . . . . . : Wednesday, January 16,
2008 9:18:55 PM
C:\cmllpz\prjx\java\JDBC\PG>
~
C:\cmllpz\prjx\java\JDBC\PG>tracert 10.0.31.5
Tracing route to 10.0.31.5 over a maximum of 30 hops
1 <1 ms <1 ms <1 ms 10.0.31.5
Trace complete.
~
Albretch Mueller wrote: > I need to connect to a pg Windows installation that I have within the > same network > ~ > as listen_address I have listed: localhost, 127.0.0.1, > 10.0.31.5, 10.0.31.62 > ~ > 10.0.31.5 is this "localhost" in the 10.0.31.* local network and > 10.0.31.62 is me > ~ > I have check all I can think of and it still does not work. Why can't > I connect to pg from within the local network? > ~ > Thanks > lbrtchx > ~ > C:\cmllpz\prjx\java\JDBC\PG>java PG00Test > // __ aDrvr: |org.postgresql.Driver| > // __ aDBURL: |jdbc:postgresql://10.0.31.5:5432/postgres| > // __ Class.forName(org.postgresql.Driver): |class org.postgresql.Driver| > // __ (Driver)KDrvr.newInstance() :|org.postgresql.Driver@1893efe| > // __ DriverManager.registerDriver(OKDrvr); > org.postgresql.util.PSQLException: Connection refused. Check that the > hostname and port are correct and that the postmaster is accepting > TCP/IP connections. > at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:122) You should have the following in postgresql.conf: listen_addresses = '127.0.0.1,10.0.31.5' Maybe the last entry you added is the problem. Allowing certain client IP addresses is done in pg_hba.conf. If that is NOT the problem: Try the following on the client: telnet 10.0.31.5 5432 and tell us the response. Try the following on the server: netstat -a and tell us what you get. Is there a firewall involved? Yours, Laurenz Albe
> You should have the following in postgresql.conf: listen_addresses = '127.0.0.1,10.0.31.5'
~
I did change it
~
> Allowing certain client IP addresses is done in pg_hba.conf.
~
OK, I did too, this is how my /data/pg_hba.conf looks like:
~
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32,10.0.31.62 md5
# IPv6 local connections:
#host all all ::1/128 md5
~
> Try the following on the client: telnet 10.0.31.5 5432
~
C:\>telnet 10.0.31.5 5432
Connecting To 10.0.31.5...Could not open connection to the host, on
port 5432: Connect failed
C:\>ping 10.0.31.5
Pinging 10.0.31.5 with 32 bytes of data:
Reply from 10.0.31.5: bytes=32 time<1ms TTL=128
Reply from 10.0.31.5: bytes=32 time<1ms TTL=128
Reply from 10.0.31.5: bytes=32 time<1ms TTL=128
Reply from 10.0.31.5: bytes=32 time<1ms TTL=128
Ping statistics for 10.0.31.5:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms
~
> Try the following on the server: netstat -a
~
on the server:
~
C:\Documents and Settings\Administrator>netstat -a
Active Connections
Proto Local Address Foreign Address State
TCP BNG-04:epmap BNG-04.exchange.goodwillny.org:0 LISTENING
TCP BNG-04:microsoft-ds BNG-04.exchange.goodwillny.org:0 LISTENING
TCP BNG-04:1043 BNG-04.exchange.goodwillny.org:0 LISTENING
TCP BNG-04:3389 BNG-04.exchange.goodwillny.org:0 LISTENING
TCP BNG-04:4899 BNG-04.exchange.goodwillny.org:0 LISTENING
TCP BNG-04:netbios-ssn BNG-04.exchange.goodwillny.org:0 LISTENING
TCP BNG-04:1059 10.0.31.5:microsoft-ds ESTABLISHED
TCP BNG-04:1048 BNG-04.exchange.goodwillny.org:0 LISTENING
TCP BNG-04:1093 localhost:5432 ESTABLISHED
TCP BNG-04:5432 BNG-04.exchange.goodwillny.org:0 LISTENING
TCP BNG-04:5432 localhost:1093 ESTABLISHED
UDP BNG-04:microsoft-ds *:*
UDP BNG-04:isakmp *:*
UDP BNG-04:1025 *:*
UDP BNG-04:1026 *:*
UDP BNG-04:1058 *:*
UDP BNG-04:2967 *:*
UDP BNG-04:4500 *:*
UDP BNG-04:ntp *:*
UDP BNG-04:netbios-ns *:*
UDP BNG-04:netbios-dgm *:*
UDP BNG-04:1900 *:*
UDP BNG-04:ntp *:*
UDP BNG-04:1028 *:*
UDP BNG-04:1041 *:*
UDP BNG-04:1900 *:*
~
> Is there a firewall involved?
~
Not from my box, which is a client to pg
~
//__ "netstat -a" on my client box
C:\>netstat -a
Active Connections
Proto Local Address Foreign Address State
TCP BNG-2008:microsoft-ds BNG-2008.exchange.goodwillny.org:0 LISTENING
TCP BNG-2008:netbios-ssn BNG-2008.exchange.goodwillny.org:0 LISTENING
TCP BNG-2008:1144 gwdcbke1.exchange.goodwillny.org:1025 ESTABLISHED
TCP BNG-2008:1152 10.0.31.5:netbios-ssn ESTABLISHED
TCP BNG-2008:1262 mailserver.exchange.goodwillny.org:2128 ESTABLISHED
TCP BNG-2008:1341 exchange-i.exchange.goodwillny.org:9090 CLOSE_WAIT
TCP BNG-2008:1342 exchange-i.exchange.goodwillny.org:9090 CLOSE_WAIT
TCP BNG-2008:1396 exchange-i.exchange.goodwillny.org:9090 ESTABLISHED
TCP BNG-2008:1408 exchange-i.exchange.goodwillny.org:9090 ESTABLISHED
TCP BNG-2008:1044 BNG-2008.exchange.goodwillny.org:0 LISTENING
TCP BNG-2008:1153 localhost:1154 ESTABLISHED
TCP BNG-2008:1154 localhost:1153 ESTABLISHED
TCP BNG-2008:1155 localhost:1156 ESTABLISHED
TCP BNG-2008:1156 localhost:1155 ESTABLISHED
TCP BNG-2008:5432 BNG-2008.exchange.goodwillny.org:0 LISTENING
UDP BNG-2008:microsoft-ds *:*
UDP BNG-2008:isakmp *:*
UDP BNG-2008:1025 *:*
UDP BNG-2008:1026 *:*
UDP BNG-2008:1145 *:*
UDP BNG-2008:2967 *:*
UDP BNG-2008:4500 *:*
UDP BNG-2008:ntp *:*
UDP BNG-2008:netbios-ns *:*
UDP BNG-2008:netbios-dgm *:*
UDP BNG-2008:1900 *:*
UDP BNG-2008:ntp *:*
UDP BNG-2008:1029 *:*
UDP BNG-2008:1031 *:*
UDP BNG-2008:1042 *:*
UDP BNG-2008:1058 *:*
UDP BNG-2008:1900 *:*
On Wednesday 16 January 2008 12:58:58 Albretch Mueller wrote: > OK, I did too, this is how my /data/pg_hba.conf looks like: > ~ > # TYPE DATABASE USER CIDR-ADDRESS METHOD > > # IPv4 local connections: > host all all 127.0.0.1/32,10.0.31.62 md5 > # IPv6 local connections: > #host all all ::1/128 md5 It doesn't work like that. CIDR-ADDRESS is a single address range. Try putting 10.0.31.62/32 on a separate line. jan -- -------------------------------------------------------------- Jan de Visser jdevisser@digitalfairway.com Baruk Khazad! Khazad ai-menu! --------------------------------------------------------------
Now, I am also getting "connection refused" messages even though I do
know tc is running since I can check it with pdAdmin3
~
~
org.postgresql.util.PSQLException: Connection refused. Check that the
hostname and port are correct and that the postmaster is accepting
TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:122)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:18)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:382)
at org.postgresql.Driver.connect(Driver.java:260)
at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:649)
at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:713)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:3620)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1148)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:697)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1148)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:311)
at org.apache.catalina.core.StandardService.start(StandardService.java:450)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:2213)
at org.apache.catalina.startup.Catalina.start(Catalina.java:459)
at org.apache.catalina.startup.Catalina.execute(Catalina.java:346)
at org.apache.catalina.startup.Catalina.process(Catalina.java:130)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:151)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:518)
at java.net.Socket.connect(Socket.java:468)
at java.net.Socket.<init>(Socket.java:365)
at java.net.Socket.<init>(Socket.java:179)
at org.postgresql.core.PGStream.<init>(PGStream.java:59)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
... 24 more
~
and this is the part that matters in my server.xml file:
~
<Context path="/fileupload"
docBase="Z:\BEGIN\ESL\RLopez\GWB\prjx\GWB02\webapps12\fileupload"
debug="4"
reloadable="true"
crossContext="true"
workDir="Z:\BEGIN\ESL\RLopez\GWB\prjx\tc-4.1.36_workDir"
swallowOutput="true">
<Logger className="org.apache.catalina.logger.FileLogger"
directory="Z:\BEGIN\ESL\RLopez\GWB\prjx\logs"
prefix="tc-4.1.36_localhost_FileUpload_log."
suffix=".txt"
timestamp="true"/>
<Realm className="org.apache.catalina.realm.JDBCRealm"
driverName="org.postgresql.Driver"
connectionURL="jdbc:postgresql://10.0.31.5/postgres"
connectionName="postgres"
connectionPassword="gwbpsswrd"
userTable="users"
userNameCol="user_name"
userCredCol="user_pass"
userRoleTable="user_roles" roleNameCol="role_name"/>
</Context>
~
On Wednesday 16 January 2008 12:58:58 Albretch Mueller wrote: > OK, I did too, this is how my /data/pg_hba.conf looks like: > ~ > # TYPE DATABASE USER CIDR-ADDRESS METHOD > > # IPv4 local connections: > host all all 127.0.0.1/32,10.0.31.62 md5 > # IPv6 local connections: > #host all all ::1/128 md5 It doesn't work like that. CIDR-ADDRESS is a single address range. Try putting 10.0.31.62/32 on a separate line. jan -- -------------------------------------------------------------- Jan de Visser jdevisser@digitalfairway.com Baruk Khazad! Khazad ai-menu! --------------------------------------------------------------
Albretch Mueller wrote: > Now, I am also getting "connection refused" messages even though I do > know tc is running since I can check it with pdAdmin3 > > org.postgresql.util.PSQLException: Connection refused. Check that the > hostname and port are correct and that the postmaster is accepting > TCP/IP connections. Bad. pgAdmin3 runs on the server, right? So local connections are possible. Good to know. >> You should have the following in postgresql.conf: >> listen_addresses = '127.0.0.1,10.0.31.5' > > I did change it Good. >> Allowing certain client IP addresses is done in pg_hba.conf. > > OK, I did too, this is how my /data/pg_hba.conf looks like: > > # TYPE DATABASE USER CIDR-ADDRESS METHOD > > # IPv4 local connections: > host all all 127.0.0.1/32,10.0.31.62 md5 > # IPv6 local connections: > #host all all ::1/128 md5 That is not correct, you should have entries like this: host all all 127.0.0.1/32 md5 host all all 10.0.31.62/32 md5 host all all 0.0.0.0/0 reject But that should not lead to a "connection refused" message like you encounter, but to a "there is no pg_hba.conf entry" message. So that is not the immediate problem, though it will become later on. >> Try the following on the client: telnet 10.0.31.5 5432 > > C:\>telnet 10.0.31.5 5432 > Connecting To 10.0.31.5...Could not open connection to the host, on > port 5432: Connect failed That means that either a) the PostgreSQL server is not listening on this port or b) a firewall blocks you. >> Try the following on the server: netstat -a > > on the server: > > C:\Documents and Settings\Administrator>netstat -a > > Active Connections > > Proto Local Address Foreign Address State [...] > TCP BNG-04:5432 BNG-04.exchange.goodwillny.org:0 LISTENING [...] OK, that's your PostgreSQL server listening. > > Is there a firewall involved? > > Not from my box, which is a client to pg The firewall could also be somewhere between your client and the server. > //__ "netstat -a" on my client box > C:\>netstat -a > > Active Connections > > Proto Local Address Foreign Address State [...] > TCP BNG-2008:1152 10.0.31.5:netbios-ssn ESTABLISHED [...] That at least shows that it is possible to get TCP connections from your client to the server. At least on port 139. Could still be that a firewall blocks other ports. Ok, let's sum up: - Your server is up and running (you can connect locally). - Your server is listening on port 5432. - You cannot open a TCP connection from client to server on port 5432 (but on port 139 you can). That looks too me like a network/firewall problem. I know too little about networks, particularly on Windows, to tell you how to proceed. But to confirm my suspicion, there's a few things you can try: - From the client, try "telnet 10.0.31.5 139". That should not give you an error message. - From the server, try "telnet 10.0.31.5 5432". That should also not give you an error message. If these two work, but "telnet 10.0.31.5 5432" from the client gives you a "connection refused", I don't know whom to blame but the network configuration. Yours, Laurenz Albe
If the server is running on Windows, all recent versions of Windows run a built-in firewall by default that will block remote access to the PG port. Have you confirmed that the firewall is either not running, or has an exception for the PG port? -- Mark Lewis On Thu, 2008-01-17 at 16:46 +0100, Albe Laurenz wrote: > Albretch Mueller wrote: > > > Now, I am also getting "connection refused" messages even though I do > > know tc is running since I can check it with pdAdmin3 > > > > org.postgresql.util.PSQLException: Connection refused. Check that the > > hostname and port are correct and that the postmaster is accepting > > TCP/IP connections. > > Bad. pgAdmin3 runs on the server, right? > So local connections are possible. Good to know. > > >> You should have the following in postgresql.conf: > >> listen_addresses = '127.0.0.1,10.0.31.5' > > > > I did change it > > Good. > > >> Allowing certain client IP addresses is done in pg_hba.conf. > > > > OK, I did too, this is how my /data/pg_hba.conf looks like: > > > > # TYPE DATABASE USER CIDR-ADDRESS METHOD > > > > # IPv4 local connections: > > host all all 127.0.0.1/32,10.0.31.62 md5 > > # IPv6 local connections: > > #host all all ::1/128 md5 > > That is not correct, you should have entries like this: > > host all all 127.0.0.1/32 md5 > host all all 10.0.31.62/32 md5 > host all all 0.0.0.0/0 reject > > But that should not lead to a "connection refused" message like you > encounter, but to a "there is no pg_hba.conf entry" message. > > So that is not the immediate problem, though it will become later on. > > >> Try the following on the client: telnet 10.0.31.5 5432 > > > > C:\>telnet 10.0.31.5 5432 > > Connecting To 10.0.31.5...Could not open connection to the host, on > > port 5432: Connect failed > > That means that either > a) the PostgreSQL server is not listening on this port > or > b) a firewall blocks you. > > >> Try the following on the server: netstat -a > > > > on the server: > > > > C:\Documents and Settings\Administrator>netstat -a > > > > Active Connections > > > > Proto Local Address Foreign Address State > [...] > > TCP BNG-04:5432 BNG-04.exchange.goodwillny.org:0 LISTENING > [...] > > OK, that's your PostgreSQL server listening. > > > > Is there a firewall involved? > > > > Not from my box, which is a client to pg > > The firewall could also be somewhere between your client and the server. > > > //__ "netstat -a" on my client box > > C:\>netstat -a > > > > Active Connections > > > > Proto Local Address Foreign Address State > [...] > > TCP BNG-2008:1152 10.0.31.5:netbios-ssn ESTABLISHED > [...] > > That at least shows that it is possible to get TCP connections from > your client to the server. At least on port 139. > Could still be that a firewall blocks other ports. > > > Ok, let's sum up: > > - Your server is up and running (you can connect locally). > - Your server is listening on port 5432. > - You cannot open a TCP connection from client to server on port 5432 > (but on port 139 you can). > > That looks too me like a network/firewall problem. > I know too little about networks, particularly on Windows, to tell you > how to proceed. > > But to confirm my suspicion, there's a few things you can try: > > - From the client, try "telnet 10.0.31.5 139". > That should not give you an error message. > > - From the server, try "telnet 10.0.31.5 5432". > That should also not give you an error message. > > If these two work, but "telnet 10.0.31.5 5432" from the client > gives you a "connection refused", I don't know whom to blame but > the network configuration. > > Yours, > Laurenz Albe > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq
~
Well, I went:
~
Start > Control Panel > Windows Firewall
~
and it is: "off (not recommended)"
~
Something I still am not sure about is how to:
~
"Check that the hostname and port are correct and that the postmaster
is accepting TCP/IP connnections"
~
There is nothing I can see in pg_hba.conf or postgres.conf that
relates to TCP/IP connnections and I think it is a pg thing, because
when I run tomcat on port 8080 on this box, I can telnet to it without
any problems
~
Tomcat is using a pg-based JDBCRealm, that means it is connecting to
it without any problems
~
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ FROM client~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
C:\>ipconfig -all
Windows IP Configuration
Host Name . . . . . . . . . . . . : BKN-2008
Primary Dns Suffix . . . . . . . : thetrade.com
Node Type . . . . . . . . . . . . : Unknown
IP Routing Enabled. . . . . . . . : No
WINS Proxy Enabled. . . . . . . . : No
DNS Suffix Search List. . . . . . : thetrade.com
thetrade
Ethernet adapter Local Area Connection:
Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : Broadcom 440x 10/100
Integrated Controller
Physical Address. . . . . . . . . : 00-16-45-0E-F5-27
Dhcp Enabled. . . . . . . . . . . : Yes
Autoconfiguration Enabled . . . . : Yes
IP Address. . . . . . . . . . . . : 10.0.31.62
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 10.0.31.1
DHCP Server . . . . . . . . . . . : 10.0.31.1
DNS Servers . . . . . . . . . . . : 10.0.1.23
10.0.1.74
Lease Obtained. . . . . . . . . . : Friday, January 18, 2008 9:34:04 AM
Lease Expires . . . . . . . . . . : Saturday, January 19, 2008
9:34:04 AM
C:\>telnet bkn-04 5432
Connecting To bkn-04...Could not open connection to the host, on port
5432: Connect failed
C:\>telnet 10.0.31.88 5432
Connecting To 10.0.31.88...Could not open connection to the host, on
port 5432: Connect failed
~
C:\>telnet bkn-04 8080
(connects OK)
~
C:\>telnet 10.0.31.88 8080
(connects OK)
~
C:\cmllpz\prjx\java\JDBC\PG>java PG00Test
// __ aDrvr: |org.postgresql.Driver|
// __ aDBURL: |jdbc:postgresql://bkn-04:5432/postgres|
// __ Class.forName(org.postgresql.Driver): |class org.postgresql.Driver|
// __ (Driver)KDrvr.newInstance() :|org.postgresql.Driver@1893efe|
// __ DriverManager.registerDriver(OKDrvr);
org.postgresql.util.PSQLException: Connection refused. Check that the
hostname and port are correct and that the postmaster is accepting
TCP/IP con
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:122)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:18)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:382)
at org.postgresql.Driver.connect(Driver.java:260)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at PG00.<init>(PG00Test.java:26)
at PG00Test.main(PG00Test.java:213)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:518)
at java.net.Socket.connect(Socket.java:468)
at java.net.Socket.<init>(Socket.java:365)
at java.net.Socket.<init>(Socket.java:179)
at org.postgresql.core.PGStream.<init>(PGStream.java:59)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
... 11 more
// __ database connection could not be set up!
On my Solaris box, which btw is really picky about security, here is how my config looks like, note that I have two ethernet interfaces on it, dn-2xe32-iprb0 and dn-2xe32-e1000g0.
Also my local network is on 192.168.1.0.
postgresql.conf
----------------------
# - Connection Settings -
listen_addresses = 'localhost, dn-2xe32-e1000g0'
# what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
# (change requires restart)
port = 5432 # (change requires restart)
# what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
# (change requires restart)
port = 5432 # (change requires restart)
-----------------
pg_hba.conf
-----------------
-----------------
# IPv4 local connections:
host all all 127.0.0.1/32 trust
host all postgres 192.168.1.0/24 md5
host all pguser2 192.168.1.0/24 md5
-----------------
host all all 127.0.0.1/32 trust
host all postgres 192.168.1.0/24 md5
host all pguser2 192.168.1.0/24 md5
-----------------
Also I have seen in your first email an entry listen_address instead of listen_addresses, can you double check if there is no spelling error somewhere, you never know.
Did you try listen_addresses='*' and see if that would listen more than localhost?
Mike
Albretch Mueller <lbrtchx@gmail.com> wrote:
There is nothing I can see in pg_hba.conf or postgres.conf that
relates to TCP/IP connnections and I think it is a pg thing, because
when I run tomcat on port 8080 on this box, I can telnet to it without
any problems
~
Never miss a thing. Make Yahoo your homepage.
Albretch Mueller wrote: > Start > Control Panel > Windows Firewall > > and it is: "off (not recommended)" Did you make sure that there is no firewall ON the server and no firewall BETWEEN the client and the server? > C:\>telnet bkn-04 5432 > Connecting To bkn-04...Could not open connection to the host, on port > 5432: Connect failed Did you try this on the client machine or on the server machine? Does the result differ on both? > C:\>telnet 10.0.31.88 5432 > Connecting To 10.0.31.88...Could not open connection to the host, on > port 5432: Connect failed > ~ > C:\>telnet bkn-04 8080 > (connects OK) > ~ > C:\>telnet 10.0.31.88 8080 > (connects OK) Since the "netstat" output you posted before showed something listening on port 5432 on the server machine, it still looks like a network or firewall problem. Have you talked to the people who manage your network? Yours, Laurenz Albe