pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
problems with authentication
5+ messages / 4 participants
[nested] [flat]

* problems with authentication
@ 1970-01-01 00:00  Chris Hoover <revoohc@sermonaudio.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Chris Hoover @ 1970-01-01 00:00 UTC (permalink / raw)
  To: pgsql-admin

Once again, I am in need of some assistance.

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>"

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.

thanks for any help.

Chris





^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Problems with authentication
@ 2003-01-21 19:14  Frans Haarman <frans@haarman.com>
  0 siblings, 2 replies; 5+ messages in thread

From: Frans Haarman @ 2003-01-21 19:14 UTC (permalink / raw)
  To: pgsql-admin

Hi,

I am building a webapplication for school, as a project.

Basicly I want users to connect with their postgresql password an
username.

I tried:
local all password

but then it asks for a password when booting the server, and I would
like to have this done automaticly.

Basicly I want everybody to require a password, and have the server
startup automaticly.

Thanks for any help.

Warm regards,

Frans



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Problems with authentication
@ 2003-01-22 20:00  Bruno Wolff III <bruno@wolff.to>
  parent: Frans Haarman <frans@haarman.com>
  1 sibling, 0 replies; 5+ messages in thread

From: Bruno Wolff III @ 2003-01-22 20:00 UTC (permalink / raw)
  To: Frans Haarman <frans@haarman.com>; +Cc: pgsql-admin

On Tue, Jan 21, 2003 at 20:14:56 +0100,
  Frans Haarman <frans@haarman.com> wrote:
> Hi,
> 
> I am building a webapplication for school, as a project.
> 
> Basicly I want users to connect with their postgresql password an
> username.
> 
> I tried:
> local all password
> 
> but then it asks for a password when booting the server, and I would
> like to have this done automaticly.
> 
> Basicly I want everybody to require a password, and have the server
> startup automaticly.

In 7.3 there is a user column in the hba file that you can use to except
the web account from a password check.

Since you are using local, you might also consider using ident authentication.
If people aren't sharing accounts, this probably gives you what you want.



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Problems with authentication
@ 2003-01-22 21:55  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Frans Haarman <frans@haarman.com>
  1 sibling, 0 replies; 5+ messages in thread

From: Tom Lane @ 2003-01-22 21:55 UTC (permalink / raw)
  To: Frans Haarman <frans@haarman.com>; +Cc: pgsql-admin

Frans Haarman <frans@haarman.com> writes:
> I tried:
> local all password
> but then it asks for a password when booting the server, and I would
> like to have this done automaticly.

You could tell the pg_ctl script not to try to check whether the
postmaster started; then it won't need to connect and so won't need
a password.  I forget the switch for this, but it's in the docs.

But in general, password auth is a pain in the neck for all admin
duties.  I agree with Bruno Wolff's suggestion to look at alternative
auth methods.  "ident" on local connections is secure, if your operating
system supports it.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: problems with authentication
@ 2004-11-23 22:36  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Chris Hoover <revoohc@sermonaudio.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Tom Lane @ 2004-11-23 22:36 UTC (permalink / raw)
  To: Chris Hoover <revoohc@sermonaudio.com>; +Cc: pgsql-admin

"Chris Hoover" <revoohc@sermonaudio.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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2004-11-23 22:36 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1970-01-01 00:00 problems with authentication Chris Hoover <revoohc@sermonaudio.com>
2004-11-23 22:36 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-01-21 19:14 Problems with authentication Frans Haarman <frans@haarman.com>
2003-01-22 20:00 ` Re: Problems with authentication Bruno Wolff III <bruno@wolff.to>
2003-01-22 21:55 ` Re: Problems with authentication Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox