Apologies in advance, my knowledge is quite limited.
Installed Grafana on a RPI2, and at first login mechanically created a new user with a new password and deleted the default Admin.
Issue now is the user I created does not have admin authorisation, and I have lost the ability to login as Admin!
Tried the following: Purged and uninstalled Grafana: this does not seem to clean the user database so I have the same issue regardless of the version of Grafana installed (only one “basic” user, no admin user).
Tried to modify /etc/grafana/grafana.ini to set admin/admin authorisation as default, but it does not seem to create an admin user.
Tried to run grafana-cli admin reset-admin-password --homepath “/usr/share/grafana” newpass
But get the following error:
INFO[12-15|12:41:07] Initializing DB logger=sqlstore dbtype=sqlite3
INFO[12-15|12:41:07] Starting DB migration logger=migrator
EROR[12-15|12:41:07] Fail to initialize orm engine logger=sqlstore error=“Sqlstore::Migration failed err: unable to open database file\n”
- thinking about running the HTTP API command to “boost” my basic user to admin level, but no idea on how to run the script from Linux shell…:
PUT /api/admin/users/2/permissions HTTP/1.1
Any help would be greatly appreciated!