Thread: 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 a internal user.
I'm also able to run setup.py 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 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 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?
Thanks,
Tom
Sent with Proton Mail secure email.
On Tuesday, March 12, 2024, hubbamubba <hubbamubba@proton.me> wrote:
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
The server has zero use for a password file, it is a client thing, so a connection option named passfile makes no sense. Where did you get the idea that it would be valid?
Also, pgAdmin the third-party product has its own support list and/or separate site - this list is for basic administration of the server itself.
David J.
Crap! Sorry, I thought this was the mailing list for the padmin4 product.
Sent with Proton Mail secure email.
On Wednesday, March 13th, 2024 at 5:12 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Tuesday, March 12, 2024, hubbamubba <hubbamubba@proton.me> wrote: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 progressThe server has zero use for a password file, it is a client thing, so a connection option named passfile makes no sense. Where did you get the idea that it would be valid?Also, pgAdmin the third-party product has its own support list and/or separate site - this list is for basic administration of the server itself.David J.