pgAdmin4 9.16 cannot start on Ubuntu 24.04

[x27lu-baml]

Describe the bug
I upgraded pgAdmin4 from 9.15 to 9.16, and it gets stuck on the loading screen, until a few minutes later when I'm presented with an error message (full error message below). I had to downgrade it back to 9.15 for it to work again.

To Reproduce
On Ubuntu 24.04, upgrade pgAdmin to 9.16 via apt-get. Then open pgAdmin desktop

Expected behavior
After upgrade, the application should open normally

Error message
Error message shown by pgAdmin:

Total spawn time to start the pgAdmin4 server: 0.005 Sec
Traceback (most recent call last):
  File "/usr/pgadmin4/web/pgAdmin4.py", line 93, in <module>
    app = create_app()
          ^^^^^^^^^^^^
  File "/usr/pgadmin4/web/pgadmin/__init__.py", line 789, in create_app

    app.register_blueprint(module)
  File "/usr/pgadmin4/venv/lib/python3.12/site-packages/flask/sansio/scaffold.py", line 47, in wrapper_func
    return f(self, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/pgadmin4/venv/lib/python3.12/site-packages/flask/sansio/app.py", line 595, in register_blueprint
    blueprint.register(self, options)
  File "/usr/pgadmin4/web/pgadmin/misc/__init__.py", line 199, in register
    from .cloud import blueprint as module
  File "/usr/pgadmin4/web/pgadmin/misc/cloud/__init__.py", line 30, in <module>
    from pgadmin.misc.cloud.google import clear_google_session, deploy_on_google
  File "/usr/pgadmin4/web/pgadmin/misc/cloud/google/__init__.py", line 28, in <module>
    from googleapiclient import discovery
  File "/usr/pgadmin4/venv/lib/python3.12/site-packages/googleapiclient/discovery.py", line 64, in <module>
    from googleapiclient import _auth, mimeparse
  File "/usr/pgadmin4/venv/lib/python3.12/site-packages/googleapiclient/_auth.py", line 34, in <module>
    import oauth2client.client
  File "/usr/lib/python3/dist-packages/oauth2client/client.py", line 45, in <module>
    from oauth2client import crypt
  File "/usr/lib/python3/dist-packages/oauth2client/crypt.py", line 45, in <module>
    from oauth2client import _openssl_crypt
  File "/usr/lib/python3/dist-packages/oauth2client/_openssl_crypt.py", line 16, in <module>
    from OpenSSL import crypto
  File "/usr/lib/python3/dist-packages/OpenSSL/__init__.py", line 8, in <module>
    from OpenSSL import SSL, crypto
  File "/usr/lib/python3/dist-packages/OpenSSL/SSL.py", line 20, in <module>
    from OpenSSL.crypto import (
  File "/usr/lib/python3/dist-packages/OpenSSL/crypto.py", line 765, in <module>
    class X509Extension:
  File "/usr/lib/python3/dist-packages/OpenSSL/crypto.py", line 846, in X509Extension
    _lib.GEN_EMAIL: "email",
    ^^^^^^^^^^^^^^
AttributeError: module 'lib' has no attribute 'GEN_EMAIL'

Desktop (please complete the following information):

• OS: Ubuntu 24.04.4 LTS
• pgAdmin version: 9.16
• Mode: Desktop
• Package type: DEB

[khteh]

pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "/usr/pgadmin4/venv/bin/python3"
Runtime Config File: "/home/khteh/.config/pgadmin4/config.json"
Webapp Path: "/usr/pgadmin4/web/pgAdmin4.py"
pgAdmin Command: "/usr/pgadmin4/venv/bin/python3 -s /usr/pgadmin4/web/pgAdmin4.py"
Environment: 
  - HOME: /home/khteh
  - LANG: en_US.UTF-8
  - LANGUAGE: en_US:en
  - LC_ADDRESS: en_SG.UTF-8
  - LC_IDENTIFICATION: en_SG.UTF-8
  - LC_MEASUREMENT: en_SG.UTF-8
  - LC_MONETARY: en_SG.UTF-8
  - LC_NAME: en_SG.UTF-8
  - LC_NUMERIC: en_SG.UTF-8
  - LC_PAPER: en_SG.UTF-8
  - LC_TELEPHONE: en_SG.UTF-8
  - LC_TIME: en_SG.UTF-8
  - LOGNAME: khteh
  - PATH: /home/khteh/.local/bin:/opt/intel/oneapi/vtune/2026.2/bin64:/opt/intel/oneapi/mpi/2021.18/bin:/opt/intel/oneapi/mkl/2026.0/bin:/opt/intel/oneapi/dpcpp-ct/2025.3/bin:/opt/intel/oneapi/dev-utilities/2026.0/bin:/opt/intel/oneapi/debugger/2026.0/opt/debugger/bin:/opt/intel/oneapi/compiler/2026.0/bin:/opt/intel/oneapi/advisor/2026.0/bin64:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/opt/go:/opt/td-agent/bin:/opt/neo4j:/opt/Telegram:/snap/bin:/home/khteh/.dotnet/tools:/usr/lib/jvm/jdk-21-oracle-x64/bin:/usr/lib/jvm/jdk-21-oracle/db/bin
  - SHELL: /bin/bash
  - USER: khteh
  - 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
  - ADVISOR_2026_DIR: /opt/intel/oneapi/advisor/2026.0
  - ANDROID_HOME: /home/khteh/Android/Sdk
  - APM: /opt/intel/oneapi/advisor/2026.0/perfmodels
  - CCL_CONFIGURATION: cpu_gpu_dpcpp
  - CCL_CONFIGURATION_PATH: 
  - CCL_ROOT: /opt/intel/oneapi/ccl/2022.0
  - CLASSPATH: /opt/intel/oneapi/mpi/2021.18/share/java/mpi.jar
  - CMAKE_PREFIX_PATH: /opt/intel/oneapi/tbb/2023.0/env/..:/opt/intel/oneapi/pti/0.10/lib/cmake/pti:/opt/intel/oneapi/mkl/2026.0/lib/cmake:/opt/intel/oneapi/ipp/2026.0/lib/cmake/ipp:/opt/intel/oneapi/dpl/2022.12/lib/cmake/oneDPL:/opt/intel/oneapi/dnnl/2026.0/lib/cmake:/opt/intel/oneapi/dal/2026.1:/opt/intel/oneapi/compiler/2026.0:/opt/intel/oneapi/ccl/2022.0/lib/cmake/oneCCL
  - CMPLR_ROOT: /opt/intel/oneapi/compiler/2026.0
  - CPATH: /opt/intel/oneapi/umf/1.1/include:/opt/intel/oneapi/pti/0.10/include:/opt/intel/oneapi/dev-utilities/2026.0/include:/opt/intel/oneapi/ccl/2022.0/include
  - CPLUS_INCLUDE_PATH: /opt/intel/oneapi/umf/1.1/include:/opt/intel/oneapi/tbb/2023.0/env/../include:/opt/intel/oneapi/mpi/2021.18/include:/opt/intel/oneapi/mkl/2026.0/include:/opt/intel/oneapi/ippcp/2026.0/include:/opt/intel/oneapi/ipp/2026.0/include:/opt/intel/oneapi/dpl/2022.12/include:/opt/intel/oneapi/dpcpp-ct/2025.3/include:/opt/intel/oneapi/dnnl/2026.0/include:/opt/intel/oneapi/dal/2026.1/include:/opt/intel/oneapi/dal/2026.1/include/dal
  - C_INCLUDE_PATH: /opt/intel/oneapi/umf/1.1/include:/opt/intel/oneapi/tbb/2023.0/env/../include:/opt/intel/oneapi/mpi/2021.18/include:/opt/intel/oneapi/mkl/2026.0/include:/opt/intel/oneapi/ippcp/2026.0/include:/opt/intel/oneapi/ipp/2026.0/include:/opt/intel/oneapi/dnnl/2026.0/include
  - DALROOT: /opt/intel/oneapi/dal/2026.1
  - DAL_MAJOR_BINARY: 4
  - DAL_MINOR_BINARY: 0
  - DBUS_SESSION_BUS_ADDRESS: unix:path=/run/user/1000/bus
  - DEBUGINFOD_URLS: https://debuginfod.ubuntu.com 
  - DERBY_HOME: /usr/lib/jvm/java-21-oracle-x64/db
  - DESKTOP_SESSION: ubuntu
  - DIAGUTIL_PATH: /opt/intel/oneapi/dpcpp-ct/2025.3/etc/dpct/sys_check/sys_check.sh:/opt/intel/oneapi/compiler/2026.0/etc/compiler/sys_check/sys_check.sh
  - DNNLROOT: /opt/intel/oneapi/dnnl/2026.0
  - DOTNET_BUNDLE_EXTRACT_BASE_DIR: /home/khteh/.cache/dotnet_bundle_extract
  - DPLROOT: /opt/intel/oneapi/dpl/2022.12
  - DPL_ROOT: /opt/intel/oneapi/dpl/2022.12
  - FI_PROVIDER_PATH: /opt/intel/oneapi/mpi/2021.18/opt/mpi/libfabric/lib/prov:/usr/lib/x86_64-linux-gnu/libfabric
  - GDB_INFO: /opt/intel/oneapi/debugger/2026.0/share/info/
  - GDMSESSION: ubuntu
  - GNOME_DESKTOP_SESSION_ID: this-is-deprecated
  - GPG_AGENT_INFO: /run/user/1000/gnupg/S.gpg-agent:0:1
  - IM_CONFIG_ENTRY: profile
  - INFOPATH: /opt/intel/oneapi/debugger/2026.0/share/info
  - INTEL_PYTHONHOME: /opt/intel/oneapi/debugger/2026.0/opt/debugger
  - IPPCP_TARGET_ARCH: intel64
  - IPPCRYPTOROOT: /opt/intel/oneapi/ippcp/2026.0
  - IPPROOT: /opt/intel/oneapi/ipp/2026.0
  - IPP_TARGET_ARCH: intel64
  - I_MPI_ROOT: /opt/intel/oneapi/mpi/2021.18
  - J2REDIR: /usr/lib/jvm/jdk-21-oracle-x64
  - J2SDKDIR: /usr/lib/jvm/jdk-21-oracle-x64
  - JAVA_HOME: /usr/lib/jvm/jdk-21-oracle-x64
  - LD_LIBRARY_PATH: /opt/intel/oneapi/tcm/1.5/lib:/opt/intel/oneapi/umf/1.1/lib:/opt/intel/oneapi/tcm/1.5/env/../lib:/opt/intel/oneapi/tbb/2023.0/env/../lib/intel64/gcc4.8:/opt/intel/oneapi/pti/0.10/lib:/opt/intel/oneapi/mpi/2021.18/opt/mpi/libfabric/lib:/opt/intel/oneapi/mpi/2021.18/lib:/opt/intel/oneapi/mkl/2026.0/lib:/opt/intel/oneapi/ippcp/2026.0/lib/:/opt/intel/oneapi/ipp/2026.0/lib:/opt/intel/oneapi/dnnl/2026.0/lib:/opt/intel/oneapi/debugger/2026.0/opt/debugger/lib:/opt/intel/oneapi/dal/2026.1/lib:/opt/intel/oneapi/compiler/2026.0/opt/compiler/lib:/opt/intel/oneapi/compiler/2026.0/lib:/opt/intel/oneapi/ccl/2022.0/lib/
  - LIBRARY_PATH: /opt/intel/oneapi/tcm/1.5/lib:/opt/intel/oneapi/umf/1.1/lib:/opt/intel/oneapi/tbb/2023.0/env/../lib/intel64/gcc4.8:/opt/intel/oneapi/pti/0.10/lib:/opt/intel/oneapi/mpi/2021.18/lib:/opt/intel/oneapi/mkl/2026.0/lib:/opt/intel/oneapi/ippcp/2026.0/lib/:/opt/intel/oneapi/ipp/2026.0/lib:/opt/intel/oneapi/dnnl/2026.0/lib:/opt/intel/oneapi/dal/2026.1/lib:/opt/intel/oneapi/compiler/2026.0/lib:/opt/intel/oneapi/ccl/2022.0/lib/
  - MANPATH: /opt/intel/oneapi/mpi/2021.18/share/man:/opt/intel/oneapi/debugger/2026.0/share/man:/opt/intel/oneapi/compiler/2026.0/share/man:
  - MKLROOT: /opt/intel/oneapi/mkl/2026.0
  - NLSPATH: /opt/intel/oneapi/compiler/2026.0/lib/compiler/locale/%l_%t/%N
  - OCL_ICD_FILENAMES: /opt/intel/oneapi/compiler/2026.0/lib/libintelocl.so
  - ONEAPI_ROOT: /opt/intel/oneapi
  - PAPERSIZE: a4
  - PKG_CONFIG_PATH: /opt/intel/oneapi/vtune/2026.2/include/pkgconfig/lib64:/opt/intel/oneapi/tbb/2023.0/env/../lib/pkgconfig:/opt/intel/oneapi/mpi/2021.18/lib/pkgconfig:/opt/intel/oneapi/mkl/2026.0/lib/pkgconfig:/opt/intel/oneapi/ippcp/2026.0/lib/pkgconfig:/opt/intel/oneapi/dpl/2022.12/lib/pkgconfig:/opt/intel/oneapi/dnnl/2026.0/lib/pkgconfig:/opt/intel/oneapi/dal/2026.1/lib/pkgconfig:/opt/intel/oneapi/compiler/2026.0/lib/pkgconfig:/opt/intel/oneapi/ccl/2022.0/lib/pkgconfig/:/opt/intel/oneapi/advisor/2026.0/include/pkgconfig/lib64:
  - PWD: /home/khteh
  - PYTHONPATH: /opt/intel/oneapi/advisor/2026.0/pythonapi
  - Pti_DIR: /opt/intel/oneapi/pti/0.10/lib/cmake/pti
  - QT_IM_MODULE: ibus
  - QT_IM_MODULES: wayland;ibus
  - SETVARS_COMPLETED: 1
  - SHLVL: 0
  - SSH_AUTH_SOCK: /run/user/1000/gcr/ssh
  - TBBROOT: /opt/intel/oneapi/tbb/2023.0/env/..
  - TCMROOT: /opt/intel/oneapi/tcm/1.5/env/..
  - TCM_ROOT: /opt/intel/oneapi/tcm/1.5
  - UMF_ROOT: /opt/intel/oneapi/umf/1.1
  - USERNAME: khteh
  - VTUNE_PROFILER_2026_DIR: /opt/intel/oneapi/vtune/2026.2
  - VTUNE_PROFILER_DIR: /opt/intel/oneapi/vtune/2026.2
  - 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_EXTRA_DEVICE_ACCESS: render:accel
  - XDG_SESSION_TYPE: wayland
  - XMODIFIERS: @im=ibus
  - MANAGERPID: 6941
  - MANAGERPIDFDID: 45492
  - INVOCATION_ID: b2df4e0e3ff8440f992a010eafbcff9a
  - JOURNAL_STREAM: 10:53638
  - SYSTEMD_EXEC_PID: 8132
  - MEMORY_PRESSURE_WATCH: /sys/fs/cgroup/user.slice/user-1000.slice/user@1000.service/session.slice/org.gnome.Shell@ubuntu.service/memory.pressure
  - MEMORY_PRESSURE_WRITE: c29tZSAyMDAwMDAgMjAwMDAwMAA=
  - GJS_DEBUG_OUTPUT: stderr
  - GJS_DEBUG_TOPICS: JS ERROR;JS LOG
  - GNOME_SETUP_DISPLAY: unix:/tmp/.X11-unix/X1
  - DISPLAY: :0
  - XAUTHORITY: /run/user/1000/.mutter-Xwaylandauth.6L5HR3
  - WAYLAND_DISPLAY: wayland-0
  - GIO_LAUNCHED_DESKTOP_FILE: /usr/share/applications/pgadmin4.desktop
  - GIO_LAUNCHED_DESKTOP_FILE_PID: 499157
  - CHROME_DESKTOP: pgadmin4.desktop
  - ELECTRON_ENABLE_SECURITY_WARNINGS: false
  - FC_FONTATIONS: 1
  - GDK_BACKEND: wayland
  - PGADMIN_INT_PORT: 39485
  - PGADMIN_INT_KEY: 60fff424-dc88-4976-ade4-4e2f10bc72fc
  - PGADMIN_SERVER_MODE: OFF
  - PYTHONDONTWRITEBYTECODE: 1
--------------------------------------------------------

Total spawn time to start the pgAdmin4 server: 0.005 Sec
/usr/pgadmin4/venv/lib/python3.14/site-packages/sshtunnel.py:1040: SyntaxWarning: 'return' in a 'finally' block
  return (ssh_host,

Traceback (most recent call last):

  File "/usr/pgadmin4/web/pgAdmin4.py", line 93, in <module>
    app = create_app()
  File "/usr/pgadmin4/web/pgadmin/__init__.py", line 789, in create_app
    app.register_blueprint(module)
    ~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^
  File "/usr/pgadmin4/venv/lib/python3.14/site-packages/flask/sansio/scaffold.py", line 47, in wrapper_func
    return f(self, *args, **kwargs)
  File "/usr/pgadmin4/venv/lib/python3.14/site-packages/flask/sansio/app.py", line 595, in register_blueprint
    blueprint.register(self, options)
    ~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^
  File "/usr/pgadmin4/web/pgadmin/misc/__init__.py", line 199, in register
    from .cloud import blueprint as module
  File "/usr/pgadmin4/web/pgadmin/misc/cloud/__init__.py", line 30, in <module>
    from pgadmin.misc.cloud.google import clear_google_session, deploy_on_google
  File "/usr/pgadmin4/web/pgadmin/misc/cloud/google/__init__.py", line 28, in <module>
    from googleapiclient import discovery
  File "/usr/pgadmin4/venv/lib/python3.14/site-packages/googleapiclient/discovery.py", line 64, in <module>
    from googleapiclient import _auth, mimeparse
  File "/usr/pgadmin4/venv/lib/python3.14/site-packages/googleapiclient/_auth.py", line 34, in <module>
    import oauth2client.client
  File "/usr/lib/python3/dist-packages/oauth2client/client.py", line 45, in <module>
    from oauth2client import crypt
  File "/usr/lib/python3/dist-packages/oauth2client/crypt.py", line 45, in <module>
    from oauth2client import _openssl_crypt
  File "/usr/lib/python3/dist-packages/oauth2client/_openssl_crypt.py", line 16, in <module>
    from OpenSSL import crypto
  File "/usr/lib/python3/dist-packages/OpenSSL/__init__.py", line 8, in <module>
    from OpenSSL import SSL, crypto
  File "/usr/lib/python3/dist-packages/OpenSSL/SSL.py", line 43, in <module>
    from OpenSSL.crypto import (
    ...<8 lines>...
    )
  File "/usr/lib/python3/dist-packages/OpenSSL/crypto.py", line 783, in <module>
    class X509Extension:
    ...<166 lines>...
            return _ffi.buffer(char_result, result_length)[:]
  File "/usr/lib/python3/dist-packages/OpenSSL/crypto.py", line 867, in X509Extension
    _lib.GEN_EMAIL: "email",
    ^^^^^^^^^^^^^^
AttributeError: module 'lib' has no attribute 'GEN_EMAIL'

[fredericramanda]

More: even with new .config file