Обсуждение: Autentication exceptions in pgsql 8.3

Поиск
Список
Период
Сортировка

Autentication exceptions in pgsql 8.3

От
"Prakash, Deepthi (NSN - IN/Bangalore)"
Дата:

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

Re: Autentication exceptions in pgsql 8.3

От
John R Pierce
Дата:
On 10/23/11 9:08 PM, Prakash, Deepthi (NSN - IN/Bangalore) wrote:
>
> Hello,
>
> I am using Postgresql 8.3, I am getting the
> belowauthenticationexceptions.I am not able to connect
> usingpostgres://mpp:mpp@localhost/mpp
>
> .....
>
> host    all         all         127.0.0.1/32          ident
>
> # IPv6 local connections:
>
> host    all         all         ::1/128               ident
>

'ident' on localhost requires your system runs an authd/identd
service... is that the case?




--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

Re: Autentication exceptions in pgsql 8.3

От
"Prakash, Deepthi (NSN - IN/Bangalore)"
Дата:
Yes authd is running.
And I am using 8.4 version. Sorry for the wrong version below.

Thanks and Regards,
Deepthi


-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of ext John R
Pierce
Sent: Monday, October 24, 2011 10:05 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Autentication exceptions in pgsql 8.3

On 10/23/11 9:08 PM, Prakash, Deepthi (NSN - IN/Bangalore) wrote:
>
> Hello,
>
> I am using Postgresql 8.3, I am getting the
> belowauthenticationexceptions.I am not able to connect
> usingpostgres://mpp:mpp@localhost/mpp
>
> .....
>
> host    all         all         127.0.0.1/32          ident
>
> # IPv6 local connections:
>
> host    all         all         ::1/128               ident
>

'ident' on localhost requires your system runs an authd/identd
service... is that the case?




--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: Autentication exceptions in pgsql 8.3

От
"Prakash, Deepthi (NSN - IN/Bangalore)"
Дата:
Yes authd is running.
And I am using 8.4 version. Sorry for the wrong version below.

Thanks and Regards,
Deepthi


-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of ext John R
Pierce
Sent: Monday, October 24, 2011 10:05 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Autentication exceptions in pgsql 8.3

On 10/23/11 9:08 PM, Prakash, Deepthi (NSN - IN/Bangalore) wrote:
>
> Hello,
>
> I am using Postgresql 8.3, I am getting the
> belowauthenticationexceptions.I am not able to connect
> usingpostgres://mpp:mpp@localhost/mpp
>
> .....
>
> host    all         all         127.0.0.1/32          ident
>
> # IPv6 local connections:
>
> host    all         all         ::1/128               ident
>

'ident' on localhost requires your system runs an authd/identd
service... is that the case?




--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: Autentication exceptions in pgsql 8.3

От
Magnus Hagander
Дата:
On Monday, October 24, 2011, Prakash, Deepthi (NSN - IN/Bangalore) wrote:

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



This indicate that your auth server returned userid "[U2FsdGVkX19aYlj8eW0BPmAZ4Loziuy64Urcd4ZhMOg=]", which is obviously incorrect. Are you by any chance running with some sort of encryption/hashing in the ident server? That's not supported with PostgreSQL.

If not that, then I'm not sure exactly what it could be - but it's obvious that your ident server is reporting an incorrect username, so you'll need to investigate that one.




--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

Re: Autentication exceptions in pgsql 8.3

От
"Prakash, Deepthi (NSN - IN/Bangalore)"
Дата:

Hello,

 

How can I check that? Should I do any configurations in ident server?

 

Thanks and Regards,

Deepthi

 

From: ext Magnus Hagander [mailto:magnus@hagander.net]
Sent: Monday, October 24, 2011 1:29 PM
To: Prakash, Deepthi (NSN - IN/Bangalore)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Autentication exceptions in pgsql 8.3

 

On Monday, October 24, 2011, Prakash, Deepthi (NSN - IN/Bangalore) wrote:

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

 

 

This indicate that your auth server returned userid "[U2FsdGVkX19aYlj8eW0BPmAZ4Loziuy64Urcd4ZhMOg=]", which is obviously incorrect. Are you by any chance running with some sort of encryption/hashing in the ident server? That's not supported with PostgreSQL.

 

If not that, then I'm not sure exactly what it could be - but it's obvious that your ident server is reporting an incorrect username, so you'll need to investigate that one.

 

 



--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

Re: Autentication exceptions in pgsql 8.3

От
Magnus Hagander
Дата:
On Mon, Oct 24, 2011 at 11:06, Prakash, Deepthi (NSN - IN/Bangalore)
<deepthi.prakash@nsn.com> wrote:
> Hello,
>
>
>
> How can I check that? Should I do any configurations in ident server?

That depends on your ident server - I don't know those specifically.
But yes, it should be configured to not do that if that's what it's
doing.


--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/