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@xxxxxxxxxxx>
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?
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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
