#1 Tue 07 April 2020 23:56
- MAHE_Alain
- Juste Inscrit !
- Date d'inscription: 7 Apr 2020
- Messages: 2
Erreur pgpool II
Bonjour,
J'ai installe et configure pgpool-II, mais j'ai l'erreur suivante:
[postgres@mfle1356p log]$ psql -h vippgpoolpoc -p 9999 -U postgres
psql: ERROR: SCRAM authentication failed
DETAIL: unable to decrypt password from pool_passwd
HINT: verify the valid pool_key exists
[postgres@mfle1356p pgpool-II]$ cat pool_hba.conf
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
host all all ::1/128 trust
host all all 10.66.13.0/0 scram-sha-256
[postgres@mfle1356p pgpool-II]$ cat pool_passwd
pgpool:AESUlhhzCC3fyJ6JPRfMQd4bg==
postgres:AESmg984I6Thqc/kTSF83nUDg==
pgpool.conf
# - Authentication -
enable_pool_hba = on
pool_passwd = 'pool_passwd'
Hors ligne
#2 Thu 30 April 2020 16:46
- MAHE_Alain
- Juste Inscrit !
- Date d'inscription: 7 Apr 2020
- Messages: 2
Re: Erreur pgpool II
Merci,
J'ai r?solue mon probl?me
Hors ligne