invalid connection option "passfile"

From: hubbamubba <hubbamubba(at)proton(dot)me>
To: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: invalid connection option "passfile"
Date: 2024-03-13 14:54:18
Message-ID: 5rHGkSKWwly_FxYs2sZTYNp3cUmMr5TfxVIBoNEUDAwwhjVG_NatGUZscFdiea5BASJB1VQ203-uiKN2mAenn5SYzp7zwq3j1Jh1e5ONsvI=@proton.me
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,

Amazon linux 2
Python 3.7
Pgadmin 8.4/8.3 in server_mode installed via pip
Apache with mod_wsgi
ldap authentication
psycopg==3.1.12
psycopg-binary==3.1.12

I'm having issues using passfile on a new pgadmin4 install.
I have the app running and I can login with ldap and an internal user.
I'm also able to run setup.py and run load-servers (It reports the correct number of servers added) and I can
verify in sqlite3 db.

I can see the new server tab in the gui but when I click the new servers tab,
I get a load of errors:

Tue Mar 12 19:15:39.851547 2024] [wsgi:error] [pid 9262] [remote 172.18.1.88:38112] psycopg.ProgrammingError: invalid connection option "passfile"
[
File "/opt/pgadmin4/venv/lib/python3.7/site-packages/pgadmin4/pgadmin/utils/driver/psycopg3/server_manager.py", line 116, in update
self.create_connection_string(self.db, self.user)
File "/opt/pgadmin4/venv/lib/python3.7/site-packages/pgadmin4/pgadmin/utils/driver/psycopg3/server_manager.py", line 696, in create_connection_string
self.display_connection_string = make_conninfo(**display_dsn_args)
File "/opt/pgadmin4/venv/lib64/python3.7/site-packages/psycopg/conninfo.py", line 59, in make_conninfo
_parse_conninfo(conninfo)
File "/opt/pgadmin4/venv/lib64/python3.7/site-packages/psycopg/conninfo.py", line 98, in _parse_conninfo
raise e.ProgrammingError(str(ex))
psycopg.ProgrammingError: invalid connection option "passfile"

I get the same error if I use the gui to add a new DB connection using the passfile option.

I can't tell if this error is a really an unsupported connection param or pgadmin can't find my pgpass file. I've moved the pspass file to multiple locations but no progress.

Here is a snippet from servers.json
{ "Servers": {
"1": {
"Name": "dev-product",
"Group": "Servers",
"Host": "xxx",
"Port": 5432,
"Shared": true,
"SharedUsername": "yyy",
"Username": "yyy",
"MaintenanceDB": "postgres",
"SSLMode": "disable",
"PassFile": "../../pgpass"
},

Any thoughts?
Thanks,Tom

Sent with [Proton Mail](https://proton.me/) secure email.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Yogesh Mahajan 2024-03-13 15:20:07 Re: [External] Re: PG ADMIN INSTALLATION
Previous Message Nkundiwacu, Benit 2024-03-13 14:37:30 RE: [External] Re: PG ADMIN INSTALLATION