Search Postgresql Archives

Re: Help with connection issue - started today

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



You checked pg_hba_conf for host 10.68.73.6?
Is there a matching log entry for the rejection?


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@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)
> 
> 
> 
> 
> 
> 




-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux