Grafana admin log in failing after upgrade

Grafana Installation
1

Grafana version: 7.0.5
RHEL 7.5

When I try to log into grafana with the admin credentials (admin:admin) I get the error ‘invalid username or password’.
I’ve tried root:admin, admin:root, root:root.
in /etc/grafana/grafana.ini & /usr/share/grafana/conf/defaults.ini
[security]
admin_user = admin
admin_password = admin

I’ve also set;
grafana-cli --homepath “/usr/share/grafana” --config "/usr/share/grafana/conf/defaults.ini’ admin reset-admin-password admin

and

grafana-cli --homepath “/usr/share/grafana” --config "/etc/grafana/grafana.ini’ admin reset-admin-password admin

I’ve also tried changing the password using sqlite3 /var/lib/grafana/granana.db
Also changed in both the .ini files, the location of the DB to be direct & left as default

With no luck.

If I use an account which I set up before my upgrade;

/var/log/grafana/grafana.log
error msg= ‘Error while signing in user’ error= 'failed to create auth token: attempt to write to a readonly database"

So the grafana.db were wr/r/r so I created a backup of the db, then changed to 777 to see if that would at least work. But no luck, I also deleted the copy of the db but same error.

and finally I’ve tried reinstalling Grafana (I also restarted grafana after each change)

Any ideas?

2

Hey,
Could you make sure that the directory containing your db file is writable for the user?

3

Also, may be you’ll find this SO answer helpful.

4

Hey rvrs - unfortunately neither of those worked. Still having drama with;
error msg= ‘Error while signing in user’ error= 'failed to create auth token: attempt to write to a readonly database"

1 Like
5

I gave up trying to keep the old database and wiped everything grafana related and started again. Issue resolved =)