PGadmin4 login doesn't work after upgrade from 4.3 to 8.1 - Ubuntu

[shrineanand]

Running PGadmin4 in an Ubuntu machine which was 4.3 version. Upgraded using sudo apt upgrade pgadmin4 command and it was upgraded to 8.1

After upgrade I tried to login to the web application PGadmin4 and I couldn't login. It is not throwing any error in the console or Inspect element.

How to fix this issue

Ubuntu 20.04.1
Postgresql 12
PGadmin4

[yogeshmahajan-1903]

@shrineanand
Can you please share error screenshot? Also can you please share pgadmin logs located at '/var/logs/pgadmin/pgadmin4.log'?

[shrineanand]

@yogeshmahajan-1903
I tried to do an upgrade this morning. Reverted the upgrade change. so the Pgadmin was in the 4.3 version and the Postgres in 12.
I have upgraded one of my AWS RDS DB server PostgreSQL engines from 11.19 to 15.2. Tried connecting to the server from PGadmin version 4.3 and got the error. 'ServerManager' object has no attribute 'user_info'

I noticed the same from pgadmin4.log
AttributeError: 'ServerManager' object has no attribute 'user_info'
2024-01-02 04:59:28,139: ERROR flask.app: 'ServerManager' object has no attribute 'user_info'
Traceback (most recent call last):
File "/usr/pgadmin4/venv/lib/python3.8/site-packages/flask/app.py", line 1813, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/pgadmin4/venv/lib/python3.8/site-packages/flask/app.py", line 1799, in dispatch_request
return self.view_functionsrule.endpoint
File "/usr/pgadmin4/venv/lib/python3.8/site-packages/flask/views.py", line 88, in view
return self.dispatch_request(*args, **kwargs)
File "/usr/pgadmin4/web/pgadmin/browser/utils.py", line 313, in dispatch_request
return method(*args, **kwargs)
File "/usr/pgadmin4/web/pgadmin/browser/server_groups/servers/init.py", line 1457, in connect
'user': manager.user_info,
AttributeError: 'ServerManager' object has no attribute 'user_info'
2024-01-02 04:59:45,055: ERROR flask.app: 'ServerManager' object has no attribute 'user_info'
Traceback (most recent call last):
File "/usr/pgadmin4/venv/lib/python3.8/site-packages/flask/app.py", line 1813, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/pgadmin4/venv/lib/python3.8/site-packages/flask/app.py", line 1799, in dispatch_request
return self.view_functionsrule.endpoint
File "/usr/pgadmin4/venv/lib/python3.8/site-packages/flask/views.py", line 88, in view
return self.dispatch_request(*args, **kwargs)
File "/usr/pgadmin4/web/pgadmin/browser/utils.py", line 313, in dispatch_request
return method(*args, **kwargs)
File "/usr/pgadmin4/web/pgadmin/browser/server_groups/servers/init.py", line 1457, in connect
'user': manager.user_info,
AttributeError: 'ServerManager' object has no attribute 'user_info'

Post that I ran the below command to update PGadmin
sudo apt-get update
sudo apt-get upgrade

Post that I couldn't log in and not getting any error generated in the console nor the CLI in /var/log/pgadmin/pgadmin4.log
In Postgresql log I could see only this error

2024-01-02 05:16:47.355 UTC [22801] FATAL: could not load server certificate file "/etc/letsencrypt/live/xxxxxx/fullchain.pem": Permission denied
2024-01-02 05:16:47.355 UTC [22801] LOG: database system is shut down
pg_ctl: could not start server
Examine the log output.
~

But the above error seems normal to me as I have noticed this before upgrade as well.

[yogeshmahajan-1903]

@shrineanand
Can you please get output of commands below?

sudo apt list pgadmin4*
sudo systemctl status <apache2.service/httpd.service>

As you are using in web mode, can you please get screenshot of the error?

Also, PostgreSQL logs indicates, postgres server is not up and running.

[shrineanand]

@yogeshmahajan-1903
Please find the details below

ubuntu@XXXXX:~$ sudo apt list pgadmin4*
Listing... Done
pgadmin4-desktop/pgadmin4,now 8.1 amd64 [installed,automatic]
pgadmin4-server/pgadmin4,now 8.1 amd64 [installed,automatic]
pgadmin4-web/pgadmin4,now 8.1 all [installed,automatic]
pgadmin4/pgadmin4,now 8.1 all [installed]

ubuntu@ip-xxxxxx~$ sudo systemctl status apache2.service
● apache2.service - The Apache HTTP Server
Loaded: loaded (/lib/systemd/system/apache2.service; enabled; vendor preset: enabled)
Active: active (running) since Wed 2024-01-03 18:19:47 UTC; 4s ago
Docs: https://httpd.apache.org/docs/2.4/
Process: 1263 ExecStart=/usr/sbin/apachectl start (code=exited, status=0/SUCCESS)
Main PID: 1267 (apache2)
Tasks: 83 (limit: 4671)
Memory: 16.8M
CGroup: /system.slice/apache2.service
├─1267 /usr/sbin/apache2 -k start
├─1268 /usr/sbin/apache2 -k start
├─1269 /usr/sbin/apache2 -k start
└─1270 /usr/sbin/apache2 -k start

Jan 03 18:19:47 ip-xxxxx systemd[1]: Starting The Apache HTTP Server...
Jan 03 18:19:47 ip-xxxxx systemd[1]: Started The Apache HTTP Server.

Also I could see 302 error in the POST method

[khushboovashi]

Hi @shrineanand,

Can you please share the pgadmin logs located at /var/log/pgadmin/pgadmin4.log ? Also, try browsing the application in incognito mode.

[yogeshmahajan-1903]

No response from author, hence closing the issue.