From: Bryce Nesbitt <bryce1@obviously.com>
To: pgsql-sql@postgresql.org
Subject: Changing auth type in pg_hba.conf ineffective. Why?
Date: Thu, 24 Nov 2005 13:18:30 -0800
Message-ID: <43862E26.3010204@obviously.com> (raw)
In-Reply-To: <20051020211003.8C1D3F0BCB@svr2.postgresql.org>
References: <20051020211003.8C1D3F0BCB@svr2.postgresql.org>
I'm struggling to resolve a login error. It seems that I'm getting
"ident" authentication, no mater what I set pg_hba.conf to. Here's a
log file:
LOG: next transaction ID: 602; next OID: 17232
LOG: database system is ready
...
FATAL: Ident authentication failed for user "bryce"
LOG: could not connect to Ident server at address "::1", port 113:
Connection refused
This makes sense, because no identd is running, and port 113 is blocked
anyway. So I need another auth method.
My relevant pg_hba.conf lines are:
#local all all ident sameuser
#host all all 127.0.0.1/32 ident sameuser
#host all all ::1/128 ident sameuser
local all all md5
host all all 127.0.0.1/32 trust
host all all ::1/128 md5
I've renamed pg_hba.conf temporarily, just to verify that postmaster
won't start without it. So I'm editing the right file, and restarting
postmaster correctly. Any clues why I'm still getting 'auth' method
authentication?
Environment:
I'm using JDBC (Java Database Connection)
PostgreSQL version 8.0.3
SUSE Linux 10.0
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bryce1@obviously.com
Subject: Re: Changing auth type in pg_hba.conf ineffective. Why?
In-Reply-To: <43862E26.3010204@obviously.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox