Unable to connect to Grafana anymore

Hey guys,

I was looking on how Grafana handle hash generation via the source-code and I wanted to try something by modifying the admin password.
I used this method with the sqlite base since the grafana-cli still return an error.
But after deleting the the admin user from the base (as I’ve already done in the past when loosing the password, Grafana should just ask to reset my password!), I’m not able to connect to my interface with default credential anymore:


I had a backup of my user in the base, but if I manually add the user in the base and restart the service, I only have access to the setting of Grafana and the user, not the dashboard/connections etc.
image

I though of a permissions issue for the user, but I can’t see why since it’s the exact same line as the original (except for the id ofc). Since I’m not very used to sqlite I’m kinda block with:

  • an empty dashboard UI
  • invalid credentials

Update:
By modifying the ID of the admin user in the base and set it lower than the sa-adding-a-var (which I use to connect via the API from external server) give me back a full access.
Can someone explain me what happen here? I’m kinda lost…

you were hacking by manipulating the sqlite db manually (unrecommended) and you got bittten

not sure anyone would be able to help you on a hack.