Hello @albertodrago

To unlock your user use this command:

UPDATE users SET login_attempts = 0 WHERE user_name = 'your username';

To reset your password use the tutorial above. It's important that you can't use your new password directly here. You have to use the same command as above which includes the password wavelog as hash.

UPDATE users SET user_password = '$2y$10$X27rnGP4c.h8Ov5cvHR.xeFlYuEXJgHBDNuuxII2PMlLEoRuWVx.2' WHERE user_name = 'your username';

Then you can login using the password wavelog. You have to change your password afterwards in the WebUI

Solved!
many thanks for support !!
i hope see you on air

Regards
Alberto

Sure:

docker exec -it wavelog-db mariadb -u wavelog -p wavelog -e "UPDATE users SET user_password = '$2y$10$X27rnGP4c.h8Ov5cvHR.xeFlYuEXJgHBDNuuxII2PMlLEoRuWVx.2' WHERE user_name = 'your username';"

Then you can login using the password wavelog. You have to change your password afterwards in the WebUI

This will ask you for the database password. If you don't know anymore you can find the password in your docker-compose.yml

Wow you responded quickly! As it turns out, I was experimenting in the background before I even saw your response and actually ended up at the same conclusion you shared, so thank you :)

What's interesting is I reset the password, then was greeted with the "account lockout" error. I resolved that with the steps you shared above, and then the reset password took effect. So the summary of what I did was:

1. Open a terminal into my wavelog-db docker container with the command docker exec -it wavelog-db /bin/bash
2. Within this terminal, I issued the command mariadb --user=MY_MARIADB_USER --pasword=MY_MARIADB_PASSWORD wavelog to enter the MariaDB CLI - it wasn't aliased to mysql, so that explains why those instructions didn't work initially for me.
3. I performed the password reset with the hashed wavelog password as instructed using the command: UPDATE users SET user_password = '$2y$10$X27rnGP4c.h8Ov5cvHR.xeFlYuEXJgHBDNuuxII2PMlLEoRuWVx.2' WHERE user_name = 'MY_USERNAME';. Successful output is:

Query OK, 1 row affected (0.007 sec)
Rows matched: 1  Changed: 1  Warnings: 0

4. I tried logging in, but was greeted with the account lockout error message ("Your account is locked due to too many failed login-attempts. Please reset your password."). I resolved this by following the instructions to unlock the account with UPDATE users SET login_attempts = 0 WHERE user_name = 'MY_USERNAME;. Successful output is:

Query OK, 1 row affected (0.003 sec)
Rows matched: 1  Changed: 1  Warnings: 0

5. Finally, I logged into Wavelog using MY_USERNAME and the password wavelog, which I'm happy to report worked perfectly!

Had I seen your response sooner, I probably could've combined this into one step, so thank you for sharing that, and thank you for answering my query so quickly - 73!