Autentication exceptions in pgsql 8.3

Поиск
Список
Период
Сортировка
От Prakash, Deepthi (NSN - IN/Bangalore)
Тема Autentication exceptions in pgsql 8.3
Дата
Msg-id 1A6F3C7F6893C146B2B3EBF64B889E7F0110B6D7@SGSIEXC007.nsn-intra.net
обсуждение исходный текст
Ответы Re: Autentication exceptions in pgsql 8.3
Re: Autentication exceptions in pgsql 8.3
Список 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 по дате отправления:

Предыдущее
От: Brandon Phelps
Дата:
Сообщение: Re: Problem installing PostgreSQL 9.0 via Macports on OS X Server 10.6
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Autentication exceptions in pgsql 8.3