Lost Passwords?

[lithium-ap]

We've lost our Statping admin password running in docker, is there a way to recover?

[davidak]

i guess it's saved in the database

[Threnklyn]

what kind of db do you use?
since the password is saved in the users table you can set it manually.

sqlite3 statping.db
select * from users;
update users set password="$2a$04$dWW2urchVFKum3iD/zYPaO1I5sYp7WiHxkXgDwPgPsmtVT99P5sTG" where id=1;

would replace the current password in a sqlite-db with the password "admin".
Change the id to the id of your user

[l0nax]

I'm closing this issue since it seems that it has been resolved.
Feel free to re-open it if the issue still persists.

[adamboutcher]

what kind of db do you use? since the password is saved in the users table you can set it manually.

sqlite3 statping.db
select * from users;
update users set password="$2a$04$dWW2urchVFKum3iD/zYPaO1I5sYp7WiHxkXgDwPgPsmtVT99P5sTG" where id=1;

would replace the current password in a sqlite-db with the password "admin". Change the id to the id of your user

FYI for anyone googling, for postgres...

su - postgres
psql -u statping_user statping
> select * from users;
> update users set password='$2a$04$dWW2urchVFKum3iD/zYPaO1I5sYp7WiHxkXgDwPgPsmtVT99P5sTG' where id=1;
> ```

Postgres needs single quotes and not double.