Re: invalid connection option "passfile"

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 secure email.