Questions[pgadmin](ubuntu)

pgadmin4 is running perfectly before the system update of ubuntu 16.04 I didn't actually check what are those updates.

But after the update and I tried running pgAdmin, it boots up and shows the pgAdmin loading screen. Then it loads for a long while and eventually gives me the error:

The application server could not be contacted.

I checked the pgAdmin4 logs and it gives me:

AttributeError: 'Request' object has no attribute 'is_json'
2020-05-18 16:08:46,684: ERROR  pgadmin:  'Request' object has no attribute 'is_json'
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/flask/app.py", line 1473, in full_dispatch_request
    rv = self.preprocess_request()
  File "/usr/lib/python3/dist-packages/flask/app.py", line 1666, in preprocess_request
    rv = func()
  File "/usr/lib/python3/dist-packages/flask_principal.py", line 477, in _on_before_request
    identity = loader()
  File "/usr/lib/python3/dist-packages/flask_security/core.py", line 515, in _identity_loader
    if not isinstance(current_user._get_current_object(), AnonymousUserMixin):
  File "/usr/lib/python3/dist-packages/werkzeug/local.py", line 307, in _get_current_object
    return self.__local()
  File "/usr/lib/python3/dist-packages/flask_login/utils.py", line 26, in <lambda>
    current_user = LocalProxy(lambda: _get_user())
  File "/usr/lib/python3/dist-packages/flask_login/utils.py", line 302, in _get_user
    current_app.login_manager._load_user()
  File "/usr/lib/python3/dist-packages/flask_login/login_manager.py", line 313, in _load_user
    return self._load_from_request(request)
  File "/usr/lib/python3/dist-packages/flask_login/login_manager.py", line 370, in _load_from_request
    user = self.request_callback(request)
  File "/usr/lib/python3/dist-packages/flask_security/core.py", line 475, in _request_loader
    if request.is_json:
  File "/usr/lib/python3/dist-packages/werkzeug/local.py", line 348, in __getattr__
    return getattr(self._get_current_object(), name)
AttributeError: 'Request' object has no attribute 'is_json'

I already tried searching for it, but I am not a python guy. My guess is python version incompatibility. I saw a previous question about this 4 days ago. And it was deleted. I am not sure why.

Note: There is no config changes or anything.

EDIT (thanks to @Des Magner comment): This bug is already being tracked by PostgreSQL team https://redmine.postgresql.org/issues/5565

Basically, follow the steps as outlined here: https://wiki.postgresql.org/wiki/Apt.

1. sudo apt-get install curl ca-certificates gnupg
2. curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
3. sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
4. sudo apt-get update
5. sudo apt-get install pgadmin4

(The actual command for the last step includes postgresql-11. I never do that because I just want pgadmin4 and have never had issues with it working properly.)

Anyway, this is what happens when trying to install:

Reading package lists... Done
Building dependency tree       
Reading state information... Done
Package pgadmin4 is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source

E: Package 'pgadmin4' has no installation candidate

I've redone the steps with the same result.

I did also try to do the following, but it requires python3.7 which I'm not going to install.

sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt eoan-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

Verified focal shows up at apt.postgresql.org:

Kind of stumped after that as to what to do.

Suggestions?

When starting pgAdmin, I'm prompted:

Please set a master password for pgAdmin

This is a new feature of pgAdmin4 4.7: https://www.pgadmin.org/docs/pgadmin4/dev/release_notes_4_7.html

How can I disable this?

The local documentation tells me to set the "configuration parameter" MASTER_PASSWORD_REQUIRED=False, but I don't know where/how to do this: http://127.0.0.1:37059/help/help/master_password.html

I'm getting this error on startup of pgAdmin4 on Kubuntu 18.04:

An error occurred initialising the application server:
Failed to launch the application server, server thread exiting.

In the following window ("Configuration") I have these default values:

Python Path:
/usr/pgadmin4/lib/python2.7;/usr/pgadmin4/lib/python2.7/site-packages
Application Path:
/usr/pgadmin4/web

Since I don't have a /usr/pgadmin4/ directory, all of them are wrong.

See https://stackoverflow.com/questions/43968302/failed-to-launch-application-server-server-thread-existing-on-windows for the same error on Windows

Lately, pgAdmin would automatically launch on boot. I'm using KDE, and there is no entry for pgAdmin in Autostart, nor was there any in ~/.config/autostart (tho' I'm guessing Autostart uses the file from there anyway).