Help with connection issue - started today - Mailing list pgsql-general
From | Edson Richter |
---|---|
Subject | Help with connection issue - started today |
Date | |
Msg-id | BLU0-SMTP2846AE4C51FA9BCC93CE08FCF950@phx.gbl Whole thread Raw |
Responses |
Re: Help with connection issue - started today
Re: Help with connection issue - started today |
List | 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: 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@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)
pgsql-general by date: