Re: Connection problems - local IP address refused! - Mailing list pgsql-general

On 02/05/2014 08:53 AM, Edson Richter wrote:
> Em 05/02/2014 13:03, Adrian Klaver escreveu:
>> On 02/05/2014 05:43 AM, Edson Richter wrote:
>>> Em 05/02/2014 11:12, Alban Hertroys escreveu:
>>>> Are you connecting to the correct host?
>>>>
>>>> On 5 February 2014 12:37, Edson Richter <edsonrichter@hotmail.com>
>>>> wrote:
>>>>> Without 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
>>> Sure! On the exatcly same 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.
>>
>> The error message:
>>
>>  Detail: FATAL:  no pg_hba.conf entry for host "10.68.73.6", user
>> "master", database "master", SSL off
>>
>> indicates your JDBC connection is not connecting to a database with
>> the pg_hba.conf you think it is.
>>
>> What are the connection parameters for the JDBC connection?
>>
>> So where is the database running?
>>
>> What interface is it listening on?
>>
>> I know it has been asked, but is there another Postgres instance running?
>>
>>
> Well, there is only one PostgreSQL database running in this machine. It
> has three interfaces:
>
> lo (127.0.0.1)
> eth0 (xxx.xxx.xxx.xxx)
> tun0 (10.68.73.6)
>
> PostgreSQL is configured to listen_adrress =  '*'
> Firewall allows evertyhing from lo and tun0.
> AFAIK (please correct me if I'm wrong) JDBC knows nothing about
> pg_hba.conf; this error message comes from PostgresSQL, don't?
> I can connect in the very same machine using psql. It is really weird
> problem.

Your JDBC connection does not 'know' about pg_hba.conf but it is
triggering the error and capturing the exception:

2014-02-05 09:12:21.111 - xxxxx - org.postgresql.util.PSQLException:
ERROR: could not establish connection

It would seem something about the JDBC connection is incorrect. This is
why I asked for the connection parameters in the JDBC connection. For
some reason it is not connecting in the same manner as psql. The chore
now is to find out why?

>
> I'll need to dig a bit more.
>
> Edson
>
>
>


--
Adrian Klaver
adrian.klaver@gmail.com