Skip site navigation (1) Skip section navigation (2)

Re: problems with authentication

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Chris Hoover" <revoohc(at)sermonaudio(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: problems with authentication
Date: 2004-11-23 22:36:56
Message-ID: 922.1101249416@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"Chris Hoover" <revoohc(at)sermonaudio(dot)com> writes:
> I have been handed a postgresql 7.2.1 db running on an AIX platform that 
> is suddenly having authentication errors.  We are not sure what has 
> happened, but starting last Friday we started having the following in 
> the log files.

> Password is stored MD5 encrypted.  'password' and 'crypt' auth methods 
> cannot be used.
> FATAL 1:  Password authentication failed for user "<user-name>"

Sounds like you started storing some passwords MD5-encrypted ;-)

This doesn't "just happen".  Either you issued CREATE/ALTER USER WITH
ENCRYPTED PASSWORD, or you set password_encryption to ON so that that
would be the default behavior.

> Can anyone direct me on what/where to look for fixing this issue?  I am 
> not familiar with this version of Postgresql or with it running on AIX.

On this point I think it's the same as later versions.

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Sally SallyDate: 2004-11-23 22:40:22
Subject: primary key and the default index operator class
Previous:From: Chris HooverDate: 2004-11-23 21:06:52
Subject: problems with authentication

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group