Обсуждение: Help with connection issue - started today

Поиск
Список
Период
Сортировка

Help with connection issue - started today

От
Edson Richter
Дата:
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)

Re: Help with connection issue - started today

От
Merlin Moncure
Дата:
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

Re: Help with connection issue - started today

От
Adrian Klaver
Дата:
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

Re: Help with connection issue - started today

От
Bret Stern
Дата:
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)
>
>
>
>
>
>

Re: Help with connection issue - started today

От
Edson Richter
Дата:
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)
>>
>>
>>
>>
>>
>>
>
>
>