pgadmin-org / pgadmin-org/pgadmin4

passfile not used as standard user for shared servers since 9.15

Open
#10,137 1 comment 2 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Bug
Dominant language
Python
Stars
3.8k
Forks
891
Avg merge
4d 7h
Merged PRs (30d)
8

Description

Probably related with https://github.com/pgadmin-org/pgadmin4/issues/10136

Describe the bug

Since 9.15, standard users can not use the passfile defined in the connectionparameters of the shared server, it will ask for the password instead of connecting automatically. Admin can still use the passfile though.

To Reproduce

Steps to reproduce the behavior:

  1. Define a servers.json in /pgadmin4/ with passfile as connectionparameter, and shared "true"
  2. Start pgadmin
  3. Connect as standard user, a password prompt will appear when selecting the connection
  4. Connect as admin, no password prompt, connection is working

Expected behavior

The user should be able to use the passfile if shared by the admin as before 9.15.

Error message

no error found.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the servers.json handling and the shared-server connection path, then reproduce the difference between standard-user and admin connections using the documented passfile connection parameter. The work is done when a standard user can connect to a shared server without a password prompt, while the existing admin behavior remains intact.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, python
Domain
backend, database
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
52/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.