Re: invalid connection option "passfile"

Поиск
Список
Период
Сортировка
От hubbamubba
Тема Re: invalid connection option "passfile"
Дата
Msg-id 9VJ73MRQAiZ-ZyLw406QlsfH-jZUPh2I3gcL-GzYEVLUnax_lzcA5N573ZPBykaK0ACqwfXjXwGWsyRgBBj4ec7S0LkpWGezYNTqyIDjiLc=@proton.me
обсуждение исходный текст
Ответ на invalid connection option "passfile"  (hubbamubba <hubbamubba@proton.me>)
Ответы Re: invalid connection option "passfile"  (Akshay Joshi <akshay.joshi@enterprisedb.com>)
Список pgadmin-support
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'


Sent with Proton Mail secure email.

On Wednesday, March 13th, 2024 at 7:54 AM, hubbamubba <hubbamubba@proton.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 secure email.

В списке pgadmin-support по дате отправления:

Предыдущее
От: "Nkundiwacu, Benit"
Дата:
Сообщение: RE: [External] Re: PG ADMIN INSTALLATION
Следующее
От: Yogesh Mahajan
Дата:
Сообщение: Re: [External] Re: PG ADMIN INSTALLATION