[SOLVED] Grafana install errors

[Mitch C]

So having rebuilt my system after the Signal K update issues/failures, I cannot get Grafana to install.
Grafana is one of the main uses of the system to show me all the boat data in one location, so I REALLY need this to work.
When trying to install via the dashboards I get the below errors. Is there any other way of completing the installation?

RPI4 32GB running a fresh 64bit OpenCPN image.

Hit:1 http://deb.debian.org/debian bullseye InRelease
Hit:2 http://deb.debian.org/debian bullseye-updates InRelease
Hit:3 http://security.debian.org/debian-security bullseye-security InRelease
Hit:4 http://archive.raspberrypi.org/debian bullseye InRelease
Hit:5 http://deb.debian.org/debian bullseye-backports InRelease
Hit:6 https://ppa.launchpadcontent.net/opencpn/opencpn/ubuntu focal InRelease
Get:7 https://apt.grafana.com stable InRelease [5,984 B]
Hit:8 https://repos.influxdata.com/debian bullseye InRelease
Hit:9 https://deb.nodesource.com/node_18.x bullseye InRelease
Hit:10 https://www.free-x.de/deb4op bullseye InRelease
Get:11 https://dl.cloudsmith.io/public/openplot...deb/debian bullseye InRelease [4,986 B]
Err:7 https://apt.grafana.com stable InRelease
  The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 963FA27710458545
Reading package lists...
W: GPG error: https://apt.grafana.com stable InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 963FA27710458545
E: The repository 'https://apt.grafana.com stable InRelease' is not signed.


Reading package lists...
Building dependency tree...
Reading state information...
E: Unable to locate package grafana
Checking sources...
DONE
Installing/Updating Grafana...
FAILED: [Errno 2] No such file or directory: 'grafana-cli'

[Mitch C]

Anyone - what other info do I need to supply to get this resolved?
Or where else should I go for advice?

Thanks

[PaddyB]

Anyone - what other info do I need to supply to get this resolved?
Or where else should I go for advice?

Thanks

I just spent a few minutes asking https://www.perplexity.ai/ ..
This works on my Pi3- 

Running sudo apt update-

Code:

Err:3 https://repos.influxdata.com/debian buster InRelease
  The following signatures couldn't be verified because the public key is not available: NO_PUBKEY D8FF8E1F7DF8B07E

Similar for grafana with a different key

To fix influxdb I ran -

Code:

sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys D8FF8E1F7DF8B07E

and to fix grafana I ran 

Code:

sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 963FA27710458545

Sudo apt update and upgrade worked after that.

Code:

pi@openplotter:~ $ apt list --installed | grep grafana

WARNING: apt does not have a stable CLI interface. Use with caution in scripts.

grafana/stable,now 10.1.2 armhf [installed]
pi@openplotter:~ $ apt list --installed | grep influxdb

WARNING: apt does not have a stable CLI interface. Use with caution in scripts.

influxdb/unknown,now 1.8.10-1 armhf [installed]
pi@openplotter:~ $

[Mitch C]

Anyone - what other info do I need to supply to get this resolved?
Or where else should I go for advice?

Thanks

I just spent a few minutes asking https://www.perplexity.ai/ ..
This works on my Pi3-

Thanks Paddy,
I'll try this on Saturday - crazy busy week with Yachtmaster practical exam prep.....UK weather has been a tad interesting this week!! Thanfully it's calming down for actual exam early next week.

[PaddyB]

Thanks Paddy,
I'll try this on Saturday - crazy busy week with Yachtmaster practical exam prep.....UK weather has been a tad interesting this week!! Thanfully it's calming down for actual exam early next week.

Good luck with the yachtmaster! Did mine not so long ago, wasn't so bad.

[DanielGoedhuis]

Thanks, a lot, Paddy1
This worked for me, having had the same issue..

[PaddyB]

Just did a fresh install on a Pi 3, openplotter dashboards only give the option of installing influxdb V2 on a 64b system but if you run ..

sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys D8FF8E1F7DF8B07E

then
sudo apt install infuxdb

it installs v1.6.7 of influxdb which seems to work fine with the signalk app.

[Sailoog]

Grafana key fixed in openplotter-dashboards 3.0.14, update it and install grafana again.

Sorry for the delay, I missed this post.

[Mitch C]

Grafana key fixed in openplotter-dashboards 3.0.14, update it and install grafana again.

Sorry for the delay, I missed this post.

Hi Sailoog  - should have added a reply to say that folowing Paddy B post, I got it working again :-)

Thanks for taking note and fixing the problem though - love your work!!!

[jtclark314]

I've been tracking this post for a few days and was just going to say the other fix didn't work anymore.  Perfect timing.  I updated to dashboard 3.0.14 and Grafana installed perfectly.  Thanks.  I second the "Love your work sentiment".  I'm getting ready to really dig into getting a pretty robust existing Zigbee system tied into OP and will have a few questions I'm sure.  Thanks for all the effort.

Jeremy
SV Osprey