pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedproblems with authentication
5+ messages / 4 participants
[nested] [flat]
* problems with authentication
@ 1970-01-01 00:00 Chris Hoover <revoohc@sermonaudio.com>
2004-11-23 22:36 ` Re: problems with authentication Tom Lane <tgl@sss.pgh.pa.us>
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
* Re: problems with authentication
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>
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
* Problems with authentication
@ 2003-01-21 19:14 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>
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-21 19:14 Problems with authentication Frans Haarman <frans@haarman.com>
@ 2003-01-22 20:00 ` Bruno Wolff III <bruno@wolff.to>
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-21 19:14 Problems with authentication Frans Haarman <frans@haarman.com>
@ 2003-01-22 21:55 ` Tom Lane <tgl@sss.pgh.pa.us>
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
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