invalid connection option "passfile"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



Amazon linux 2
Python 3.7
Pgadmin 8.4/8.3 in server_mode installed via pip
Apache with mod_wsgi
ldap authentication

I'm having issues using passfile on a new pgadmin4 install.
I have the app running and I can login with ldap and a internal user.
I'm also able to run and run load-servers (It reports the correct number of servers added).
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] psycopg.ProgrammingError: invalid connection option "passfile"
 File "/opt/pgadmin4/venv/lib/python3.7/site-packages/pgadmin4/pgadmin/utils/driver/psycopg3/", 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/", 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/", line 59, in make_conninfo
  File "/opt/pgadmin4/venv/lib64/python3.7/site-packages/psycopg/", 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 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.

Any thoughts?

Sent with Proton Mail secure email.

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux