Custom query (1087 matches)

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

import datacube
ERROR 1: PROJ: proj_create_from_database: Cannot find proj.db
rasterio/crs.pyx in rasterio.crs.CRS.from_epsg()
/usr/lib/python3/dist-packages/datacube/utils/geometry/_warp.py in <module>
---> 14 _WRP_CRS = rasterio.crs.CRS.from_epsg(3857

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