md5 doesn't work (Was Re: Pet Peeves?)
От | Jeff Frost |
---|---|
Тема | md5 doesn't work (Was Re: Pet Peeves?) |
Дата | |
Msg-id | Pine.LNX.4.64.0901291132160.17834@discord обсуждение исходный текст |
Ответ на | Re: Pet Peeves? (rhubbell <Rhubbell@iHubbell.com>) |
Ответы |
Re: md5 doesn't work (Was Re: Pet Peeves?)
|
Список | pgsql-general |
On Thu, 29 Jan 2009, rhubbell wrote: > Umm, because md5 doesn't work and trust does work. Generally this is because you haven't yet set a password for the postgres user. You have to set a password for at least the postgres user via ALTER ROLE while you've still got it set to trust or ident before changing to md5. > On Thu, 29 Jan 2009 13:16:19 -0500 > Bill Moran <wmoran@potentialtech.com> wrote: > >> In response to rhubbell <Rhubbell@iHubbell.com>: >>> >>> I'm a new user to PostgreSQL so mine's fresh from doing an install recently. >>> >>> In /etc/postgresql/8.3/main/pg_hba.conf >>> >>> # METHOD can be "trust", "reject", "md5", "crypt", "password", "gss", "sspi", >>> # "krb5", "ident", "pam" or "ldap". Note that "password" sends passwords >>> # in clear text; "md5" is preferred since it sends encrypted passwords. >>> >>> >>> So I chose md5 but it will not work, seems like a basic thing. So I am >>> forced to use "trust". >> >> How on earth does failure of md5 to work force you to use trust? >> >> How about crypt or password (password is pretty darn simple to set up). >> -- Jeff Frost, Owner <jeff@frostconsultingllc.com> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 916-647-6411 FAX: 916-405-4032
В списке pgsql-general по дате отправления: