Error checking db: no file exists at the file path

mohitparwani21 · April 16, 2024, 11:16am

I neede to work on grafana with sqlite datasource. I downloaded this sqlite datasource plugin but even after giving correct filepath and details when I press save and test I get the error. checked multiple times the database file really exist and requires no permissions.
even restarted grafana

error checking db: no file exists at the file path

I:/Public/Jaipur/Quant/MasterASE/masterASE.db

this is the file path I’m writing.

can someone please help me with that

sowdenraymond · April 16, 2024, 11:53am

github.com

fr-ser/grafana-sqlite-datasource/blob/main/docs/faq.md#i-have-a-file-not-found-error-for-my-database

# Common Problems / FAQ

The following section describes common issues encountered while using the plugin.

## I have a "file not found" error for my database

The first choice should be to make sure, that the path is correct. It is also good practice to
use absolute paths (e.g. `/app/state/data.db`) instead of relative paths (`state/data.db`).

In case the path is correct but the database is in the `/var` directory on a linux system there
might also be a systemd issue. This is typically observed with Grafana versions starting with
v8.2.0. When Grafana is run via systemd (the typical default installation on Linux systems) the
`/var` directory is not available to Grafana (and therefore also not to the plugin).

In order to change this behavior you need to do the following:

```txt
# edit (override) the grafana systemd configuration
systemctl edit grafana-server

This file has been truncated. show original

mohitparwani21 · April 16, 2024, 11:57am

I already read this faq’s and this was not able to solve my problem

sowdenraymond · April 16, 2024, 11:59am

is Grafana installed on the same machine that has the I: drive?

mohitparwani21 · April 16, 2024, 12:06pm

one thing to mention this directory “I” is the network locations directory.

sowdenraymond · April 16, 2024, 12:10pm

where is grafana installed?

mohitparwani21 · April 16, 2024, 12:13pm

it is in my local system
directory (c drive)

yosiasz · April 16, 2024, 12:16pm

The doc mentions file has to be installed on same machine as grafana

This is a Grafana backend plugin to allow using an SQLite database as a data source. The SQLite database needs to be accessible to the filesystem of the device where Grafana itself is running.

mohitparwani21 · April 16, 2024, 1:52pm

so there Isn’t anyway to link grafana to sqlite datasource which is in separate directory?

yosiasz · April 16, 2024, 2:04pm

no there isn’t a way to link it to a remote file. you can also imagine the security issue such an approach poses.

what uses this sqlite db that it has to be on a remote location? Do you have an app that currently uses it?

mohitparwani21 · April 16, 2024, 2:11pm

This DB is getting updated continuously By an application running on my teammate’s system and we both have access to this network directory now I want to use this database file in Grafana to create a dashboard.
one thing to mention we both are also connected to the same local network.

yosiasz · April 16, 2024, 2:19pm

few options

copy that file to a local folder where grafana is installed on cron job every 5 minutes
use a more robust database for the application such as mysql or postgres then both the app and grafana can use a centralized database
have a proper separate server where mysql installed, and grafana is installed on and application is installed on. (not on your or teammate’s system, laptop, desktop)

mohitparwani21 · April 16, 2024, 2:25pm

Ok so I’ll go with the cron job thing.
Or I’ll write some python script to get the updated rows only as the database will be big.
Well thanks for helping with that.
Thank You so much.