[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.sraoss.jp/pipermail/pgpool-general/attachments/20201216/d705e9a7/attachment.htm>


More information about the pgpool-general mailing list