Saved passwords on shared servers broken for unprivileged users #5367
Description
On a clean installation of PgAdmin with LDAP authentication in server mode, based on the official Docker image version 6.14 I have the following issue:
- Add a shared server as admin. Log out.
- Login as an unprivileged user, set server Username under Properties > Connection.
- Try to connect inserting the password and saving it -> it works.
- Disconnect server (or logout) then re-connect to server, the following error shows:
not enough values to unpack (expected 3, got 2)
Logs:
File "/pgadmin4/pgadmin/utils/driver/psycopg2/connection.py", line 240, in _decode_password │
│ password = password.decode() │
│ UnicodeDecodeError: 'utf-8' codec can't decode byte 0xe3 in position 1: invalid continuation byte │
│ 2022-09-25 17:05:39,203: ERROR pgadmin: not enough values to unpack (expected 3, got 2) │
│ Traceback (most recent call last): │
│ File "/pgadmin4/pgadmin/browser/server_groups/servers/__init__.py", line 1411, in connect │
│ status, errmsg = conn.connect( │
│ File "/pgadmin4/pgadmin/utils/driver/psycopg2/connection.py", line 292, in connect │
│ is_error, errmsg, password = self._decode_password(encpass, manager, │
│ ValueError: not enough values to unpack (expected 3, got 2) │
Note: saving passwords and connecting to servers seems to work fine for the admin user (same steps as above with no error).
I have not managed to get this to work, and I wouldn't want users to have to enter the password every time. That's what the "save password" option is for. Am I missing something here? It looks like a bug.