How to unlock the local Analytics user

If you have locked your analytics admin user, you can unlock him by resetting the failed attempts value, in the DB.

For it, you run the following commands on the host:

sudo su postgres

psql

\c cloud9

update users set failed_login_attempts = 0 where username = '<USERNAME_HERE>';

Or:

sudo su postgres

psql -U cloud9 -h 127.0.0.1 cloud9

(provide the cloud9 password)

update users set failed_login_attempts = 0 where username = '<USERNAME_HERE>';

In case you would like to take a backup of the database before to run the command, you can check this article.