Re: Connection problems - local IP address refused!

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(at)hotmail(dot)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(at)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.

I'll need to dig a bit more.

Edson