Re: Connection problems - local IP address refused!

Em 05/02/2014 15:08, Adrian Klaver escreveu:
> 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(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.
>
> 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?

Thanks, Adrian!

Your ideas helped a lot to get me to the solution.
My problem was I had a "context.xml" file in my deployment folder.
I can't say why Tomcat wasn't reading this file in the past - but
anyway, removing the context.xml file from the deployment solved the
problem.

Regards,

Edson

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