.::: PostgreSQL 18 Access via Pgpool-II – SCRAM Authentication with AES-Encrypted fix psql: error: connection to server at "10.10.10.0", port 9999 failed: ERROR: failed to authenticate with backend using SCRAM :::.

  

1. login as root 

echo 'rahasia' > /root/.pgpoolkey
chmod 600 /root/.pgpoolkey
 

2. create sample user n password

create user adminaes ;
ALTER ROLE adminaes SUPERUSER CREATEDB CREATEROLE REPLICATION;
ALTER ROLE adminaes PASSWORD 'adminaes';
ALTER USER adminaes WITH PASSWORD 'adminaes';
 
3. test login direct 
PGPASSWORD=adminaes psql -h 10.10.10.31 -p 5432 -U adminaes -d teguhth

4. test login via pgpool

PGPASSWORD=adminaes psql -h 10.10.10.25 -p 9999 -U adminaes -d teguhth
psql: error: connection to server at "10.10.10.0", port 9999 failed: ERROR:  failed to authenticate with backend using SCRAM
 

5. cat before

cat /etc/pgpool-II/pool_passwd

 

6. create user ecripted 

pg_enc -m -k /root/.pgpoolkey -u adminaes -f /etc/pgpool-II/pgpool.conf

 

 

7. test login via pgpool