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


Reply via email to