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

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

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

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/

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/

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/