pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedmd5 authentication working?
2+ messages / 2 participants
[nested] [flat]
* md5 authentication working?
@ 2004-08-04 03:05 Steve Bergman <steve@rueb.com>
0 siblings, 1 reply; 2+ messages in thread
From: Steve Bergman @ 2004-08-04 03:05 UTC (permalink / raw)
To: pgsql-admin
Hi,
I'm getting ready to open up port 80 of my apache/pgsql server to the
world and am working on tightening up security.
I have password based authentication working with phpPgAdmin, and Apache
mod_auth_pgsql, as well as PHP.
However, when I set the authentication to md5:
local all all md5
in pg_hba.conf it just works. Always. It doesn't matter if I have
auth_PG_hash_type set to CRYPT in auth_pgsql.conf, or whether or not I:
alter user USERNAME with password PASSWORD
or
alter user USERNAME with encrypted password PASSWORD
No matter what I do, as long as the user and password are correct, it
works. If I set the passwords differently, it correctly denies access.
Looking in /var/lib/pgsql/global/pg_pwd shows passwords with an md5
prefix and which are obviously encrypted. In fact, even the users I
have not altered to use encrypted passwords have them.
I'm running Fedora Core 1 with the vendor provided 7.4.2-1 rpms, and
stock Fedora Core 1 apache and mod_auth_pgsql. PHP is 5.0.0 from
php.net.
So, is my information old, and md5 is "just standard" now? Or is
something else going on?
Thanks,
Steve Bergman
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: md5 authentication working?
@ 2004-08-04 05:20 Tom Lane <tgl@sss.pgh.pa.us>
parent: Steve Bergman <steve@rueb.com>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2004-08-04 05:20 UTC (permalink / raw)
To: Steve Bergman <steve@rueb.com>; +Cc: pgsql-admin
Steve Bergman <steve@rueb.com> writes:
> So, is my information old, and md5 is "just standard" now?
It is default now. I think you'd need to say ALTER USER u WITH
UNENCRYPTED PASSWORD 'foo' to push a cleartext password into pg_shadow.
(There may also still be a postgresql.conf setting that affects this,
but I'm too lazy to go look.)
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-08-04 05:20 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-04 03:05 md5 authentication working? Steve Bergman <steve@rueb.com>
2004-08-04 05:20 ` 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