Linux Mint 21.1下pgAdmin4启动失败求助：无法连接服务器

问题详情 #

• 系统环境：Linux Mint 21.1（Vera），Python 3.10
• 故障现象：启动pgAdmin4时无法连接服务器，报错信息：Error: spawn /usr/pgadmin4/venv/bin/python3 ENOENT
• 已尝试操作：将Python从3.10降级至3.9，问题仍未解决

错误日志详情 #

Python Path: "/usr/pgadmin4/venv/bin/python3"
Runtime Config File: "/home/gabriel/.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
  - LANGUAGE: pt_BR:pt:en
  - USER: gabriel
  - XDG_SEAT: seat0
  - XDG_SESSION_TYPE: x11
  - SHLVL: 0
  - HOME: /home/gabriel
  - DESKTOP_SESSION: cinnamon
  - GIO_LAUNCHED_DESKTOP_FILE: /usr/share/applications/pgadmin4.desktop
  - GTK_MODULES: gail:atk-bridge
  - XDG_SEAT_PATH: /org/freedesktop/DisplayManager/Seat0
  - DBUS_SESSION_BUS_ADDRESS: unix:path=/run/user/1000/bus
  - CINNAMON_VERSION: 5.6.8
  - GIO_LAUNCHED_DESKTOP_FILE_PID: 68603
  - MANDATORY_PATH: /usr/share/gconf/cinnamon.mandatory.path
  - QT_QPA_PLATFORMTHEME: qt5ct
  - LOGNAME: gabriel
  - XDG_SESSION_CLASS: user
  - DEFAULTS_PATH: /usr/share/gconf/cinnamon.default.path
  - XDG_SESSION_ID: c2
  - GTK_OVERLAY_SCROLLING: 1
  - 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
  - GDM_LANG: pt_BR
  - GTK3_MODULES: xapp-gtk3-module
  - SESSION_MANAGER: local/gabriel-sm:@/tmp/.ICE-unix/1542,unix/gabriel-sm:/tmp/.ICE-unix/1542
  - XDG_SESSION_PATH: /org/freedesktop/DisplayManager/Session0
  - XDG_RUNTIME_DIR: /run/user/1000
  - DISPLAY: :0
  - LANG: pt_BR.UTF-8
  - XDG_CURRENT_DESKTOP: X-Cinnamon
  - XDG_SESSION_DESKTOP: cinnamon
  - XAUTHORITY: /home/gabriel/.Xauthority
  - XDG_GREETER_DATA_DIR: /var/lib/lightdm-data/gabriel
  - SSH_AUTH_SOCK: /run/user/1000/keyring/ssh
  - SHELL: /bin/bash
  - QT_ACCESSIBILITY: 1
  - GDMSESSION: cinnamon
  - GPG_AGENT_INFO: /run/user/1000/gnupg/S.gpg-agent:0:1
  - GJS_DEBUG_OUTPUT: stderr
  - XDG_VTNR: 7
  - PWD: /home/gabriel
  - XDG_CONFIG_DIRS: /etc/xdg/xdg-cinnamon:/etc/xdg
  - XDG_DATA_DIRS: /usr/share/cinnamon:/usr/share/gnome:/home/gabriel/.local/share/flatpak/exports/share:/var/lib/flatpak/exports/share:/usr/local/share:/usr/share
  - GDK_BACKEND: x11
  - NO_AT_BRIDGE: 1
  - PGADMIN_INT_PORT: 37479
  - PGADMIN_INT_KEY: 763f37a8-2241-4df7-a5bf-25f0210b266e
  - PGADMIN_SERVER_MODE: OFF

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

解决方法 #

1. 验证虚拟环境Python路径是否存在 #

执行以下命令检查指定路径下的Python文件是否存在：

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

如果输出中没有python3，说明pgAdmin4的虚拟环境已损坏或未正确安装，需执行重建操作。

2. 彻底重装pgAdmin4 #

• 卸载现有pgAdmin4及相关组件：

sudo apt remove --purge pgadmin4 pgadmin4-desktop

• 删除残留配置文件和虚拟环境目录：

sudo rm -rf /usr/pgadmin4/ /home/gabriel/.config/pgadmin/

• 更新软件源并重新安装：

sudo apt update && sudo apt install pgadmin4-desktop

3. 修改启动脚本中的Python路径 #

• 编辑pgAdmin4的桌面启动文件：

sudo nano /usr/share/applications/pgadmin4.desktop

• 找到Exec行，将/usr/pgadmin4/venv/bin/python3替换为系统中可用的Python路径（比如/usr/bin/python3.10或/usr/bin/python3.9）
• 按Ctrl+O保存，Ctrl+X退出后，重新启动pgAdmin4

4. 为虚拟环境创建Python软链接 #

• 查看系统已安装的Python版本：

ls /usr/bin/python*

• 选择一个存在的版本（如python3.10），在虚拟环境目录创建软链接：

sudo ln -s /usr/bin/python3.10 /usr/pgadmin4/venv/bin/python3

内容的提问来源于stack exchange，提问作者GMSoares