Error in passing the password in servers.json file while deploying pgadmin4 in kubernetes cluster

From: Samrat Gurung <grgsamrat785(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Error in passing the password in servers.json file while deploying pgadmin4 in kubernetes cluster
Date: 2024-03-15 16:41:40
Message-ID: CAESVGa3xzVn+qHBW3Fum=fx532uD2M3Pi-3Spo5yKamVw7guxQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

deployment.yaml file

containers:
- image: postgres:8.4
env:
- name: PFADMIN_SERVER_JSON_FILE
value: /pgadmin4/servers.json
volumeMounts:
- name: server-config
mountPath: /pgadmin4/servers.json
subPath: servers.json
- name: password-config
mountPath: /var/lib/storage/pgpass
subPath: pgpass
volumes:
- name: password-config
configMap:
name: pgad-password-config
- name: pgad-server-config
configMap:
name: server-config

configmap for servers.json
kind: ConfigMap
apiVersion: v1
metadata:
name: pgad-server-config
data:
servers.json: |
{
"Servers": {
"1": {
"Name": "My Postgres Server",
"Group": "Servers",
"Host": "host.docker.internal",
"Port": 5432,
"MaintenanceDB": "postgres",
"Username": "postgres",
"PassFile": "/var/lib/storage/pgpass",
"SSLMode": "prefer",
"ConnectionTimeout":10,
"SavePassword": true,
}
}
}

configmap for pgpass
kind: ConfigMap
apiVersion: v1
metadata:
name: password-config
data:
pgpass: |
hostname:port:database:username:password

The issue is when i log in to the postgres, i can see the server but it is
prompting me to enter the password so it is not able to read the one i
supplied.

i get this error in the UI: connection failed: fe_sendauth: no password
supplied

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Aditya Toshniwal 2024-03-18 04:42:17 Re: Error in passing the password in servers.json file while deploying pgadmin4 in kubernetes cluster
Previous Message Bhaskaran, Sanoop 2024-03-15 16:20:04 RE: [External] Re: PG ADMIN INSTALLATION