Cannot load SQLite plugin after installation

[omri-madar]

I installed the SQLite plugin on my Grafana cloud instance, and expected to see it active, when trying to create a new connection to my SQLite DB.
I waited 5 minutes, one hour, 24 hours... nothing changes.
It's the first time I'm installing this plugin, actually the first time installing anything on it's cloud instance.

I attached screenshots that show the error I get, and the plugin page that confirms that it was installed indeed.

I started with opening a ticket to Grafana support, and that was their response:
" the secure_socks_datasource_proxy can’t start because it couldn’t open the PDC (private datasource connect) certificate file. Normally, I’d look up the code generating this error in our internal GitHub repos to figure out why it’s happening and how to fix it. However, since we didn’t develop this plugin, its code isn’t part of our repositories, and I’m unable to investigate further.
Because of that, you’ll need to report this issue to the developers of the SQLite plugin for guidance."

The relevant log lines:

ts=2025-01-11T19:38:25.452893269Z pluginSlug=frser-sqlite-datasource pluginVersion=3.5.0 retriesLeft=2 caller=plugins.go:76 app=hgrun hgrun_version=0.1.511 slug=omri08 traceID=463320a669e6974d6da9e91ecef2e1e4 stream=stdout msg="logger=settings t=2025-01-11T19:38:25.452858758Z level=error msg=\"secure_socks_datasource_proxy unable to start up\" err=\"open /etc/grafana/pdc_client.crt: no such file or directory\""

---

• OS: Windows 11
• Run via docker? no
• Browser: Google Chrome version 131.0.6778.205 (Official Build) (64-bit)
• Grafana Version: Cloud instance
• Plugin Version: 3.5.0
• Plugin installed via grafana-cli or manually? via Grafana Labs site

[fr-ser]

Before diving into the depths of your issue:

Are you aware of the functionality of grafana cloud and this plugin?
Have you read this section: https://github.com/fr-ser/grafana-sqlite-datasource/blob/main/docs/faq.md#can-i-run-the-plugin-with-grafana-cloud?

Do you really want to use the SQLite plugin in Grafana Cloud and could you explain why?

[omri-madar]

@fr-ser I'm using an SQLite DB because I need a small DB and want to keep it simple.
I'm using the Grafana since I need to monitor and analyze some of that data.
I've read the question in the link but sincerely didn't understand the issue and the complexity it brings, also, if it's that complicated/inefficient, why is it available in the first place?

[fr-ser]

The core of the issue is that "Grafana Cloud" runs inside the cloud.
SQLite is a local database without a network interface.

So if you do not run Grafana on the same computer as the SQLite database is located at, then that is a problem.

[omri-madar]

Ok, I'm fine with that. I'm the only user of that DB and nobody else cares.
So besides of that, is there any other problem in such a setup?

[fr-ser]

I am not sure that we are on the same page yet.

Can you confirm that the Grafana installation and the SQLite database are on the same machine?

Specifically, if you are using Grafana Cloud how can the SQLite database be on the same machine?