Dashboards are missing after adding a user

I added an org. and user. Then I attempted to view my dashboards and they were gone.

Server / Admin / Stats shows 24 dashboards.

I saved the json file but I got a permission error while trying to upload it.

It’s seems like a permission issue but I’m the admin.

Version 5.0.4

Any ideas?

I fixed it. I noticed that the the database only had one organization but my user id was a member of organization 2.

This fixed it.

update grafana.user set org_id = 1 where id = 1 

Maybe we can add an error check that verifies that there is a group before changing it or not allowing someone to delete a group if there is a member in it. I don’t know how it happened.

Hi,

When you create a new organization you’ll automatically switch to that new organization. I guess that’s why you thought that all your dashboards was gone.

I saved the json file but I got a permission error while trying to upload it.

No idea what you mean here - did you try to import a dashboard?

A user is only active in one organization at a time. When you navigate to your profile you can switch between active organization. See http api documentation for more information.

Marcus

I have had this happen now as well. However I cannot seem to connect to the database with any tools as I normally would. I also tried SQLite command line and it tells me its not installed. I just a default install. Is there any command line i can use to do the above?

This should have been fixed in more recent versions of Grafana.