Postgres Pro
Downloads
Home   >   mailing lists

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 CAAa3A6E3w6Oxsq3-cTpWpo2WMXSZFM1+7-emjrqu7gZT4FnbFQ@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
List pgadmin-support
Tree view
Hi Dave,
Appreciate the quick response!
Definitely have Impish...

garrett@garrett-external:/etc$ lsb_release -cd
Description: Ubuntu 21.10
Codename: impish

garrett@garrett-external:/etc$ lsb_release -cs
impish

But for some reason I don't have  the os-release directory:

garrett@garrett-external:/etc$ cd /etc/os-release
bash: cd: /etc/os-release: Not a directory


I think what probably happened is when I was initially stuck, and trying to run pgadmin4 from the terminal, not seeing anything happen, and thinking it was not fully installed when it was, I started monkeying around with the urls in /etc/apt/sources.list.d to try uninstalling and reinstalling past releases, following a bit too blindly things I found searching online...

garrett@garrett-external:/etc/apt/sources.list.d$ ls
deadsnakes-ubuntu-ppa-impish.list  pgadmin4.list.save  pgdg.list.save
pgadmin4.list                      pgdg.list


Looking at pgadmin4.list.save , I see I had at least tried to use hirsute 's repo:

garrett@garrett-external:/etc/apt/sources.list.d$ cat pgadmin4.list.save
    deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/hirsute pgadmin4 main

I'm thinking this is overriding the correct impish repos, so I'll try deleting that file, purging the installation and re-installing:

garrett@garrett-external:/etc/apt/sources.list.d$ ls
    deadsnakes-ubuntu-ppa-impish.list  pgadmin4.list  pgadmin4.list.save  pgdg.list  pgdg.list.save
garrett@garrett-external:/etc/apt/sources.list.d$ sudo rm pgadmin4.list.save

double check that the pgadmin4 sources are correct...
garrett@garrett-external:/etc/apt/sources.list.d$ ls
    deadsnakes-ubuntu-ppa-impish.list  pgadmin4.list  pgdg.list  pgdg.list.save
garrett@garrett-external:/etc/apt/sources.list.d$ cat pgadmin4.list
  deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/focal pgadmin4 main

^ok definitely the problem...should fix that....

garrett@garrett-external:/etc/apt/sources.list.d$ sudo sed -i 's/focal/impish/g' ./pgadmin4.list
garrett@garrett-external:/etc/apt/sources.list.d$ cat ./pgadmin4.list
  deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/impish pgadmin4 main

uninstall pgadmin4
garrett@garrett-external:/etc/apt/sources.list.d$ sudo apt purge pgadmin4
garrett@garrett-external:/etc/apt/sources.list.d$ sudo apt autoremove

reinstall pgadmin4
garrett@garrett-external:/etc/apt/sources.list.d$ sudo apt update && sudo apt install pgadmin4

And now it works fine

So you were right, apologies for the self inflicted goose chase -- but definitely learned a lot in the process!



On Thu, Mar 3, 2022 at 4:45 AM Dave Page <dpage@pgadmin.org> wrote:
Hi

On Thu, 3 Mar 2022 at 05:22, Garrett Simpson <elgaricimo@gmail.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?

No, I can't. The test I did yesterday was on a brand new, fresh installation of Ubuntu 21.10. I installed it, logged in, and then copied the commands straight from your email and it worked perfectly.
 

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.

Except that pgAdmin builds for Ubuntu 21.10 are built against Python 3.9, the default for Impish:

dpage@ubuntu:~$ grep PRETTY_NAME /etc/os-release
PRETTY_NAME="Ubuntu 21.10"
dpage@ubuntu:~$ /usr/pgadmin4/venv/bin/python3 --version
Python 3.9.7
 
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

Yet I see:

dpage@ubuntu:/usr/pgadmin4/venv/bin$ ls -l
total 84
-rw-r--r-- 1 root root 1893 Feb  7 08:12 activate
-rw-r--r-- 1 root root  842 Feb  7 08:12 activate.csh
-rw-r--r-- 1 root root 1982 Feb  7 08:12 activate.fish
-rw-r--r-- 1 root root 8834 Feb  7 08:12 Activate.ps1
-rwxrwxr-x 1 root root  227 Feb  7 08:12 alembic
-rwxrwxr-x 1 root root  235 Feb  7 08:12 chardetect
-rwxrwxr-x 1 root root  244 Feb  7 08:12 easy_install
-rwxrwxr-x 1 root root  244 Feb  7 08:12 easy_install-3.9
-rwxrwxr-x 1 root root  228 Feb  7 08:12 email_validator
-rwxrwxr-x 1 root root  222 Feb  7 08:12 flask
-rwxrwxr-x 1 root root  227 Feb  7 08:12 mako-render
-rwxrwxr-x 1 root root  235 Feb  7 08:12 pip
-rwxrwxr-x 1 root root  235 Feb  7 08:12 pip3
-rwxrwxr-x 1 root root  235 Feb  7 08:12 pip3.9
-rwxrwxr-x 1 root root  236 Feb  7 08:12 pybabel
lrwxrwxrwx 1 root root    7 Feb  7 08:20 python -> python3
lrwxrwxrwx 1 root root   18 Feb  7 08:20 python3 -> /usr/bin/python3.9
lrwxrwxrwx 1 root root    7 Feb  7 08:20 python3.9 -> python3
-rwxrwxr-x 1 root root  235 Feb  7 08:12 qr
-rwxrwxr-x 1 root root  230 Feb  7 08:12 sqlformat
-rwxrwxr-x 1 root root  232 Feb  7 08:12 sshtunnel
-rwxrwxr-x 1 root root  222 Feb  7 08:12 wheel

It seems pretty clear to me that you've somehow installed a build of pgAdmin for an older version of Ubuntu, one which uses Python 3.8. Based on what we currently support, that can only be Ubuntu 20.04 as that's the only Ubuntu or Debian build that uses Python 3.8.

What is in /etc/os-release on your system, and what is the output of the command:

lsb_release -cs


--

pgadmin-support by date:

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