Hi Gerald, 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. Regards, Alan On Mon, Aug 31, 2015 at 11:02 AM, gerald thomas <gerald17...@gmail.com> wrote: > Dear all, > I am setting up a training server for staff and i am using dhis2 live > to achieve the task but i am using one of our database rather than the > default database. I had already used the following query to change the > admin password: > > UPDATE users set password = '48e8f1207baef1ef7fe478a57d19f2e5' > where username = 'admin'; > > What am i doing which is wrong and why i can't login with username: > admin password: district > > -- > Regards, > > Gerald > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp