Re: Connection problems - local IP address refused! - Mailing list pgsql-general
From | Edson Richter |
---|---|
Subject | Re: Connection problems - local IP address refused! |
Date | |
Msg-id | BLU0-SMTP1569D92F559850CC5510D68CF950@phx.gbl Whole thread Raw |
In response to | Re: Connection problems - local IP address refused! (rob stone <floriparob@gmail.com>) |
List | pgsql-general |
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 > > >
pgsql-general by date: