Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

pgadmin4 not working after upgrade to Ubuntu 24.04 Noble #7437

Open
sanjayminni opened this issue Apr 26, 2024 · 41 comments
Open

pgadmin4 not working after upgrade to Ubuntu 24.04 Noble #7437

sanjayminni opened this issue Apr 26, 2024 · 41 comments

Comments

@sanjayminni
Copy link

After upgrade to Ubuntu 24.04 Noble the existing installation has stopped working and is throwing error below:

pgAdmin Runtime Environment

Python Path: "/usr/pgadmin4/venv/bin/python3"
Runtime Config File: "/home/xxx/.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:

  • HOME: /home/xxx
  • LANG: en_GB.UTF-8
  • LC_ADDRESS: en_IN.UTF-8
  • LC_IDENTIFICATION: en_IN.UTF-8
  • LC_MEASUREMENT: en_IN.UTF-8
  • LC_MONETARY: en_IN.UTF-8
  • LC_NAME: en_IN.UTF-8
  • LC_NUMERIC: en_IN.UTF-8
  • LC_PAPER: en_IN.UTF-8
  • LC_TELEPHONE: en_IN.UTF-8
  • LC_TIME: en_IN.UTF-8
  • LOGNAME: xxx
  • PATH: xxx
  • SHELL: /bin/bash
  • USER: xxx
  • XDG_RUNTIME_DIR: /run/user/1000
  • GTK_MODULES: gail:atk-bridge
  • QT_ACCESSIBILITY: 1
  • XDG_DATA_DIRS: /usr/share/ubuntu:/usr/share/gnome:/usr/local/share/:/usr/share/:/var/lib/snapd/desktop
  • DBUS_SESSION_BUS_ADDRESS: unix:path=/run/user/1000/bus
  • DEBUGINFOD_URLS: https://debuginfod.ubuntu.com
  • DESKTOP_SESSION: ubuntu
  • GDMSESSION: ubuntu
  • GNOME_DESKTOP_SESSION_ID: this-is-deprecated
  • GNOME_SHELL_SESSION_MODE: ubuntu
  • GSM_SKIP_SSH_AGENT_WORKAROUND: true
  • IM_CONFIG_PHASE: 1
  • LANGUAGE: en_GB:en
  • LIBVIRT_DEFAULT_URI: qemu:///system
  • PAPERSIZE: a4
  • PWD: /home/xx
  • QT_IM_MODULE: ibus
  • SESSION_MANAGER: local/xxxxxxx:@/tmp/.ICE-unix/1585,unix/xxxxxxx:/tmp/.ICE-unix/1585
  • SHLVL: 0
  • SSH_AUTH_SOCK: /run/user/1000/keyring/ssh
  • USERNAME: xx
  • XDG_CONFIG_DIRS: /etc/xdg/xdg-ubuntu:/etc/xdg
  • XDG_CURRENT_DESKTOP: ubuntu:GNOME
  • XDG_MENU_PREFIX: gnome-
  • XDG_SESSION_CLASS: user
  • XDG_SESSION_DESKTOP: ubuntu
  • XDG_SESSION_TYPE: wayland
  • XMODIFIERS: @im=ibus
  • _: /usr/bin/gnome-session
  • MANAGERPID: 1357
  • INVOCATION_ID: 453a3ffc985a457291e377c28aec5b81
  • JOURNAL_STREAM: 8:14840
  • SYSTEMD_EXEC_PID: 1625
  • MEMORY_PRESSURE_WATCH: /sys/fs/cgroup/user.slice/user-1000.slice/user@1000.service/session.slice/org.gnome.Shell@wayland.service/memory.pressure
  • MEMORY_PRESSURE_WRITE: c29tZSAyMDAwMDAgMjAwMDAwMAA=
  • GJS_DEBUG_OUTPUT: stderr
  • GJS_DEBUG_TOPICS: JS ERROR;JS LOG
  • GNOME_SETUP_DISPLAY: :1
  • DISPLAY: :0
  • XAUTHORITY: /run/user/1000/.mutter-Xwaylandauth.Y5NFM2
  • WAYLAND_DISPLAY: wayland-0
  • GIO_LAUNCHED_DESKTOP_FILE: /usr/share/applications/pgadmin4.desktop
  • GIO_LAUNCHED_DESKTOP_FILE_PID: 15250
  • GDK_BACKEND: x11
  • NO_AT_BRIDGE: 1
  • PGADMIN_INT_PORT: 36893
  • PGADMIN_INT_KEY: 61652ca5-4788-4855-b84c-879a28f99ebb
  • PGADMIN_SERVER_MODE: OFF

Total spawn time to start the pgAdmin4 server: 0.021 Sec
Failed to launch pgAdmin4. Error:
Error: spawn /usr/pgadmin4/venv/bin/python3 ENOENT

@RuizSenior
Copy link

same

@abdur8312
Copy link

abdur8312 commented Apr 27, 2024

For me also. I upgraded from 23.10 to 22.04 today. when i try to install pgadmin4, it was not at all installing.

Update : It's 24.04 not 22.04. My mistake

@KostyanM
Copy link

KostyanM commented Apr 27, 2024

I`ve get 'The repository 'https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/noble pgadmin4 Release' does not have a Release file.'

UPD: Install Dbeaver.

@jasonsemko
Copy link

Echoing this. I do see on the downloads that 24 is not yet listed for support. Any indication when it will be supported? Thanks

@fuattatar
Copy link

Same issue on ubuntu 24.04

pgAdmin Runtime Environment

Python Path: "/usr/pgadmin4/venv/bin/python3"
Runtime Config File: "/home/fuat/.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:

  • HOME: /home/fuat
  • LANG: tr_TR.UTF-8
  • LOGNAME: fuat
  • PATH: /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/snap/bin
  • SHELL: /bin/bash
  • USER: fuat
  • XDG_RUNTIME_DIR: /run/user/1000
  • GTK_MODULES: gail:atk-bridge
  • QT_ACCESSIBILITY: 1
  • XDG_DATA_DIRS: /usr/share/ubuntu:/usr/share/gnome:/usr/local/share/:/usr/share/:/var/lib/snapd/desktop
  • DBUS_SESSION_BUS_ADDRESS: unix:path=/run/user/1000/bus
  • DEBUGINFOD_URLS: https://debuginfod.ubuntu.com
  • DESKTOP_SESSION: ubuntu
  • GDMSESSION: ubuntu
  • GNOME_DESKTOP_SESSION_ID: this-is-deprecated
  • GNOME_SHELL_SESSION_MODE: ubuntu
  • GSM_SKIP_SSH_AGENT_WORKAROUND: true
  • IM_CONFIG_PHASE: 1
  • PWD: /home/fuat
  • QT_IM_MODULE: ibus
  • SESSION_MANAGER: local/fuat-IdeaPad-1-15ALC7:@/tmp/.ICE-unix/1973,unix/fuat-IdeaPad-1-15ALC7:/tmp/.ICE-unix/1973
  • SHLVL: 0
  • SSH_AUTH_SOCK: /run/user/1000/keyring/ssh
  • USERNAME: fuat
  • XDG_CONFIG_DIRS: /etc/xdg/xdg-ubuntu:/etc/xdg
  • XDG_CURRENT_DESKTOP: ubuntu:GNOME
  • XDG_MENU_PREFIX: gnome-
  • XDG_SESSION_CLASS: user
  • XDG_SESSION_DESKTOP: ubuntu
  • XDG_SESSION_TYPE: wayland
  • XMODIFIERS: @im=ibus
  • _: /usr/bin/gnome-session
  • MANAGERPID: 1750
  • INVOCATION_ID: b0bf3880a1d94a78a676bc4c5a998521
  • JOURNAL_STREAM: 8:16319
  • SYSTEMD_EXEC_PID: 2016
  • MEMORY_PRESSURE_WATCH: /sys/fs/cgroup/user.slice/user-1000.slice/user@1000.service/session.slice/org.gnome.Shell@wayland.service/memory.pressure
  • MEMORY_PRESSURE_WRITE: c29tZSAyMDAwMDAgMjAwMDAwMAA=
  • GJS_DEBUG_OUTPUT: stderr
  • GJS_DEBUG_TOPICS: JS ERROR;JS LOG
  • GNOME_SETUP_DISPLAY: :1
  • DISPLAY: :0
  • XAUTHORITY: /run/user/1000/.mutter-Xwaylandauth.SAURM2
  • WAYLAND_DISPLAY: wayland-0
  • GIO_LAUNCHED_DESKTOP_FILE: /usr/share/applications/pgadmin4.desktop
  • GIO_LAUNCHED_DESKTOP_FILE_PID: 23283
  • GDK_BACKEND: x11
  • NO_AT_BRIDGE: 1
  • PGADMIN_INT_PORT: 42773
  • PGADMIN_INT_KEY: 6fc6b587-4913-4160-9630-ce71d685b18c
  • PGADMIN_SERVER_MODE: OFF

Total spawn time to start the pgAdmin4 server: 0.008 Sec
Failed to launch pgAdmin4. Error:
Error: spawn /usr/pgadmin4/venv/bin/python3 ENOENT

@avinasx
Copy link

avinasx commented Apr 28, 2024

any update on support to ubuntu 24.04?

@sapachecon
Copy link

Same thing, I just installed Ubuntu 24.04 and I can't find how to install pgadmin4!!...Would it have been a good idea to install Ubuntu 24.04?

@adityatoshniwal
Copy link
Contributor

HI @sanjayminni,
Please share the output of ls -l /usr/pgadmin4/venv/bin/python3

@sanjayminni
Copy link
Author

Hi @adityatoshniwal
output is
lrwxrwxrwx 1 root root 19 Apr 1 17:21 /usr/pgadmin4/venv/bin/python3 -> /usr/bin/python3.11

HI @sanjayminni, Please share the output of ls -l /usr/pgadmin4/venv/bin/python3

@adityatoshniwal
Copy link
Contributor

Hi @adityatoshniwal output is lrwxrwxrwx 1 root root 19 Apr 1 17:21 /usr/pgadmin4/venv/bin/python3 -> /usr/bin/python3.11

HI @sanjayminni, Please share the output of ls -l /usr/pgadmin4/venv/bin/python3

And is the /usr/bin/python3.11 present? I'm suspecting the symlink is broken after upgrade. Please give the output for ls -l /usr/bin/python*

@adityatoshniwal
Copy link
Contributor

Ubuntu Noble is not yet supported by pgAdmin. So this is a feature and not a bug. One can check the supported versions here - https://www.pgadmin.org/download/pgadmin-4-apt/

@sanjayminni
Copy link
Author

Hi @adityatoshniwal output is lrwxrwxrwx 1 root root 19 Apr 1 17:21 /usr/pgadmin4/venv/bin/python3 -> /usr/bin/python3.11

HI @sanjayminni, Please share the output of ls -l /usr/pgadmin4/venv/bin/python3

And is the /usr/bin/python3.11 present? I'm suspecting the symlink is broken after upgrade. Please give the output for ls -l /usr/bin/python*

@adityatoshniwal
Here is the output:
lrwxrwxrwx 1 root root 10 Apr 12 18:59 /usr/bin/python3 -> python3.12
-rwxr-xr-x 1 root root 8019136 Apr 10 11:03 /usr/bin/python3.12
(Ok seems python 3.11 has been upgraded to python 3.12)

@adityatoshniwal
Copy link
Contributor

@sanjayminni,
run the following commands and then try:

rm -f /usr/pgadmin4/venv/bin/python3
ln -s /usr/bin/python3 /usr/pgadmin4/venv/bin/python3

@sanjayminni
Copy link
Author

@adityatoshniwal

Ubuntu Noble is not yet supported by pgAdmin. So this is a feature and not a bug. One can check the supported versions here - https://www.pgadmin.org/download/pgadmin-4-apt/

I do wish pgAdmin would not be so tied to OS release - IIRC pgadmin broke down on the previous 2 Ubuntu releases also and the mantic fix took a while.
Its a catch-22 situation between installing an OS release upgrade only if pgadmin supports the os and knowing if pgadmin4 works on the release - ... or other way is to wait till pgadmin lists the OS version as supported.

@sanjayminni
Copy link
Author

@sanjayminni, run the following commands and then try:

rm -f /usr/pgadmin4/venv/bin/python3
ln -s /usr/bin/python3 /usr/pgadmin4/venv/bin/python3

Nope I get
The pgAdmin 4 server could not be contacted:

pgAdmin Runtime Environment

Python Path: "/usr/pgadmin4/venv/bin/python3"
Runtime Config File: "/home/sm/.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:

  • HOME: /home/sm
  • LANG: en_GB.UTF-8
  • LC_ADDRESS: en_IN.UTF-8
  • LC_IDENTIFICATION: en_IN.UTF-8
  • LC_MEASUREMENT: en_IN.UTF-8
  • LC_MONETARY: en_IN.UTF-8
  • LC_NAME: en_IN.UTF-8
  • LC_NUMERIC: en_IN.UTF-8
  • LC_PAPER: en_IN.UTF-8
  • LC_TELEPHONE: en_IN.UTF-8
  • LC_TIME: en_IN.UTF-8
  • LOGNAME: sm
  • PATH: /home/sm/.local/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/snap/bin
  • SHELL: /bin/bash
  • USER: sm
  • XDG_RUNTIME_DIR: /run/user/1000
  • GTK_MODULES: gail:atk-bridge
  • QT_ACCESSIBILITY: 1
  • XDG_DATA_DIRS: /usr/share/ubuntu:/usr/share/gnome:/usr/local/share/:/usr/share/:/var/lib/snapd/desktop
  • DBUS_SESSION_BUS_ADDRESS: unix:path=/run/user/1000/bus
  • DEBUGINFOD_URLS: https://debuginfod.ubuntu.com
  • DESKTOP_SESSION: ubuntu
  • GDMSESSION: ubuntu
  • GNOME_DESKTOP_SESSION_ID: this-is-deprecated
  • GNOME_SHELL_SESSION_MODE: ubuntu
  • GSM_SKIP_SSH_AGENT_WORKAROUND: true
  • IM_CONFIG_PHASE: 1
  • LANGUAGE: en_GB:en
  • LIBVIRT_DEFAULT_URI: qemu:///system
  • PAPERSIZE: a4
  • PWD: /home/sm
  • QT_IM_MODULE: ibus
  • SESSION_MANAGER: local/smDD1u:@/tmp/.ICE-unix/1668,unix/smDD1u:/tmp/.ICE-unix/1668
  • SHLVL: 0
  • SSH_AUTH_SOCK: /run/user/1000/keyring/ssh
  • USERNAME: sm
  • XDG_CONFIG_DIRS: /etc/xdg/xdg-ubuntu:/etc/xdg
  • XDG_CURRENT_DESKTOP: ubuntu:GNOME
  • XDG_MENU_PREFIX: gnome-
  • XDG_SESSION_CLASS: user
  • XDG_SESSION_DESKTOP: ubuntu
  • XDG_SESSION_TYPE: wayland
  • XMODIFIERS: @im=ibus
  • _: /usr/bin/gnome-session
  • MANAGERPID: 1444
  • INVOCATION_ID: 776f13cc4714413d8c20274f11156d64
  • JOURNAL_STREAM: 8:14221
  • SYSTEMD_EXEC_PID: 1701
  • MEMORY_PRESSURE_WATCH: /sys/fs/cgroup/user.slice/user-1000.slice/user@1000.service/session.slice/org.gnome.Shell@wayland.service/memory.pressure
  • MEMORY_PRESSURE_WRITE: c29tZSAyMDAwMDAgMjAwMDAwMAA=
  • GJS_DEBUG_OUTPUT: stderr
  • GJS_DEBUG_TOPICS: JS ERROR;JS LOG
  • GNOME_SETUP_DISPLAY: :1
  • DISPLAY: :0
  • XAUTHORITY: /run/user/1000/.mutter-Xwaylandauth.D89UM2
  • WAYLAND_DISPLAY: wayland-0
  • GIO_LAUNCHED_DESKTOP_FILE: /usr/share/applications/pgadmin4.desktop
  • GIO_LAUNCHED_DESKTOP_FILE_PID: 7842
  • GDK_BACKEND: x11
  • NO_AT_BRIDGE: 1
  • PGADMIN_INT_PORT: 37199
  • PGADMIN_INT_KEY: 6d336b07-ca1d-40e8-9eec-00df7165ea70
  • PGADMIN_SERVER_MODE: OFF

Total spawn time to start the pgAdmin4 server: 0.02 Sec
Traceback (most recent call last):
File "/usr/pgadmin4/web/pgAdmin4.py", line 48, in

import config

File "/usr/pgadmin4/web/config.py", line 33, in
from pgadmin.utils import env, IS_WIN, fs_short_path
File "/usr/pgadmin4/web/pgadmin/init.py", line 24, in
from flask import Flask, abort, request, current_app, session, url_for
ModuleNotFoundError: No module named 'flask'

@adityatoshniwal
Copy link
Contributor

adityatoshniwal commented Apr 29, 2024

@adityatoshniwal

Ubuntu Noble is not yet supported by pgAdmin. So this is a feature and not a bug. One can check the supported versions here - https://www.pgadmin.org/download/pgadmin-4-apt/

I do wish pgAdmin would not be so tied to OS release - IIRC pgadmin broke down on the previous 2 Ubuntu releases also and the mantic fix took a while. Its a catch-22 situation between installing an OS release upgrade only if pgadmin supports the os and knowing if pgadmin4 works on the release - ... or other way is to wait till pgadmin lists the OS version as supported.

There's a lot of effort involved in supporting one OS version as we need to make changes in build machines and also test the release builds (which may require changes in code as well if things doesn't work). What we need to do better is to be aware of next major release date so we can plan things accordingly.

@sanjayminni
Copy link
Author

I do understand and appreciate the effort and complexity involved. I am using quite a few tools which seem to work across.

anyway any idea by when this may get working or a workaround suggested
thanks

@adityatoshniwal
Copy link
Contributor

I do understand and appreciate the effort and complexity involved. I am using quite a few tools which seem to work across.

anyway any idea by when this may get working or a workaround suggested thanks

I have raised a bug here - #7439. We'll test the upgrade scenario at our end.

@yogeshmahajan-1903
Copy link
Contributor

@sanjayminni

WA is to install python version 3.11.

sudo add-apt-repository ppa:deadsnakes/ppa
sudo apt update
sudo apt install python3.11

After this pgAdmin will be working.
If you have still issue then, check symlink for venv as below

$ ls -l /usr/pgadmin4/venv/bin/python3
lrwxrwxrwx 1 root root 19 Apr  1 17:21 /usr/pgadmin4/venv/bin/python3 -> /usr/bin/python3.11
$

To correct the symlinks run

ln -s /usr/bin/python3.11 /usr/pgadmin4/venv/bin/python3

@sanjayminni
Copy link
Author

sanjayminni commented Apr 30, 2024

worked thanks

note on line
ln -s /usr/bin/python3.11 /usr/pgadmin4/venv/bin/python3
i got the error message
ln: failed to create symbolic link '/usr/pgadmin4/venv/bin/python3': File exists
so i deleted the file
sudo rm /usr/pgadmin4/venv/bin/python3
and then reran
it worked

@Hanzala47
Copy link

Hanzala47 commented Apr 30, 2024

After upgrade to Ubuntu 24.04 Noble the existing installation has stopped working and is throwing error below:

pgAdmin Runtime Environment

Python Path: "/usr/pgadmin4/venv/bin/python3" Runtime Config File: "/home/xxx/.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:

  • HOME: /home/xxx
  • LANG: en_GB.UTF-8
  • LC_ADDRESS: en_IN.UTF-8
  • LC_IDENTIFICATION: en_IN.UTF-8
  • LC_MEASUREMENT: en_IN.UTF-8
  • LC_MONETARY: en_IN.UTF-8
  • LC_NAME: en_IN.UTF-8
  • LC_NUMERIC: en_IN.UTF-8
  • LC_PAPER: en_IN.UTF-8
  • LC_TELEPHONE: en_IN.UTF-8
  • LC_TIME: en_IN.UTF-8
  • LOGNAME: xxx
  • PATH: xxx
  • SHELL: /bin/bash
  • USER: xxx
  • XDG_RUNTIME_DIR: /run/user/1000
  • GTK_MODULES: gail:atk-bridge
  • QT_ACCESSIBILITY: 1
  • XDG_DATA_DIRS: /usr/share/ubuntu:/usr/share/gnome:/usr/local/share/:/usr/share/:/var/lib/snapd/desktop
  • DBUS_SESSION_BUS_ADDRESS: unix:path=/run/user/1000/bus
  • DEBUGINFOD_URLS: https://debuginfod.ubuntu.com
  • DESKTOP_SESSION: ubuntu
  • GDMSESSION: ubuntu
  • GNOME_DESKTOP_SESSION_ID: this-is-deprecated
  • GNOME_SHELL_SESSION_MODE: ubuntu
  • GSM_SKIP_SSH_AGENT_WORKAROUND: true
  • IM_CONFIG_PHASE: 1
  • LANGUAGE: en_GB:en
  • LIBVIRT_DEFAULT_URI: qemu:///system
  • PAPERSIZE: a4
  • PWD: /home/xx
  • QT_IM_MODULE: ibus
  • SESSION_MANAGER: local/xxxxxxx:@/tmp/.ICE-unix/1585,unix/xxxxxxx:/tmp/.ICE-unix/1585
  • SHLVL: 0
  • SSH_AUTH_SOCK: /run/user/1000/keyring/ssh
  • USERNAME: xx
  • XDG_CONFIG_DIRS: /etc/xdg/xdg-ubuntu:/etc/xdg
  • XDG_CURRENT_DESKTOP: ubuntu:GNOME
  • XDG_MENU_PREFIX: gnome-
  • XDG_SESSION_CLASS: user
  • XDG_SESSION_DESKTOP: ubuntu
  • XDG_SESSION_TYPE: wayland
  • XMODIFIERS: @im=ibus
  • _: /usr/bin/gnome-session
  • MANAGERPID: 1357
  • INVOCATION_ID: 453a3ffc985a457291e377c28aec5b81
  • JOURNAL_STREAM: 8:14840
  • SYSTEMD_EXEC_PID: 1625
  • MEMORY_PRESSURE_WATCH: /sys/fs/cgroup/user.slice/user-1000.slice/user@1000.service/session.slice/org.gnome.Shell@wayland.service/memory.pressure
  • MEMORY_PRESSURE_WRITE: c29tZSAyMDAwMDAgMjAwMDAwMAA=
  • GJS_DEBUG_OUTPUT: stderr
  • GJS_DEBUG_TOPICS: JS ERROR;JS LOG
  • GNOME_SETUP_DISPLAY: :1
  • DISPLAY: :0
  • XAUTHORITY: /run/user/1000/.mutter-Xwaylandauth.Y5NFM2
  • WAYLAND_DISPLAY: wayland-0
  • GIO_LAUNCHED_DESKTOP_FILE: /usr/share/applications/pgadmin4.desktop
  • GIO_LAUNCHED_DESKTOP_FILE_PID: 15250
  • GDK_BACKEND: x11
  • NO_AT_BRIDGE: 1
  • PGADMIN_INT_PORT: 36893
  • PGADMIN_INT_KEY: 61652ca5-4788-4855-b84c-879a28f99ebb
  • PGADMIN_SERVER_MODE: OFF

Total spawn time to start the pgAdmin4 server: 0.021 Sec Failed to launch pgAdmin4. Error: Error: spawn /usr/pgadmin4/venv/bin/python3 ENOENT

Having same Issue

@grizzlysmit
Copy link

grizzlysmit commented Apr 30, 2024

@adityatoshniwal

Ubuntu Noble is not yet supported by pgAdmin. So this is a feature and not a bug. One can check the supported versions here - https://www.pgadmin.org/download/pgadmin-4-apt/

I do wish pgAdmin would not be so tied to OS release - IIRC pgadmin broke down on the previous 2 Ubuntu releases also and the mantic fix took a while. Its a catch-22 situation between installing an OS release upgrade only if pgadmin supports the os and knowing if pgadmin4 works on the release - ... or other way is to wait till pgadmin lists the OS version as supported.

There's a lot of effort involved in supporting one OS version as we need to make changes in build machines and also test the release builds (which may require changes in code as well if things doesn't work). What we need to do better is to be aware of next major release date so we can plan things accordingly.

yeah we have to be a bit patient with this they always get there, there will be a new release for 24.04 soon meanwhile do what I do keep checking their sight for the release and use a machine virtual or otherwise with an earlier ubuntu to run pgAmin4

@rakibmirza
Copy link

rakibmirza commented May 1, 2024

any idea when pgadmin4 will be released for ubuntu 24.04?

@khushboovashi
Copy link
Contributor

khushboovashi commented May 2, 2024

any idea when pgadmin4 will be released for ubuntu 24.04?

We are targeting Ubuntu 24.04 for the June release.

@Hanzala47
Copy link

any idea when pgadmin4 will be released for ubuntu 24.04?

Update your pgadmin4 to the latest version 8.6.
Just released yesterday.

its working now.

@notnullonline
Copy link

any idea when pgadmin4 will be released for ubuntu 24.04?

Update your pgadmin4 to the latest version 8.6. Just released yesterday.

its working now.

Steps please... :(

@Hanzala47
Copy link

any idea when pgadmin4 will be released for ubuntu 24.04?

Update your pgadmin4 to the latest version 8.6. Just released yesterday.
its working now.

Steps please... :(

sudo apt update
sudo apt upgrade

if not work, then purge pgadmin4 and do fresh install

@johan-nilsson-82
Copy link

any idea when pgadmin4 will be released for ubuntu 24.04?

Update your pgadmin4 to the latest version 8.6. Just released yesterday.
its working now.

Steps please... :(

sudo apt update sudo apt upgrade

if not work, then purge pgadmin4 and do fresh install

I tried to install on a fresh installed Ubuntu 24.04 but still same issue for me.

I followed the steps here: https://www.pgadmin.org/download/pgadmin-4-apt/

I had to use version mantic instead of nobel since it was not released yet. What version where you using?

This version I used: https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/mantic/

I will also make an attempt to install from source. But since you wrote that you just updated and upgraded I assume that you use the packet manager also.

@JoaoPauloK
Copy link

I just installed python3.11 aside native python.12 and pointed the symbolic link to python3.11 instead. It worked.

@Mikhail42
Copy link

Mikhail42 commented May 11, 2024

for me the solution it to use another Postgres DB client, like DBeaver... Waiting for June it too much, and installing python3.11 also is not really good variant, because there are other problems with it

@yorickdowne
Copy link

Works without issue and without going for 3.11 here, on mantic apt package and pgadmin4 8.6.

@KostyanM
Copy link

Guys, it works okay if install pgadmin into virtual environment. At download page pgadmin site see python version installing

@gp-abhishek
Copy link

@sanjayminni

WA is to install python version 3.11.

sudo add-apt-repository ppa:deadsnakes/ppa
sudo apt update
sudo apt install python3.11

After this pgAdmin will be working. If you have still issue then, check symlink for venv as below

$ ls -l /usr/pgadmin4/venv/bin/python3
lrwxrwxrwx 1 root root 19 Apr  1 17:21 /usr/pgadmin4/venv/bin/python3 -> /usr/bin/python3.11
$

To correct the symlinks run

ln -s /usr/bin/python3.11 /usr/pgadmin4/venv/bin/python3

Thanks a lot, installing python 3.11 worked for me

but i had to do

sudo apt remove libpython3.11-minimal libpython3.11-stdlib python3.11-minimal python3.11

@AnkahHarrison
Copy link

Screenshot from 2024-05-14 20-32-36
i did all this as required but still pgadmin4 is not working
sudo add-apt-repository ppa:deadsnakes/ppa
sudo apt update
sudo apt install python3.11

$ ls -l /usr/pgadmin4/venv/bin/python3

@AnkahHarrison
Copy link

pgAdmin Runtime Environment

Python Path: "/usr/pgadmin4/venv/bin/python3"
Runtime Config File: "/home/seyram/.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:

  • HOME: /home/seyram
  • LANG: en_US.UTF-8
  • LOGNAME: seyram
  • PATH: /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/snap/bin
  • SHELL: /bin/bash
  • USER: seyram
  • XDG_RUNTIME_DIR: /run/user/1000
  • GTK_MODULES: gail:atk-bridge
  • QT_ACCESSIBILITY: 1
  • XDG_DATA_DIRS: /usr/share/ubuntu:/usr/share/gnome:/usr/local/share/:/usr/share/:/var/lib/snapd/desktop
  • DBUS_SESSION_BUS_ADDRESS: unix:path=/run/user/1000/bus
  • DEBUGINFOD_URLS: https://debuginfod.ubuntu.com
  • DESKTOP_SESSION: ubuntu
  • GDMSESSION: ubuntu
  • GNOME_DESKTOP_SESSION_ID: this-is-deprecated
  • GNOME_SHELL_SESSION_MODE: ubuntu
  • GSM_SKIP_SSH_AGENT_WORKAROUND: true
  • IM_CONFIG_PHASE: 1
  • PWD: /home/seyram
  • QT_IM_MODULE: ibus
  • SESSION_MANAGER: local/seyram:@/tmp/.ICE-unix/2783,unix/seyram:/tmp/.ICE-unix/2783
  • SHLVL: 0
  • SSH_AUTH_SOCK: /run/user/1000/keyring/ssh
  • USERNAME: seyram
  • XDG_CONFIG_DIRS: /etc/xdg/xdg-ubuntu:/etc/xdg
  • XDG_CURRENT_DESKTOP: ubuntu:GNOME
  • XDG_MENU_PREFIX: gnome-
  • XDG_SESSION_CLASS: user
  • XDG_SESSION_DESKTOP: ubuntu
  • XDG_SESSION_TYPE: wayland
  • XMODIFIERS: @im=ibus
  • _: /usr/bin/gnome-session
  • MANAGERPID: 2532
  • INVOCATION_ID: 1ead4e26346a4d34bdfeb58668e75553
  • JOURNAL_STREAM: 8:20998
  • SYSTEMD_EXEC_PID: 2829
  • MEMORY_PRESSURE_WATCH: /sys/fs/cgroup/user.slice/user-1000.slice/user@1000.service/session.slice/org.gnome.Shell@wayland.service/memory.pressure
  • MEMORY_PRESSURE_WRITE: c29tZSAyMDAwMDAgMjAwMDAwMAA=
  • GJS_DEBUG_OUTPUT: stderr
  • GJS_DEBUG_TOPICS: JS ERROR;JS LOG
  • GNOME_SETUP_DISPLAY: :1
  • DISPLAY: :0
  • XAUTHORITY: /run/user/1000/.mutter-Xwaylandauth.BIGPN2
  • WAYLAND_DISPLAY: wayland-0
  • GIO_LAUNCHED_DESKTOP_FILE: /usr/share/applications/pgadmin4.desktop
  • GIO_LAUNCHED_DESKTOP_FILE_PID: 3629
  • GDK_BACKEND: x11
  • NO_AT_BRIDGE: 1
  • PGADMIN_INT_PORT: 46207
  • PGADMIN_INT_KEY: 55107c68-daaf-41f7-9993-0597013e4922
  • PGADMIN_SERVER_MODE: OFF

Total spawn time to start the pgAdmin4 server: 0.008 Sec
Traceback (most recent call last):
File "/usr/pgadmin4/web/pgAdmin4.py", line 48, in

import config

File "/usr/pgadmin4/web/config.py", line 33, in

from pgadmin.utils import env, IS_WIN, fs_short_path

File "/usr/pgadmin4/web/pgadmin/init.py", line 24, in
from flask import Flask, abort, request, current_app, session, url_for
ModuleNotFoundError: No module named 'flask'

Screenshot from 2024-05-14 22-29-35

@fitiavanaeni
Copy link

image

I can't resolve it
Help!

@TaeZStkyoht
Copy link

@daveysyr
Copy link

On the pgadmin website, it clearly states that Ubuntu 24.04 noble is supported from V8.7 (pgadmin is currently at 8.6). So despite the repository seeming to exist, there is nothing much inside it.

My experience so far is that the Docker version doesn't work correctly for users and neither does the Python version - both these versions assume that you have a fair bit of experience with either Docker or Python respectively.

So, if you're currently successfully using pgadmin4-desktop within a version of Ubuntu before the current 'noble' release, hold off your upgrade to the latest Ubuntu version until the next pgadmin version (8.7) is released sometime in June 2024.

@akshay-joshi
Copy link
Contributor

akshay-joshi commented May 20, 2024

Hi All

It will be available from v8.7. Meanwhile, you can test on the snapshot build.
It would help us to know any issues in advance.

@daveysyr
Copy link

Hi, and thanks for commenting.

I tried what you suggested and the desktop app is working for me now on Ubuntu Noble, so thank you very much for that!!

Being able to run pgadmin as a desktop app is super-useful for me. I'll certainly be more careful around checking compatibility next time I upgrade Ubuntu!

Regards,
Dave.

Hi All

It will be available from v8.7. Meanwhile, you can test on the snapshot build.

It would help us to know any issues in advance.

@akshay-joshi akshay-joshi added this to the 8.7 milestone May 22, 2024
@fuattatar
Copy link

Hi All

It will be available from v8.7. Meanwhile, you can test on the snapshot build. It would help us to know any issues in advance.

It worked thank you

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Status: In Testing
Development

No branches or pull requests