From: | asotolongo(at)gmail(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #14661: authentication behavior(SCRAM-MD5) |
Date: | 2017-05-19 15:05:11 |
Message-ID: | 20170519150511.29944.47622@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14661
Logged by: Anthony Sotolongo León
Email address: asotolongo(at)gmail(dot)com
PostgreSQL version: 10beta1
Operating system: Ubuntu 14.04
Description:
I have a pg_hba.conf like this:
host all usuario 0.0.0.0/0 scram-sha-256
host all postgres 0.0.0.0/0 scram-sha-256
and my user with md5 password encryption
select usename,passwd from pg_shadow ;
usename | passwd
----------+------------
postgres | md50005a4b0ccaccbd18bcf64e90e242c90
usuario | md541f55d102ea5687e95fb361019a12da4
and when try to login, login error, and return error
2017-05-19 16:51:20.312 CEST [1418] FATAL: la autentificación password
falló para el usuario «postgres»
2017-05-19 16:51:20.312 CEST [1418] DETALLE: User "postgres" does not have
a valid SCRAM verifier.
La conexión coincidió con la línea 83 de pg_hba.conf: «host all
postgres 0.0.0.0/0 scram-sha-256»
i think that is correct, but when i have the next configuracion:
pg_hba.conf
host all usuario 0.0.0.0/0 md5
host all postgres 0.0.0.0/0 md5
and my user with SCRAM encryption
postgres=# select usename,passwd from pg_shadow ;
usename |
passwd
----------+-------------------------------------------------------------------------------------------------------------------------------
usuario |
SCRAM-SHA-256$4096:Fhqo2W7V4FlVQk7+$fkQJ02YBGMhePbhVnKOcHjON/VPUTDzT/pZboiwHofY=:XliKl0leu/kpN4ZGmNPnHKKWj76f7qN8lIjrY8jOVcA=
postgres |
SCRAM-SHA-256$4096:5DcjppjZNyrGb0Jo$iomUsf0Mo0RSSjkwzhwHwRphhVG5EKLRRMVp/eiENuI=:XFIOQcd1nA1IKclPrVSwFym9N5dLuYB43CfI3Lf5zGA=
(2 filas)
and when try to login, login successfully
is correct this behavior?
Greettings
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2017-05-19 15:41:06 | Re: BUG #14635: Query is executed slower on hot standby slave database then on master database |
Previous Message | Robert Haas | 2017-05-19 12:31:15 | Re: [HACKERS] Concurrent ALTER SEQUENCE RESTART Regression |