Autentication exceptions in pgsql 8.3

From: "Prakash, Deepthi (NSN - IN/Bangalore)" <deepthi(dot)prakash(at)nsn(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Autentication exceptions in pgsql 8.3
Date: 2011-10-24 04:08:17
Message-ID: 1A6F3C7F6893C146B2B3EBF64B889E7F0110B6D7@SGSIEXC007.nsn-intra.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I am using Postgresql 8.3, I am getting the below authentication
exceptions. I am not able to connect using
postgres://mpp:mpp(at)localhost/mpp

LOG: provided username (mpp) and authenticated username
([U2FsdGVkX1/4XrEZ3dfREbh66kqWj66oEZjvotlVtqo=]) don't match
FATAL: Ident authentication failed for user "mpp"
LOG: provided username (mpp) and authenticated username
([U2FsdGVkX19aYlj8eW0BPmAZ4Loziuy64Urcd4ZhMOg=]) don't match

Here is my contents in pg_ident.conf

# MAPNAME SYSTEM-USERNAME PG-USERNAME
mpp mpp mpp

Here are my contents in pg_hba.conf

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all postgres ident
local all mpp ident
local all mppadmin ident
local all all ident

# IPv4 local connections:
host all all 127.0.0.1/32 ident
# IPv6 local connections:
host all all ::1/128 ident

I tried adding the map and key value too but it did not help.
Please help to resolve this issue.

Thanks and Regards,
Deepthi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2011-10-24 04:34:57 Re: Autentication exceptions in pgsql 8.3
Previous Message Brandon Phelps 2011-10-24 03:59:56 Re: Problem installing PostgreSQL 9.0 via Macports on OS X Server 10.6