dhis2 admin password is lockout or was changed

Dear Support,

I installed dhis2 in one of our regional servers after a few months now they came with it for maintenance. I am trying to login as admin but it is telling me wrong username or password. I had tried to copy another user’s encrypted password for the postregsql and replace that of the admin but it is still not working.

Can some help with this issue? How am I going to get my admin user again please

Thanks in advance.

···

Sent from Windows Mail

Hi Gerald,
That is not going to work. The encrypted password has been “salted” with the username, and so it is not possible to copy and paste from another users password.

If you still have the “admin” user in your system, you can execute

UPDATE users set password = ‘48e8f1207baef1ef7fe478a57d19f2e5’ where username = admin;

and the password will be reset to the default “district” password.

If you do not have that user in the system, you would need to add some user who has superuser access to the “userrolemembers” table.

Good luck,

Jason

···

On Thu, Oct 3, 2013 at 10:37 AM, Gerald Thomas gerald.81@hotmail.com wrote:

Dear Support,

I installed dhis2 in one of our regional servers after a few months now they came with it for maintenance. I am trying to login as admin but it is telling me wrong username or password. I had tried to copy another user’s encrypted password for the postregsql and replace that of the admin but it is still not working.

Can some help with this issue? How am I going to get my admin user again please

Thanks in advance.

Sent from Windows Mail


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp