[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