Sqlite plugin - permission denied

Grafana Configuration
1

using the sqlite plugin, latest version (2.1.1) on grafana (8.2.2), running on raspberry pi 3B (Linux raspberrypi 5.10.63-v7+ #1459 SMP Wed Oct 6 16:41:10 BST 2021 armv7l GNU/Linux)

when configuring the data source, the plugin responds (save and test) with error checking existence: stat /home/pi/redirect/sqlite3/redirect.db: permission denied

both of us (2 users having the same problem) have checked and rechecked the permissions. All tests have been published here (plugin issues on GitHub).

several tests have been performed, in order to identify the problem, no luck.
The problem occurs when having the database located in /home/pi/redirect/sqlite3/
When the database is copied to another location (for example /etc/pihole/), the problem does not occur.

Anybody had a permissions problem like this (and hopefully a solution - not implying to move the database to another location, e.g. workarround)?

2

seriouslly dirty workaround (probably not appriciated by the linux admin):

mkdir -p /grafana
mkdir -p /grafana/redirect
sudo mount -r --bind /home/pi/redirect/sqlite3 /grafana/redirect

define data source as /grafana/redirect/redirect.db → works

fstab entry:
/home/pi/redirect/sqlite3 /grafana/redirect none bind 0 0

does the plugin and / or grafana has a problem with anything in /home?

4

Hi there!

In documentation for Sqlite plugin defined this trouble.

# edit (override) the grafana systemd configuration
systemctl edit grafana-server
add the following lines
[Service]
ProtectHome=false
reload the systemd config and restart the app

systemctl daemon-reload
systemctl restart grafana-server

It’s work for me.

5

Sorry the initial post had a wrong link. More details can be found in this thread: Failed to start - plugin folder permission denied - #3 by frser