Postgres Pro
Downloads
Home   >   mailing lists

Thread: auth problem

auth problem

From
Vasiliy G Tolstov
Date:
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

Re: auth problem

From
Peter Eisentraut
Date:
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.

Re: auth problem

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

>
> Use --auth=md5.
>

Why? crypt is deprecated?

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

Re: auth problem

From
Peter Eisentraut
Date:
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.