Re: Help with connection issue - started today

Em 06/02/2014 14:25, Bret Stern escreveu:
> You checked pg_hba_conf for host 10.68.73.6?
> Is there a matching log entry for the rejection?

Thanks for your effort, Bret!
Problem already solved (I've posted the solution in the list past days).
Problem was a "context.xml" with a wrong database server reference - the
reason that made Tomcat to start considering that file is a mystery to
me, but removing the file, it became normal again.

Regards,

Edson

>
>
> On Wed, 2014-02-05 at 09:21 -0200, Edson Richter wrote:
>> 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:
>>
>> 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...
>>
>> 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)
>>
>>
>>
>>
>>
>>
>
>
>