Password authentication disabled due to MD5 usage

From: Peter Schuller <peter(dot)schuller(at)infidyne(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Password authentication disabled due to MD5 usage
Date: 2003-01-09 11:36:37
Message-ID: 1042112197.19209.78.camel@prometheus
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

since I upgraded PostgreSQL it now stores passwords in MD5 format. When
I try connecting using password authentication, i get:

Jan 9 12:22:24 prometheus postgres[28540]: [2] LOG: Password is stored
MD5 encrypted. 'password' and 'crypt' auth methods cannot be used.

Now, if password and crypt are no longer available, how am I supposed to
connect through TCP at all? Assuming I don't want to set up kerberos or
something just to get PostgreSQL working :)

The the more important question is, how do I change this back? In the
current situation I couldn't care less about this type of security
because everything is done on the loopback interface so plain text is
fine. I just need to be able to connect using password authentication
(I'm using JDBC).

Any pointers are greatly appreciated. Thanks!

--
/ Peter Schuller, InfiDyne Technologies HB

PGP userID: 0xE9758B7D or 'Peter Schuller <peter(dot)schuller(at)infidyne(dot)com>'
Key retrival: Send an E-Mail to getpgpkey(at)scode(dot)org
E-Mail: peter(dot)schuller(at)infidyne(dot)com Web: http://www.scode.org

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2003-01-09 14:58:24 Re: Password authentication disabled due to MD5 usage
Previous Message Jack Flak 2003-01-09 08:27:18 Re: restore/dup OIDs HELP!