Re: invalid connection option "passfile"

Hi Hubbamubba

On Fri, Mar 15, 2024 at 11:01 PM hubbamubba <hubbamubba(at)proton(dot)me> wrote:

> This is the exception from the pgadmin4 log file
>
> 2024-03-13 19:22:50,053: ERROR pgadmin: 'NoneType' object has no attribute
> 'version'
> Traceback (most recent call last):
> File "/opt/pgadmin4/venv/lib64/python3.7/site-packages/flask/app.py",
> line 1823, in full_dispatch_request
> rv = self.dispatch_request()
> File "/opt/pgadmin4/venv/lib64/python3.7/site-packages/flask/app.py",
> line 1799, in dispatch_request
> return
> self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
> File "/opt/pgadmin4/venv/lib64/python3.7/site-packages/flask/views.py",
> line 107, in view
> return current_app.ensure_sync(self.dispatch_request)(**kwargs)
> File
> "/opt/pgadmin4/venv/lib/python3.7/site-packages/pgadmin4/pgadmin/browser/utils.py",
> line 309, in dispatch_request
> return method(*args, **kwargs)
> File
> "/opt/pgadmin4/venv/lib/python3.7/site-packages/pgadmin4/pgadmin/browser/utils.py",
> line 344, in children
> children = self.get_children_nodes(*args, **kwargs)
> File
> "/opt/pgadmin4/venv/lib/python3.7/site-packages/pgadmin4/pgadmin/browser/utils.py",
> line 365, in get_children_nodes
> children.extend(module.get_nodes(*args, **kwargs))
> File
> "/opt/pgadmin4/venv/lib/python3.7/site-packages/pgadmin4/pgadmin/browser/server_groups/servers/__init__.py",
> line 279, in get_nodes
> version=manager.version,
> AttributeError: 'NoneType' object has no attribute 'version'
>

Does this error occur after changing the servers.json file? Can you
please provide the exact steps to reproduce?

>
>
> Sent with Proton Mail <https://proton.me/> secure email.
>
> On Wednesday, March 13th, 2024 at 7:54 AM, hubbamubba <
> hubbamubba(at)proton(dot)me> wrote:
>
> 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.
>
>
>