auth problem

Started by Vasiliy G Tolstovover 16 years ago4 messagesgeneral
Jump to latest
#1Vasiliy G Tolstov
v.tolstov@selfip.ru

Hello.
Today i'm try to install postresql an init database

initdb --pgdata=/media/pgsql --encoding=utf8 --locale=en_US.UTF-8
--auth=crypt --username=postgres --pwprompt

password is crypted $1$qJzh/8AD$Q0wVsHF9XE9NmA/8uKjy2/

then i start postgresql and try to connect via psql following message
appears in syslog:

cannot use authentication method "crypt" because password is
MD5-encrypted

How can i use crypted passwords with pgsql?

--
Vasiliy G Tolstov <v.tolstov@selfip.ru>
Selfip.Ru

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Vasiliy G Tolstov (#1)
Re: auth problem

On Mon, 2009-10-12 at 15:17 +0400, Vasiliy G Tolstov wrote:

Hello.
Today i'm try to install postresql an init database

initdb --pgdata=/media/pgsql --encoding=utf8 --locale=en_US.UTF-8
--auth=crypt --username=postgres --pwprompt

password is crypted $1$qJzh/8AD$Q0wVsHF9XE9NmA/8uKjy2/

then i start postgresql and try to connect via psql following message
appears in syslog:

cannot use authentication method "crypt" because password is
MD5-encrypted

How can i use crypted passwords with pgsql?

Use --auth=md5.

#3Vasiliy G Tolstov
v.tolstov@selfip.ru
In reply to: Peter Eisentraut (#2)
Re: auth problem

В Пнд, 12/10/2009 в 15:04 +0300, Peter Eisentraut пишет:

Use --auth=md5.

Why? crypt is deprecated?

--
Vasiliy G Tolstov <v.tolstov@selfip.ru>
Selfip.Ru

#4Peter Eisentraut
peter_e@gmx.net
In reply to: Vasiliy G Tolstov (#3)
Re: auth problem

On Mon, 2009-10-12 at 16:06 +0400, Vasiliy G Tolstov wrote:

В Пнд, 12/10/2009 в 15:04 +0300, Peter Eisentraut пишет:

Use --auth=md5.

Why? crypt is deprecated?

Yes, and removed in 8.4.