From: | Jimy McDermott <jmcdermott(at)catbird(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | TCPIP connection on local host using md5 |
Date: | 2012-10-12 21:48:32 |
Message-ID: | CAD444jzLV773Mv9gkj5MKcrcOfzCAzrUz6QRB=i=QvdoCrxxfA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I am trying to connect a JDBC client to the PostgreSQL DB using a custom
user, "report".
The report user connects *successfully* from remote machines as expected.
The report user *cannot connect* from the JDBC client program on local host.
I cant figure out wht an ident server is being contaced, the auth method is
md5.
JDBC Client connection string:
"jdbc:postgresql://localhost:/<mydbname>"
Error:
LOG: could not connect to Ident server at address "127.0.0.1", port 113:
Connection refused
FATAL: Ident authentication failed for user "report"
postgres.conf:
#------------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#------------------------------------------------------------------------------
# - Connection Settings -
listen_addresses = '*' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
# (change requires restart)
port = 5432 # (change requires restart)
pg_hba.conf:
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 ident
# IPv6 local connections:
host all all ::1/128 ident
# Allow replication connections from localhost, by a user with the
# replication privilege.
host all all 192.168.20.250/32 md5 #
This line supports the remote connection that works great
host all report 127.0.0.1/32 md5 #
This line is intended to support the local connection that is failing
From | Date | Subject | |
---|---|---|---|
Next Message | henk de wit | 2012-10-14 06:56:33 | Query with limit takes hours |
Previous Message | Tom Lane | 2012-10-12 20:27:51 | Re: query from 9.0 fails to return on 9.2 |