Reset localhost user and pw

[Gassim (AL-Gassim Sharaf Addin)]

Hi @hengkiry

Welcome to the DHIS2 Community! When you installed the DHIS2 instance as a localhost, did you use the Sierra Leone demo database or an empty database? You could simply seed the database again (if it’s still an empty database or if it’s only a demo database).

However, if you have already made other changes and need to regain access, would you please try to follow the following steps (taking note of the points I will mention bellow):

@alanivey

You can create a password hash with Python and the Bcrypt library. Run this single command in your terminal to get a hash for passwordGoesHere:

$ python -c ‘import bcrypt; hash = bcrypt.hashpw(“passwordGoesHere”, bcrypt.gensalt(rounds=10, prefix=b"2a")); print(hash);’

You can insert the resulting hash directly into the database for the admin user.

Note: If you do not have the Bcrypt library in your Python installation, you should add it with pip. The following will install all prerequisites on a CentOS 6 system:

$ yum install gcc libffi-devel python-devel python-pip

$ pip install --user bcrypt

Before attempting to change the admin user password in the database, visit the front page of a new installation to have DHIS2 generate data in the database for the admin user (you can do something as simple as $ curl -sL http://localhost:8080/). Then, you can enter the following query into the Postgres CLI with the DHIS2 database in use:

UPDATE USERS SET password = ‘001122hashgoeshere221100’ WHERE username = ‘admin’;

Restart the application server (Tomcat) and then you should be able to log in with your new password passwordGoesHere or what you changed it to.

1. Instead of using UPDATE USERS SET password = ‘001122hashgoeshere221100’ WHERE username = ‘admin’; use UPDATE USERS SET password = ‘001122hashgoeshere221100’ WHERE username = ‘admin’;
2. If you don’t remember the username, you can use SELECT username FROM userinfo to list all the usernames

I hope this helps. Please do post an update after trying the above.

Thanks!