Re: installation not working for Ubuntu 21.10 impish

Hi Dave,
Appreciate the quick response!
Definitely have Impish...

garrett(at)garrett-external:/etc$ lsb_release -cd
Description: Ubuntu 21.10
Codename: impish

garrett(at)garrett-external:/etc$ lsb_release -cs
impish

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

garrett(at)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(at)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(at)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(at)garrett-external:/etc/apt/sources.list.d$ ls
deadsnakes-ubuntu-ppa-impish.list pgadmin4.list pgadmin4.list.save
pgdg.list pgdg.list.save
garrett(at)garrett-external:/etc/apt/sources.list.d$ sudo rm
pgadmin4.list.save

double check that the pgadmin4 sources are correct...
garrett(at)garrett-external:/etc/apt/sources.list.d$ ls
deadsnakes-ubuntu-ppa-impish.list pgadmin4.list pgdg.list
pgdg.list.save
garrett(at)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(at)garrett-external:/etc/apt/sources.list.d$ sudo sed -i
's/focal/impish/g' ./pgadmin4.list
garrett(at)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(at)garrett-external:/etc/apt/sources.list.d$ sudo apt purge pgadmin4
garrett(at)garrett-external:/etc/apt/sources.list.d$ sudo apt autoremove

reinstall pgadmin4
garrett(at)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(at)pgadmin(dot)org> wrote:

> Hi
>
> On Thu, 3 Mar 2022 at 05:22, 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?
>>
>
> 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(at)ubuntu:~$ grep PRETTY_NAME /etc/os-release
> PRETTY_NAME="Ubuntu 21.10"
> dpage(at)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(at)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
>
>
> --
> Dave Page
> Blog: https://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EDB: https://www.enterprisedb.com
>
>