Search Postgresql Archives

Re: Connection problems - local IP address refused!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux