Opened 10 months ago

Closed 5 months ago

#2438 closed defect (fixed)

pgadmin is not starting in 16.0 beta 1

Reported by: christro Owned by: osgeolive@…
Priority: major Milestone: OSGeoLive16.0
Component: OSGeoLive Keywords: vmdk, pgadmin
Cc: osgeolive@…

Description

Total spawn time to start the pgAdmin4 server: 0.008 Sec
ERROR  : Failed to create the directory /home/user/.pgadmin/sessions:
           [Errno 13] Permission denied: '/home/user/.pgadmin/sessions'
HINT   : Create the directory /home/user/.pgadmin/sessions, ensure it is writeable by
         'user', and try again, or, create a config_local.py file
         and override the SESSION_DB_PATH setting per
         https://www.pgadmin.org/docs/pgadmin4/7.4/config_py.html

Possible Solution

#There is a directory.pgadmin with the owner root
user@osgeolive:~$ ls -la .pgadmin/
total 172
drwxr-xr-x  2 root root   4096 Jun 17 17:59 ./
drwxr-x--- 24 user user   4096 Jul  1 15:33 ../
-rw-r--r--  1 root root 167936 Jul  1 12:38 pgadmin4.db

#Change the owner to user:user
sudo chown -R user:user .pgadmin

Change history (5)

comment:1 by kalxas, 9 months ago

Cc: osgeolive@… added
Keywords: vmdk, pgadmin, → vmdk, pgadmin
Priority: normalmajor

comment:2 by kalxas, 8 months ago

still valid in rc1

comment:3 by darkblueb, 8 months ago

rc1 VMDK

pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "/usr/pgadmin4/venv/bin/python3"
Runtime Config File: "/home/user/.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: 
  - USER: user
  - BROWSER: firefox
  - DBUS_SESSION_BUS_ADDRESS: unix:path=/run/user/1000/bus
  - DESKTOP_SESSION: Lubuntu
  - DISPLAY: :0
  - GDK_BACKEND: x11
  - GPG_AGENT_INFO: /run/user/1000/gnupg/S.gpg-agent:0:1
  - GTK_CSD: 0
  - GTK_OVERLAY_SCROLLING: 0
  - HOME: /home/user
  - LANG: en_US.UTF-8
  - LC_ADDRESS: en_US.UTF-8
  - LC_IDENTIFICATION: en_US.UTF-8
  - LC_MEASUREMENT: en_US.UTF-8
  - LC_MONETARY: en_US.UTF-8
  - LC_NAME: en_US.UTF-8
  - LC_NUMERIC: en_US.UTF-8
  - LC_PAPER: en_US.UTF-8
  - LC_TELEPHONE: en_US.UTF-8
  - LC_TIME: en_US.UTF-8
  - LOGNAME: user
  - LXQT_SESSION_CONFIG: session
  - NO_AT_BRIDGE: 1
  - PATH: /home/user/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/usr/lib/gmt/bin
  - PWD: /home/user
  - QT_ACCESSIBILITY: 1
  - QT_PLATFORM_PLUGIN: lxqt
  - QT_QPA_PLATFORMTHEME: lxqt
  - SAL_USE_VCLPLUGIN: qt5
  - SAL_VCL_QT5_USE_CAIRO: true
  - SHELL: /bin/bash
  - SHLVL: 0
  - SSH_AGENT_PID: 1135
  - SSH_AUTH_SOCK: /tmp/ssh-XXXXXXXsxaLE/agent.1072
  - TERM: qterminal
  - XAUTHORITY: /home/user/.Xauthority
  - XDG_CACHE_HOME: /home/user/.cache
  - XDG_CONFIG_DIRS: /etc/xdg/xdg-Lubuntu:/etc/xdg:/etc:/usr/share
  - XDG_CONFIG_HOME: /home/user/.config
  - XDG_CURRENT_DESKTOP: LXQt
  - XDG_DATA_DIRS: /usr/share/Lubuntu:/usr/local/share:/usr/share:/var/lib/snapd/desktop
  - XDG_DATA_HOME: /home/user/.local/share
  - XDG_MENU_PREFIX: lxqt-
  - XDG_RUNTIME_DIR: /run/user/1000
  - XDG_SEAT_PATH: /org/freedesktop/DisplayManager/Seat0
  - XDG_SEAT: seat0
  - XDG_SESSION_CLASS: user
  - XDG_SESSION_DESKTOP: 
  - XDG_SESSION_ID: 1
  - XDG_SESSION_PATH: /org/freedesktop/DisplayManager/Session0
  - XDG_SESSION_TYPE: x11
  - XDG_VTNR: 1

  - PGADMIN_INT_PORT: 32955
  - PGADMIN_INT_KEY: c1266a46-3a31-46bb-9bed-1d71624fc45c
  - PGADMIN_SERVER_MODE: OFF
--------------------------------------------------------

Total spawn time to start the pgAdmin4 server: 0.032 Sec
ERROR  : Failed to create the directory /home/user/.pgadmin/sessions:
           [Errno 13] Permission denied: '/home/user/.pgadmin/sessions'
HINT   : Create the directory /home/user/.pgadmin/sessions, ensure it is writeable by
         'user', and try again, or, create a config_local.py file
         and override the SESSION_DB_PATH setting per
         https://www.pgadmin.org/docs/pgadmin4/7.5/config_py.html

Last edited 8 months ago by darkblueb (previous) (diff)

comment:4 by darkblueb, 8 months ago

this is why

user $ ls -lha | grep pgad
drwxr-xr-x  2 root root  4096 Aug 21 19:51 .pgadmin/

comment:5 by kalxas, 5 months ago

Resolution: fixed
Status: newclosed

Fixed in latest VM

Note: See TracTickets for help on using tickets.