Re: installation not working for Ubuntu 21.10 impish

summarized my approach here:
https://askubuntu.com/questions/1370092/the-pgadmin-4-server-could-not-be-contacted-error

On Thu, Mar 3, 2022 at 12:22 AM Garrett Simpson <elgaricimo(at)gmail(dot)com>
wrote:

> 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(at)gmail(dot)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(at)pgadmin(dot)org> wrote:
>>
>>> Hi
>>>
>>> On Wed, 2 Mar 2022 at 14:37, Garrett Simpson <elgaricimo(at)gmail(dot)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(at)ubuntu:~$ pgadmin4
>>> pgadmin4: command not found
>>>
>>> However, the full path should work, e.g.
>>>
>>> dpage(at)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
>>>
>>>