Error checking db: no file exists at the file path

Grafana
1

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

image
image794×837 42.6 KB

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

this is the file path I’m writing.

can someone please help me with that

2
3

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

4

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

5

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

6

where is grafana installed?

7

it is in my local system
directory (c drive)

8

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.

1 Like
9

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

1 Like
10

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?

11

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.

13

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.

1 Like