Обсуждение: Autentication exceptions in pgsql 8.3
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
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
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
--
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/