Password authentication disabled due to MD5 usage
От | Peter Schuller |
---|---|
Тема | Password authentication disabled due to MD5 usage |
Дата | |
Msg-id | 1042112197.19209.78.camel@prometheus обсуждение исходный текст |
Ответы |
Re: Password authentication disabled due to MD5 usage
|
Список | 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.schuller@infidyne.com>' Key retrival: Send an E-Mail to getpgpkey@scode.org E-Mail: peter.schuller@infidyne.com Web: http://www.scode.org
В списке pgsql-admin по дате отправления: