Update docs for scenario when admins have lost password

[pranay01]

You can exec inside query-service container and remove all users and organisations: docker exec -it query-service sh OR

kubectl -n platform exec -it pod/my-release-signoz-query-service-0 -- sh Run the following:

# install sqlite
apk update
apk add sqlite

# open sqlite with signoz.db
sqlite3 /var/lib/signoz/signoz.db

# (sqlite shell) check existing users
select * from users;

# (sqlite shell) delete all users
delete from users where 1=1;

# (sqlite shell) verify user deletion
select * from users;

# (sqlite shell) check existing organizations
select * from organizations;

# (sqlite shell) delete organizations
delete from organizations where 1=1;

# (sqlite shell) verify org deletion
select * from organizations;

# press CTRL + D to exit from sqlite shell
# safely exit from the query-service container
exit

After that you should be able to create a new admin account from SigNoz UI.

[prashant-shahi]

This would be a hacky solution. We would need to iterate over login/auth flow instead.

[Calm-Rock]

@pranay01 @prashant-shahi is this issue resolved ?

[pranay01]

No resolved AFAIK. Let it remain open