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

From Garrett Simpson
Subject Re: installation not working for Ubuntu 21.10 impish
Date
Msg-id CAAa3A6GXcGWufOJhf=5JRdgWvVAMK3dpdO_MMvyzqba6SSk5tQ@mail.gmail.com
Whole thread Raw
In response to Re: installation not working for Ubuntu 21.10 impish  (Dave Page <dpage@pgadmin.org>)
Responses Re: installation not working for Ubuntu 21.10 impish  (Garrett Simpson <elgaricimo@gmail.com>)
List pgadmin-support
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.

--

pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: installation not working for Ubuntu 21.10 impish
Next
From: Garrett Simpson
Date:
Subject: Re: installation not working for Ubuntu 21.10 impish