Connection problems - local IP address refused!

From: Edson Richter <edsonrichter(at)hotmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Connection problems - local IP address refused!
Date: 2014-02-05 11:37:47
Message-ID: BLU0-SMTP4003F13D23F226D5CDEE60ACF950@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear all, I need your advise. Found a tricky situation.

Without any changes in the configuration files, a **local** connection
to a local VPN IP address could not be established with the following
error:

_*The error (JDBC connection using driver version 1002):*_
2014-02-05 09:12:21.111 - xxxxx - org.postgresql.util.PSQLException:
ERROR: could not establish connection
Detail: FATAL: no pg_hba.conf entry for host "10.68.73.6", user
"master", database "master", SSL off

org.postgresql.util.PSQLException: ERROR: could not establish connection
Detail: FATAL: no pg_hba.conf entry for host "10.68.73.6", user
"master", database "master", SSL off

at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:331)
at
org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at
org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at
org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at br.com...

_*Current pg_hba.conf:*_
local all all peer
host all all 127.0.0.1/32 md5
host all all 10.68.73.0/24 md5

_*If I run from the Local Server: *_
[root(at)mylocalserver logs]# psql -h 10.68.73.6 -d master -U master
Senha para usuário master:
psql (9.2.6)
Digite "help" para ajuda.

master=> select count(*) from pessoa;
count
-------
9
(1 registro)

_*If I run from a Remote Server: *_
[root(at)myremoteserver ssh]# psql -h 10.68.73.6 -d master -U master
Senha para usuário master:
psql (9.2.6)
Digite "help" para ajuda.

master=> select count(*) from pessoa;
count
-------
9
(1 registro)

So, seems that only JDBC is getting in trouble to connect to a local IP
address.
Current interfaces (and yes, the tunneling is running - otherwise the
remote server could not connect):

[root(at)mylocalserver logs]# ifconfig
eth0 Link encap:Ethernet Endereço de HW XX:XX:XX:XX:XX:XX
inet end.: xxx.xx.xxx.85 Bcast:xxx.xx.xxx.87
Masc:255.255.255.248
endereço inet6: xxxx::xxx:xxxx:xxxx:xxxx/64 Escopo:Link
UP BROADCASTRUNNING MULTICAST MTU:1500 Métrica:1
RX packets:172557 errors:0 dropped:0 overruns:0 frame:0
TX packets:293439 errors:0 dropped:0 overruns:0 carrier:0
colisões:0 txqueuelen:1000
RX bytes:24537681 (23.4 MiB) TX bytes:227413210 (216.8 MiB)
IRQ:28 Memória:fb000000-fb7fffff

lo Link encap:Loopback Local
inet end.: 127.0.0.1 Masc:255.0.0.0
endereço inet6: ::1/128 Escopo:Máquina
UP LOOPBACKRUNNING MTU:16436 Métrica:1
RX packets:138156 errors:0 dropped:0 overruns:0 frame:0
TX packets:138156 errors:0 dropped:0 overruns:0 carrier:0
colisões:0 txqueuelen:0
RX bytes:31993170 (30.5 MiB) TX bytes:31993170 (30.5 MiB)

tun0 Link encap:Não Especificado Endereço de HW
00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00
inet end.: 10.68.73.6 P-a-P:10.68.73.5 Masc:255.255.255.255
UP POINTOPOINT RUNNING NOARP MULTICAST MTU:1500 Métrica:1
RX packets:149106 errors:0 dropped:0 overruns:0 frame:0
TX packets:274534 errors:0 dropped:199 overruns:0 carrier:0
colisões:0 txqueuelen:100
RX bytes:6291572 (6.0 MiB) TX bytes:381732404 (364.0 MiB)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message George Ant 2014-02-05 12:53:38 PL/pgSQL Copy data from one table to another
Previous Message Edson Richter 2014-02-05 11:21:08 Help with connection issue - started today