[pgpool-general: 7359] User "pgpool" does not have a valid SCRAM
Luís Alves
luisalves00 at gmail.com
Wed Dec 16 17:51:51 JST 2020
I'm getting:
2020-12-16 08:21:59.766 GMT [502] LOG: connection received:
host=10.230.4.147 port=34162
2020-12-16 08:21:59.774 GMT [502] FATAL: password authentication failed
for user "pgpool"
2020-12-16 08:21:59.774 GMT [502] DETAIL: User "pgpool" does not have a
valid SCRAM verifier.
Connection matched pg_hba.conf line 34: "host all
all 0.0.0.0/0 scram-sha-256"
(pg_hba.conf is quite permissive for now so I can access individual nodes
directly)
I have:
postgres=# \du
List of roles
Role name | Attributes |
Member of
-----------+------------------------------------------------------------+--------------
pgpool | |
{pg_monitor}
postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
repl | Replication | {}
and
# - Authentication -
#authentication_timeout = 1min # 1s-600s
#password_encryption = md5 # md5 or scram-sha-256
password_encryption = scram-sha-256
#db_user_namespace = off
Where should I look to provide the proper authentication?
Regards,
Luís Alves
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20201216/d705e9a7/attachment.htm>
More information about the pgpool-general
mailing list