Password exec troubleshooting - Mailing list pgadmin-support

From Matt Warren
Subject Password exec troubleshooting
Date
Msg-id D335D0B3-2B00-444B-8D37-AFB6E9787460@tramat.com
Whole thread Raw
Responses Re: Password exec troubleshooting
List pgadmin-support
Hello pgadmin-support
Long-time user, first time emailing.

I’m trying to use the Password exec feature to fetch a secret from AWS Secrets Manager. I’ve created both a python script and then a sh script and neither work. Oddly nothing about password exec is reported in logs. I just get the error below. 

pgAdmin 4 v 9.7 as desktop app
python 3.13.7
macOS 15.7.1

Things I’ve tried:

  • Executing either script from the command line works as expected and returns just the password string.
  • scripts have chmod +x for all users.
  • I’ve provided the full path to script in the Password exec entry
  • Tried quoting and escaping command line.
  • The shell script uses aws cli and full path is provided in script.
  • Moved the script to the ~/Library/Application Support/pgAdmin 4 in case macOS disk access issues were in play.

Error:

connection failed: connection to server at “10.x.x.x", port 5432 failed: could not initiate GSSAPI security context: Unspecified GSS failure. Minor code may provide more information: Cannot find KDC for realm "KERBEROS.MICROSOFTONLINE.COM"
connection to server at “10.x.x.x", port 5432 failed: fe_sendauth: no password supplied

From what I can parse of source code, I don’t think the ENABLE_SERVER_PASS_EXEC_CMD comes into play as I’m not operating in server mode.

Does anyone have examples of a config that works?
Any advice on how I can debug further? 

Thanks for any pointers!

pgadmin-support by date:

Previous
From: Bastiaan Wakkie
Date:
Subject: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied
Next
From: Aditya Toshniwal
Date:
Subject: Re: Password exec troubleshooting