:permission denied - Githubissues

fr-ser / grafana-sqlite-datasource

Grafana Plugin to enable SQLite as a Datasource

Apache License 2.0

126 stars 17 forks source link

:permission denied #127

Closed Frederic-SABU closed 8 months ago

Frederic-SABU commented 8 months ago

Describe the bug Unable to open an sqlite3 base in Grafana (local not cloud)

To Reproduce Add the sqlite plugin to Grafana Try to open a local sqlite3 database Grafana unable to access the data I have tried the FAQ patches by toggling the Protect_Home from true to false with no avail. The DB opens correctly with Python and DB Browser

Screenshots

Versions (please complete the following information):

OS: Ubuntu 22
Run via apt package
Browser chrome
Grafana Version 10.2.3
Plugin Version 3.4.0
Plugin installed via grafana-cli

Additional context Add any other context about the problem here. Please also attach the logs of Grafana!

fr-ser commented 8 months ago

What about the permissions?

Can the Grafana user access every part of the path?

Frederic-SABU commented 8 months ago

I have indeed already seen that comment but not sure about what is a Grafana User. I have set the database file permission to R&W. I can obviously access them but again from Grafana side I am a bit puzzled ?

fr-ser commented 8 months ago

Normally Grafana has a custom user (named Grafana) that it creates during the installation.

You need to make sure that this user can read the database.

And you also need to make sure that this user can read all directories in the path of the file.

Frederic-SABU commented 8 months ago

Actually the default user was admin and it got the administration right. I have even tried to create an extra user with admin righhts as well. Same problem. I think I will stop at my Grafana atempt at this stage it is far too time consuming. I will go back to MathPlot scripts. Thks for helping out anyway.

Frederic-SABU commented 8 months ago

Thks.