CODEWITHSUNDEEP
postgresqlpgadmin-4
iFunction
iFunction

Reputation: 1268

pgadmin can't log in after update

Just updated pgadmin4 to version 4.8 and now it won't accept ssh tunnel password into server, I get the following error message:

Failed to decrypt the SSH tunnel password. Error: 'utf-8' codec can't decode byte 0x8c in position 0: invalid start byte

Is there a way around this, I can't restart the database server at this time.

Upvotes: 12

Views: 6731

Answers (3)

Ilyas Dautov
Ilyas Dautov

Reputation: 1

As said Murtuza Z, in https://redmine.postgresql.org/issues/4320, you can get fixed server_manager.py and replace it at (pgAdmin install dir)/web/pgadmin/utils/driver/psycopg2/server_manager.py, then restart the pgadmin server.

You can get server_manager.py:

  • It is attached in an issue info. < this worked for me.
  • Get from snapshots provided by Murtuza Z in same directory.

Upvotes: 0

blindguy
blindguy

Reputation: 1009

This also happened for me moving from 4.8.2 for Ubuntu 18.10 to 4.8.2 for Ubuntu 19.04 (different installs). I was able to resolve this by restarting the postgres server with sudo systemctl restart postgresql

Upvotes: 1

Murtuza Z
Murtuza Z

Reputation: 6017

In latest pgAdmin4 version they have increased the security of saved password by implementing master password feature, I think that is causing this issue, meantime you can rename pgadmin4.db to pgadmin4.db_OLD and restart pgAdmin4.

Note: You have to add the all the servers again.

---------- UPDATE ----------

It has been fixed now https://redmine.postgresql.org/issues/4320 and will be in 4.9.

You can try nightly builds though https://postgresql.org/ftp/pgadmin/pgadmin4/snapshots

Upvotes: 4

Related Questions