fetzerch / grafana-sunandmoon-datasource

SunAndMoon is a datasource plugin for Grafana that calculates the position of Sun and Moon as well as the Moon illumination. ☀️🌙🧛‍♂️
MIT License
41 stars 8 forks source link

Plugin fails to load with Grafana 8.0 (403 Forbidden Instantiating / no installed plugin with that id) #45

Closed lolax80 closed 3 years ago

lolax80 commented 3 years ago

I have installed per cli in docker on Grafana 8.0.6

On plugins the plugin doesn't start, its hangs on loading. on data source under sun and moon there comes

Fetch error: 403 Forbidden Instantiating http://192.168.69.2:3000/public/plugins/fetzerch-sunandmoon-datasource/module.js Loading plugins/fetzerch-sunandmoon-datasource/module

if I click on delete data source there is Missing valid datasource id

if I uninstall the plugin, the datasource is still there but I can't delete it, because auf missing id

MikeyMikeDO commented 3 years ago

It would be very nice to get the plugin working with Grafana > 8.0. Many users use this plugin for visualize their solar system. I need to go back to grafana 7 because it´s essential.

fetzerch commented 3 years ago

@MikeyMikeDO I've played around with different Grafana and plugin versions trying to reproduce your problem, but unfortunately I can't. It's working perfectly fine here, even on 8.1.

Did you try to remove the local plugin installation directory and try reinstalling as described in https://github.com/fetzerch/grafana-sunandmoon-datasource/issues/44?

MikeyMikeDO commented 3 years ago

Last time i tried everything possible. I thought it's an known problem on grafana >=8.0. As soon as possible i will try iit again and give you a more detailed feedback.

lolax80 commented 3 years ago

same issue on 8.1 I can't delete the data source from the plugin. I used grafana-cli plugins remove an also deleted the plugin folder but the datasource is still there. I can remove the plugin. if I reinstall the plugin with cli or copy the folder and restart, the plugin is in Grafana, but without an icon an it does not start

Ohne Titel Ohne Titel 2

fetzerch commented 3 years ago

I'd need more information and exact steps to reproduce. Is this a fresh install of Grafana or an Upgrade? Can you try moving away the Grafana data directory just to see if it's caused by older data laying around? What OS are you running Grafana on?

lolax80 commented 3 years ago

Hi it is an existing Grafana, I updated to 8.1. It is on docker on an synology nas.

First I install with grafana-cli plugins install fetzerch-sunandmoon-datasource, and the folder is under plugins

`bash-5.1$ grafana-cli plugins install fetzerch-sunandmoon-datasource
✔ Downloaded fetzerch-sunandmoon-datasource v0.2.1 zip successfully

Please restart Grafana after installing plugins. Refer to Grafana documentation for instructions if necessary.

bash-5.1$ `

After the restart I can find the plugin under plugins, but with no image an if click on it it doesn't start Ohne Titel 2

Ohne Titel

fetzerch commented 3 years ago

Ok, it might be that you have some remaining datasource settings in your grafana db. Unfortunately there's no user friednly way to access or delete them. But I'd be very interested to see what exactly is in there.

Do you have a way to run 'sqlite3' on the nas? Or copy the database file ('/var/lib/grafana/grafana.db') and access it from another machine. Then either 'sqlite3' or any other sqlite client would do (for example https://github.com/sqlitebrowser/sqlitebrowser). I'd need to see the content of the data_source table:

sudo sqlite3 /var/lib/grafana.db, then `SELECT * FROM data_source;"

lolax80 commented 3 years ago

Kannst Du mir helfen? can you help me? what should I do in sqlitebrowser

lolax80 commented 3 years ago

image

image

lolax80 commented 3 years ago

now I have deleted with the sqlitebrowser the data_source fetzerch. but the plugin doesn't start either

fetzerch commented 3 years ago

Hm, really poking in the dark here. The database entry didn't really look wrong.

Is there anything suspicious regarding the plugin in the grafana log?

lolax80 commented 3 years ago

Now i have deleted the data source with the sql Browser and installed the Plugin new. The Plugin doesnt start and there is Not datasource any More. I Think it is a Problem with the start of the plugin. Where is the log from grafana, Home to Listen the start of the Plugin

fetzerch commented 3 years ago

In the meantime I found this issue in Grafana: https://github.com/grafana/grafana/issues/36563 (will be fixed in 8.1.2). Apparently Grafana doesn't allow files that have the x-permission-bit set, which can happen on some filesystems. There's a synology user affected, maybe this is it.

Could you try executing:

find /var/lib/grafana/plugins/fetzerch-sunandmoon-datasource/ -type f -exec chmod -x {} +

Then restart Grafana?

edit: Log should be in /var/log/grafana

MikeyMikeDO commented 3 years ago

Hi. Only for your Info: I also use Grafana in Docker on a Synology NAS. Before sunday i can´t test it again.

lolax80 commented 3 years ago

Hello,

with find /var/lib/grafana/plugins/fetzerch-sunandmoon-datasource/ -type f -exec chmod -x {} +

everything is working now

thanks

MikeyMikeDO commented 3 years ago

I tested everything before reading here. The chmod works also for me. Everything is fine again. Thank you.

fetzerch commented 3 years ago

Thanks for confirmation, closing this issue then. One Grafana 8.1.2 is released, the chmod workaround should no longer be necessary.