How to fix authentication through pgpool?
1
vote
2
answers
5947
views
I have a cluster that consists of:
1) pgpool
3) master
3) slave
Using pgpool-II version 4.3.2 and
Postgres 14.4
Several users have been created, all are authenticated through pgpool.
There was a need to create new users.
In
pool_passwd
I create entries in this way:
pg_enc -m -f /etc/pgpool2/pgpool.conf -i users.txt
(in users.txt
there are user logins and passwords)
When connecting with Dbeaver
> ERROR: backend authentication failed
> Details: backend response with
> kind 'E' when expecting 'R'
pg_md5 -m --config-file="/etc/pgpool2/pgpool.conf" -u "user" "pass"
> ERROR: failed to authenticate with backend using SCRAM
> Details: valid password not found
pool_hba.conf
:
host all all 10.99.0.0/32 scram-sha-256
host all postgres 0.0.0.0/0 scram-sha-256
local all all md5
local all postgres scram-sha-256
host all all 127.0.0.1/32 md5
host all all ::1/128 md5
host all all 0.0.0.0/0 md5
local all all trust
host all all 10.99.0.0/32 trust
What could be the problem?
Asked by Magi
(141 rep)
Jul 12, 2022, 11:10 AM
Last activity: Feb 17, 2025, 09:06 AM
Last activity: Feb 17, 2025, 09:06 AM