Re: Connection problems - local IP address refused!

Em 05/02/2014 11:51, rob stone escreveu:
> O
> n Wed, 2014-02-05 at 09:37 -0200, Edson Richter wrote:W
> ithout 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@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@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@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)
>>
>
> The current JDBC version is 1100.
> >From where did you obtain version 1002?

I've downloaded the source, add some debug information and build from
the sources. I've been using this for a long time.

> I think that your PostgreSql version and JDBC version are incompatible.
Well, should I use 9.3 1100 with a 9.2.6 server database?
> I use ExecuteQuery and JDBC drivers daily for testing, etc.

I've processed > 1.000.000 transactions with this driver in this server
last month...

> The error your are pulling appears to be an issue with versions.

Well, I'll give a try with a new driver, but I do suspect something
wrong in identifying network names...

Thanks for your help. I'll try your suggestion.

Regards,

Edson
>
> HTH
>
> Robert
>
>
>