Autentication exceptions in pgsql 8.3 - Mailing list pgsql-general

From Prakash, Deepthi (NSN - IN/Bangalore)
Subject Autentication exceptions in pgsql 8.3
Date
Msg-id 1A6F3C7F6893C146B2B3EBF64B889E7F0110B6D7@SGSIEXC007.nsn-intra.net
Whole thread Raw
Responses Re: Autentication exceptions in pgsql 8.3  (John R Pierce <pierce@hogranch.com>)
Re: Autentication exceptions in pgsql 8.3  (Magnus Hagander <magnus@hagander.net>)
List 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@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

pgsql-general by date:

Previous
From: Brandon Phelps
Date:
Subject: Re: Problem installing PostgreSQL 9.0 via Macports on OS X Server 10.6
Next
From: John R Pierce
Date:
Subject: Re: Autentication exceptions in pgsql 8.3