[pgpool-general: 7360] Re: User "pgpool" does not have a valid SCRAM

[Anssi Kanninen]

Hi Luis,

Have you created a scram-sha-256 type password for your user in the DB?
You can check it by: SELECT rolname, rolpassword FROM pg_authid;

Have you added the user to pool_passwd ?

Cheers,
- Anssi Kanninen


On Wed, 16 Dec 2020, Luís Alves wrote:

> 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
> 
>

-- 
anssi at iki.fi