Thread: Help with connection issue - started today
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)
On Wed, Feb 5, 2014 at 5:21 AM, Edson Richter <edsonrichter@hotmail.com> 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) The log is telling you exactly what's happening. "pg_hba.conf" is a database firewall of sorts that manages whom is allowed to connect to the database and from where. Fixing this is a matter of adding a rule to that file. The file is internally well documented but you should also read this: http://www.postgresql.org/docs/9.3/static/auth-pg-hba-conf.html after changing the file, you have to "reload" or restart the database. merlin
On 02/06/2014 07:29 AM, Merlin Moncure wrote: > The log is telling you exactly what's happening. "pg_hba.conf" is a > database firewall of sorts that manages whom is allowed to connect to > the database and from where. Fixing this is a matter of adding a rule > to that file. The file is internally well documented but you should > also read this: > http://www.postgresql.org/docs/9.3/static/auth-pg-hba-conf.html > > after changing the file, you have to "reload" or restart the database. Actually I think this is the first try at what became this thread: http://www.postgresql.org/message-id/BLU0-SMTP4003F13D23F226D5CDEE60ACF950@phx.gbl It turned out to be a Tomcat issue. > > merlin > > -- Adrian Klaver adrian.klaver@gmail.com
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) > > > > > >
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@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) >> >> >> >> >> >> > > >