From: | Ian Pilcher <pilchman(at)attbi(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | ident authentication not working over loopback adapter |
Date: | 2002-12-21 00:05:35 |
Message-ID: | au0b8l$225p$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
This is a bit backwards. ident authentication is working for me over
Unix domain sockets, but it isn't working over the loopback adapter.
Here is my /var/lib/pgsql/data/pg_hba.conf:
# Allow local and loopback users to connect to self-named databases
#
local sameuser ident sameuser
host sameuser 127.0.0.1 255.255.255.255 ident sameuser
# Allow password-based authentication for local users, loopback, and
# local subnet.
#
local all md5
host all 127.0.0.1 255.255.255.255 md5
host all 192.168.1.0 255.255.255.0 md5
I have installed the identd daemon, and 'nmap localhost' confirms that
it is listening on port 113.
Here is an example session. (I have created a PostgreSQL user named
'pilcher' and a database of the same name.)
[pilcher(at)home pilcher]$ psql
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
pilcher=> \q
[pilcher(at)home pilcher]$ psql -h localhost
psql: FATAL 1: IDENT authentication failed for user "pilcher"
Anyone have any idea what's going on?
Notes: This is Red Hat Linux 8.0. Password authentication works over
Unix domain sockets or the loopback adapter.
Thanks!
--
========================================================================
Ian Pilcher pilchman(at)attbi(dot)com
========================================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-12-21 00:24:26 | Re: ident authentication not working over loopback adapter |
Previous Message | Bruce Momjian | 2002-12-20 17:41:52 | Re: dumping tables in non-public schemas.. |