| 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: | Whole Thread | Raw Message | 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
| 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 |