Re: installation not working for Ubuntu 21.10 impish - Mailing list pgadmin-support

Doing more research...CAME UP WITH A WORK AROUND!  But I definitely think that pgadmin4 just doesn't work with Ubuntu 21.10 out of the box.  Dave, can you confirm?

TLDR:  Need to install python 3.8 for pgadmin to work with Ubuntu 21.10.  Easiest way to do this is via the deadsnakes ppa and some temporary changing of the main repos to point at bionic.



The problem stems from the symlink being broken.  If I check out the directory housing the python3 symlink that the environment is using...

~$  cd /usr/pgadmin4/venv/bin
/usr/pgadmin4/venv/bin$ ls -l

I see the following 2 symlinks are broken:
lrwxrwxrwx 1 root root    7 Feb  7 11:20 python -> python3
lrwxrwxrwx 1 root root   18 Feb  7 11:20 python3 -> /usr/bin/python3.8

because when I run `$ which python3`, i get back
/usr/bin/python3

Follow this Unix stack exchange post, https://unix.stackexchange.com/questions/151999/how-to-change-where-a-symlink-points, I fix the symlink with the following command while in that same directory:

/usr/pgadmin4/venv/bin$ sudo ln -sf /usr/bin/python3 python3

That seems to fix the symlink issue, but now I get a new error:
*************************
Traceback (most recent call last):
  File "/usr/pgadmin4/web/pgAdmin4.py", line 39, in <module>
    import config
  File "/usr/pgadmin4/web/config.py", line 25, in <module>
    from pgadmin.utils import env, IS_WIN, fs_short_path
  File "/usr/pgadmin4/web/pgadmin/__init__.py", line 23, in <module>
    from flask import Flask, abort, request, current_app, session, url_for
ModuleNotFoundError: No module named 'flask'
*********************

After more digging I realize there seem to be broken symlinks everywhere ( which you can see with $ cd /usr/pgadmin4/venv/lib/python3.8 && ls -l )

So I figure I should try and revert my "fixed" symlink, and install python 3.8 from the deadsnakes ppa.  To do this I'll have to change the deadsnakes url in the sources.list.d directory to target bionic and focal, following https://brennan.io/2021/06/21/deadsnakes-hirsute/  :

  $  cd /usr/pgadmin4/venv/bin && sudo ln -sf /usr/bin/python3.8 python3

  $  sudo add-apt-repository ppa:deadsnakes

  $ sudo vim /etc/apt/sources.list.d/deadsnakes-ubuntu-ppa-impish.list

     ---> change 'deb http://ppa.launchpad.net/deadsnakes/ppa/ubuntu/ impish main'  to 'deb http://ppa.launchpad.net/deadsnakes/ppa/ubuntu/ bionic main'

  $ sudo apt update && sudo apt install python3.8

This almost works, but it looks like I may be entering dependency hell...I get the following message:

*********************
The following packages have unmet dependencies:
 python3.8 : Depends: libpython3.8-stdlib (= 3.8.12-1+bionic3) but it is not installable
E: Unable to correct problems, you have held broken packages.
*********************

So I try adding the bionic universe repo into my main sources.list:
  $ sudo vim /etc/apt/sources.list
      --->  add 'deb http://us.archive.ubuntu.com/ubuntu/ bionic universe' under 'deb http://us.archive.ubuntu.com/ubuntu/ impish universe'

And try again

$ sudo apt update && sudo apt install python3.8

hit with a keyring error: 

****************
W: GPG error: http://us.archive.ubuntu.com/ubuntu bionic InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 3B4FE6ACC0B21F32
E: The repository 'http://us.archive.ubuntu.com/ubuntu bionic InRelease' is not signed.
N: Updating from such a repository can't be done securely, and is therefore disabled by default.
N: See apt-secure(8) manpage for repository creation and user configuration details.
****************

so following https://askubuntu.com/questions/13065/how-do-i-fix-the-gpg-error-no-pubkey  , I add the key
$  sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 3B4FE6ACC0B21F32

and try again....still doesn't work. 

***************
python3.8 : Depends: libpython3.8-stdlib (= 3.8.12-1+bionic3) but it is not installable
*****************

Hail mary, try to temporarily change all my main sources to focal and try again, also delete that bionic line:
$  sudo sed -i 's/impish/focal/g' /etc/apt/sources.list
$  sudo apt update && sudo apt install python3.8

Still gives 

***************
python3.8 : Depends: libpython3.8-stdlib (= 3.8.12-1+bionic3) but it is not installable
*****************

So I try again, but changing everything to bionic:

$  sudo sed -i 's/focal/bionic/g' /etc/apt/sources.list
$  sudo apt update && sudo apt install python3.8

THIS WORKS! Python 3.8 officially installed where pgadmin is expecting it:
$ ls /usr/bin/ | grep python

-->
python3
python3.8
python3.9


and running it works

On Wed, Mar 2, 2022 at 6:55 PM Garrett Simpson <elgaricimo@gmail.com> wrote:

Thanks so much Dave -- silly oversight on my part in retrospect.  Humble request though to add the executable to the PATH upon installation so you get it for free.

Also another question....

when trying to open pgadmin4, I see the window popup, and after waiting a while (seeing "This is taking longer than usual" and "Almost there"),  another box comes up saying  

"The pgAdmin 4 server could not be contacted:"

and it spits out the following environment information... any suggestions?  I made sure postgres was running by doing

$ sudo service postgresql start

and still no luck...

error says 
Failed to launch pgAdmin4. Error:
Error: spawn /usr/pgadmin4/venv/bin/python3 ENOENT

pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "/usr/pgadmin4/venv/bin/python3"
Runtime Config File: "/home/garrett/.config/pgadmin/runtime_config.json"
pgAdmin Config File: "/usr/pgadmin4/web/config.py"
Webapp Path: "/usr/pgadmin4/web/pgAdmin4.py"
pgAdmin Command: "/usr/pgadmin4/venv/bin/python3 -s /usr/pgadmin4/web/pgAdmin4.py"
Environment:
  - GJS_DEBUG_TOPICS: JS ERROR;JS LOG
  - USER: garrett
  - XDG_SESSION_TYPE: wayland
  - SHLVL: 0
  - HOME: /home/garrett
  - DESKTOP_SESSION: ubuntu
  - GIO_LAUNCHED_DESKTOP_FILE: /usr/share/applications/pgadmin4.desktop
  - GTK_MODULES: gail:atk-bridge
  - GNOME_SHELL_SESSION_MODE: ubuntu
  - MANAGERPID: 1860
  - SYSTEMD_EXEC_PID: 2012
  - DBUS_SESSION_BUS_ADDRESS: unix:path=/run/user/1000/bus
  - GIO_LAUNCHED_DESKTOP_FILE_PID: 7732
  - IM_CONFIG_PHASE: 1
  - WAYLAND_DISPLAY: wayland-0
  - LOGNAME: garrett
  - _: /usr/bin/gnome-session
  - JOURNAL_STREAM: 8:35085
  - XDG_SESSION_CLASS: user
  - USERNAME: garrett
  - GNOME_DESKTOP_SESSION_ID: this-is-deprecated
  - PATH: /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/snap/bin
  - SESSION_MANAGER: local/garrett-external:@/tmp/.ICE-unix/1994,unix/garrett-external:/tmp/.ICE-unix/1994
  - INVOCATION_ID: bfafbc8cf87c44b3a86bc5cc8f90c3db
  - XDG_RUNTIME_DIR: /run/user/1000
  - XDG_MENU_PREFIX: gnome-
  - GNOME_SETUP_DISPLAY: :1
  - DISPLAY: :0
  - LANG: en_US.UTF-8
  - XDG_CURRENT_DESKTOP: ubuntu:GNOME
  - XDG_SESSION_DESKTOP: ubuntu
  - XMODIFIERS: @im=ibus
  - XAUTHORITY: /run/user/1000/.mutter-Xwaylandauth.5AZ8H1
  - SSH_AGENT_LAUNCHER: gnome-keyring
  - SSH_AUTH_SOCK: /run/user/1000/keyring/ssh
  - SHELL: /bin/bash
  - QT_ACCESSIBILITY: 1
  - GDMSESSION: ubuntu
  - GJS_DEBUG_OUTPUT: stderr
  - QT_IM_MODULE: ibus
  - PWD: /home/garrett
  - XDG_DATA_DIRS: /usr/share/ubuntu:/usr/local/share/:/usr/share/:/var/lib/snapd/desktop
  - XDG_CONFIG_DIRS: /etc/xdg/xdg-ubuntu:/etc/xdg
  - GDK_BACKEND: x11
  - NO_AT_BRIDGE: 1
  - PGADMIN_INT_PORT: 35873
  - PGADMIN_INT_KEY: d59e0765-b67e-4cb0-b5f1-5c752517b6cc
  - PGADMIN_SERVER_MODE: OFF
--------------------------------------------------------

Failed to launch pgAdmin4. Error:
Error: spawn /usr/pgadmin4/venv/bin/python3 ENOENT

On Wed, Mar 2, 2022 at 11:57 AM Dave Page <dpage@pgadmin.org> wrote:

Hi

On Wed, 2 Mar 2022 at 14:37, Garrett Simpson <elgaricimo@gmail.com> wrote:

Hi there, 

I'd like to report what appears to be a bug in the installation process for pgadmin4 on Ubuntu 21.10 . Below is copy and pasted from my question on askubuntu, https://askubuntu.com/questions/1395499/cant-install-pgadmin4-on-ubuntu-21-10-impish-pgadmin4

I'm running Ubuntu 21.10 impish from an external ssd. Things are working well, trying to install pgadmin4 by following the guide here:

https://www.pgadmin.org/download/pgadmin-4-apt/

namely, adding the extra the PPA , updating the apt repository, and then installing with apt:

# Setup the repository
#

# Install the public key for the repository (if not done previously):
sudo curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add

# Create the repository configuration file:
sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'

#
# Install pgAdmin
#

# Install for both desktop and web modes:
sudo apt install pgadmin4

# Install for desktop mode only:
sudo apt install pgadmin4-desktop

# Install for web mode only: 
sudo apt install pgadmin4-web 

# Configure the webserver, if you installed pgadmin4-web:
sudo /usr/pgadmin4/bin/setup-web.sh

^ note these are the official instructions from pgadmin.org, which says it has support for Ubuntu 21.10 (Impish, from v6.2) (I don't know what the v6.2 means, but whatever)

It appears that everything installs, and then when I try running $ pgadmin4 , nothing happens

I tried manually specifying amd64 architiecture and even switching to the LTS focal endpoint using $ sudo vim /etc/apt/sources.list.d/pgadmin4.list, changing

deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/impish pgadmin4 main

to

deb [arch=amd64] https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/focal pgadmin4 main

Still no joyy....what am I missing here? and Ideally, how would I do it all in an automated script? Setting up a new system, and wrestling with stuff like this is never enjoyable.

If you just run 'pgadmin4', I would expect to see a command not found error, e.g.

dpage@ubuntu:~$ pgadmin4
pgadmin4: command not found

However, the full path should work, e.g.

dpage@ubuntu:~$ /usr/pgadmin4/bin/pgadmin4
[9496:9496:0302/085252.960815:ERROR:sandbox_linux.cc(379)] InitializeSandbox() called with multiple threads in process gpu-process.
[9463:9491:0302/085255.439901:ERROR:chrome_browser_main_extra_parts_metrics.cc(227)] START: ReportBluetoothAvailability(). If you don't see the END: message, this is crbug.com/1216328.
[9463:9491:0302/085255.440023:ERROR:chrome_browser_main_extra_parts_metrics.cc(230)] END: ReportBluetoothAvailability()
[9497:9509:0302/085258.416653:ERROR:cert_verify_proc_builtin.cc(603)] No net_fetcher for performing AIA chasing.
[9497:9514:0302/085300.895407:ERROR:cert_verify_proc_builtin.cc(603)] No net_fetcher for performing AIA chasing.
[9497:9514:0302/085332.999213:ERROR:cert_verify_proc_builtin.cc(603)] No net_fetcher for performing AIA chasing.
[9497:9514:0302/085353.520635:ERROR:cert_verify_proc_builtin.cc(603)] No net_fetcher for performing AIA chasing.

Those errors can be ignored - they're garbage the Chrome engine spits out that are merely annoying. You should see the pgAdmin window open at this point.

You can also run pgAdmin from the Wayland menu. Just type pgadmin in the search box if the icon doesn't show up immediately.

FYI, the testing above was done on a fresh installation of Ubuntu 21.10.

--

Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: https://www.enterprisedb.com