In case you have forgotten the root admin password, you can reset it by removing all users, organisation and invites from the SQLite database.
Starting from v0.76.0, multiple services (Query Service, Frontend, and Alertmanager) have been merged into a single signoz binary/image. Please follow the steps below based on your SigNoz version.
The guide mainly covers the following:
- Exec into the
signozcontainer - Remove all users, organisation and invites using SQLite shell
- Restart the
signozcontainer
Exec into signoz Container
Docker Standalone
docker exec -it signoz-signoz sh
Docker Swarm
docker exec -it $(docker ps -q -f name=signoz_signoz) sh
Replace signoz with your Docker stack name.
Kubernetes
kubectl -n platform exec -it pod/my-release-signoz-signoz-0 -- sh
Replace my-release with your Helm release name. And platform with your SigNoz namespace.
Steps to Remove All Users, Organisation and Invites
Step 1: Install SQLite and Connect to the Database File
apk update
apk add sqlite
sqlite3 /var/lib/signoz/signoz.db
Step 2: Remove All Users and Organisation
In the sqlite shell, run the following commands:
select * from users;
select * from organizations;
select * from invites;
delete from users;
delete from organizations;
delete from invites;
Step 3: Verify the Users, Organisation and Invites are Removed
select * from users;
select * from organizations;
select * from invites;
Step 4: Exit from SQLite Shell and Container Shell
To exit from the sqlite shell, press CTRL + D and then exit from the signoz container.
Step 5: Restart the signoz-signoz Container
To restart the signoz container, run the following command:
For Docker Users
docker restart signoz-signoz
For Docker Swarm Users
docker service update --force signoz_signoz
For Kubernetes Users
kubectl -n platform rollout restart statefulset/my-release-signoz-signoz
Now, you should be able to create a new admin account from SigNoz UI: http://localhost:3301.
The guide mainly covers the following:
- Exec into the
query-servicecontainer - Remove all users, organisation and invites using SQLite shell
- Restart the
query-servicecontainer
Exec into query-service Container
Docker Standalone
docker exec -it signoz-query-service sh
Docker Swarm
docker exec -it $(docker ps -q -f name=signoz_query-service) sh
Replace signoz with your Docker stack name.
Kubernetes
kubectl -n platform exec -it pod/my-release-signoz-query-service-0 -- sh
Replace my-release with your Helm release name. And platform with your SigNoz namespace.
Steps to Remove All Users, Organisation and Invites
Step 1: Install SQLite and Connect to the Database File
apk update
apk add sqlite
sqlite3 /var/lib/signoz/signoz.db
Step 2: Remove All Users and Organisation
In the sqlite shell, run the following commands:
select * from users;
select * from organizations;
select * from invites;
delete from users;
delete from organizations;
delete from invites;
Step 3: Verify the Users, Organisation and Invites are Removed
select * from users;
select * from organizations;
select * from invites;
Step 4: Exit from SQLite Shell and Container Shell
To exit from the sqlite shell, press CTRL + D and then exit from the query-service container.
Step 5: Restart the signoz-query-service Container
To restart the query-service container, run the following command:
For Docker Users
docker restart signoz-query-service
For Docker Swarm Users
docker service update --force signoz_query-service
For Kubernetes Users
kubectl -n platform rollout restart statefulset/my-release-signoz-query-service
Now, you should be able to create a new admin account from SigNoz UI: http://localhost:3301.
