Re: Issue with Password Authentication for Pgpool

[Martin Gainty <mgainty@xxxxxxxxxxx>]

assuming you are implementing kubernetes

kubectl exec -it $(kubectl get pods -l app.kubernetes.io/component=pgpool,app.kubernetes.io/name=postgresql-ha -o jsonpath='{.items[0].metadata.name}') -- pg_md5 -m --config-file="/opt/bitnami/pgpool/conf/pgpool.conf" -u "foo" "bar"

//cat out pgpool afterwards

pgpool:
  customUsers:
    usernames: "keycloak vkp"
    passwords: "my_keycloak*PWD vkp*PWD"

Users and passwords are separated by a space character.

ju

---

From: vijay patil <vijay.postgres@xxxxxxxxx>
Sent: Thursday, January 9, 2025 12:06 AM
To: pgpool-general@xxxxxxxxxx <pgpool-general@xxxxxxxxxx>; pgsql-general@xxxxxxxxxxxxxxxxxxxx <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
Subject: Issue with Password Authentication for Pgpool

 

Hello Everyone,

Need assistance on below requirements. 

My requirement is to prompt for a password when connecting through Pgpool (port 9999) and to avoid using the pool_password file. However, I’m currently getting the error related to the lack of an entry in the pool_passwd file.

Could you please advise how I can achieve password authentication without using the pool_password file, while ensuring that Pgpool prompts for the password during connection?

Here is the relevant configuration from my pool_hba.conf:

host    all         all         10.125.0.90/32       trust            # Node 1
host    all         all         10.125.0.91/32       trust            # Node 2
#host    all         all         10.125.0.79/32       scram-sha-256    # Node 3
host    all         all         0.0.0.0/0            scram-sha-256    # All nodes

error :-
[postgres@scrbtrheldbaas002 PG_DATA]$ psql -h 10.125.0.79 -U vkp -d postgres -p 9999
psql: error: connection to server at "10.125.0.79", port 9999 failed: FATAL:  SCRAM authentication failed
DETAIL:  pool_passwd file does not contain an entry for "vkp"