BUG #14661: authentication behavior(SCRAM-MD5)

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

Responses

Browse pgsql-bugs by date

  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