I accidentally disabled my admin user login

Grafana Configuration
1

Hello, I accidentally disabled my admin user login in the users section of Grafana. Now I can no longer log into Grafana. Unauthorized login error appears on the login page. Is there any possibility to enable my login again through my server? I’m using an Oracle Cloud estance with Linux, Ubuntu 22.04 distribution, with Grafana OSS 10.3.3.

Any help will be greatly appreciated

Grafana Log File

logger=ngalert.sender.router rule_uid=a8bb1019-0816-4022-a890-e2e714886abe org_id=1 t=2024-07-01T00:00:00.018003121Z level=info msg="Sending ale>
logger=ngalert.sender.router rule_uid=be44cafd-7530-414e-9ae9-ee35b83db6e1 org_id=5 t=2024-07-01T00:00:02.541082002Z level=info msg="Sending ale>
logger=ngalert.sender.router rule_uid=c98e138a-e3ac-43b8-9e41-acc4f56c8d2d org_id=5 t=2024-07-01T00:00:05.031412231Z level=info msg="Sending ale>
logger=ngalert.sender.router rule_uid=c6a01517-6b5a-4930-9456-c39af710a04e org_id=1 t=2024-07-01T00:00:07.529086483Z level=info msg="Sending ale>
logger=ngalert.sender.router rule_uid=a8bb1019-0816-4022-a890-e2e714886abe org_id=1 t=2024-07-01T00:02:00.017457397Z level=info msg="Sending ale>
logger=cleanup t=2024-07-01T00:02:01.41504839Z level=info msg=“Completed cleanup jobs” duration=4.189376ms
logger=grafana.update.checker t=2024-07-01T00:02:02.161118843Z level=info msg=“Update check succeeded” duration=157.603343ms
logger=plugins.update.checker t=2024-07-01T00:02:02.190886708Z level=info msg=“Update check succeeded” duration=189.026044ms
logger=ngalert.sender.router rule_uid=be44cafd-7530-414e-9ae9-ee35b83db6e1 org_id=5 t=2024-07-01T00:02:02.519290518Z level=info msg="Sending ale>
logger=ngalert.sender.router rule_uid=c98e138a-e3ac-43b8-9e41-acc4f56c8d2d org_id=5 t=2024-07-01T00:02:05.017232739Z level=info msg="Sending ale>
logger=ngalert.sender.router rule_uid=c6a01517-6b5a-4930-9456-c39af710a04e org_id=1 t=2024-07-01T00:02:07.51904428Z level=info msg="Sending aler>
logger=infra.usagestats t=2024-07-01T00:03:22.35264602Z level=info msg=“Usage stats are ready to report”
logger=ngalert.sender.router rule_uid=be44cafd-7530-414e-9ae9-ee35b83db6e1 org_id=5 t=2024-07-01T00:04:00.019998828Z level=info msg="Sending ale>
logger=ngalert.notifier.alertmanager 4=(MISSING) t=2024-07-01T00:04:00.817106919Z level=error component=alertmanager orgID=1 component=dispatche>
logger=ngalert.sender.router rule_uid=c98e138a-e3ac-43b8-9e41-acc4f56c8d2d org_id=5 t=2024-07-01T00:04:02.519023154Z level=info msg="Sending ale>
logger=ngalert.sender.router rule_uid=c6a01517-6b5a-4930-9456-c39af710a04e org_id=1 t=2024-07-01T00:04:05.019472385Z level=info msg="Sending ale>
logger=ngalert.sender.router rule_uid=a8bb1019-0816-4022-a890-e2e714886abe org_id=1 t=2024-07-01T00:04:07.518943769Z level=info msg="Sending ale>
logger=ngalert.notifier.alertmanager 4=(MISSING) t=2024-07-01T00:04:08.198169841Z level=error component=alertmanager orgID=1 component=dispatche>
logger=ngalert.sender.router rule_uid=a8bb1019-0816-4022-a890-e2e714886abe org_id=1 t=2024-07-01T00:06:00.019950235Z level=info msg="Sending ale>
logger=ngalert.sender.router rule_uid=be44cafd-7530-414e-9ae9-ee35b83db6e1 org_id=5 t=2024-07-01T00:06:02.521408709Z level=info msg="Sending ale>
logger=ngalert.sender.router rule_uid=c98e138a-e3ac-43b8-9e41-acc4f56c8d2d org_id=5 t=2024-07-01T00:06:05.026402919Z level=info msg="Sending ale>
logger=ngalert.sender.router rule_uid=c6a01517-6b5a-4930-9456-c39af710a04e org_id=1 t=2024-07-01T00:06:07.518176678Z level=info msg="Sending ale>
logger=ngalert.sender.router rule_uid=a8bb1019-0816-4022-a890-e2e714886abe org_id=1 t=2024-07-01T00:08:00.02617642Z level=info msg="Sending aler>
logger=ngalert.sender.router rule_uid=be44cafd-7530-414e-9ae9-ee35b83db6e1 org_id=5 t=2024-07-01T00:08:02.52057852Z level=info msg="Sending aler>
logger=ngalert.sender.router rule_uid=c98e138a-e3ac-43b8-9e41-acc4f56c8d2d org_id=5 t=2024-07-01T00:08:05.019242264Z level=info msg="Sending ale>

2
3

I have already changed the administrator password; my problem is authorization to access Grafana. I did not forget the password; I accidentally disabled my administrator user in the Grafana user section.

4

if you using grafana cloud, just log a ticket

5

[quote=“k2xttechnology, post:1, topic:125193”]
I’m using an Oracle Cloud estance with Linux, Ubuntu 22.04 distribution, with Grafana OSS 10.3.3.
[/quote]I’m using an Oracle Cloud estance with Linux, Ubuntu 22.04 distribution, with Grafana OSS 10.3.3.

6

you can try from the backend…

install sqlite3 binaries

connect to your db:
sqlite3 /var/lib/grafana/grafana.db

select from the user table to see the field to update for disabled user, then update it,

7

I can think of these options:

Option 1: Connect to Grafana Database and update the is_disabled’s value to 0, for SQLite database the query will look like this

UPDATE user
SET is_disabled = 0
WHERE login = ‘admin’;

Option 2: Use Grafana APIs if you have access to that using Grafana auth token.

1 Like