dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Oh, and sorry, I forgot the quotes...

UPDATE users set password = '48e8f1207baef1ef7fe478a57d19f2e5' where
username = 'admin';


On Thu, Oct 3, 2013 at 10:58 AM, Gerald Thomas <gerald.81@xxxxxxxxxxx>wrote:

> Dear Jason,
> Thanks for your help. Actually I have the user admin but it was the
> password that was changed. I will be using your procedure and revert back
> to you with the result. Thanks once again.
> Sent from my BlackBerry® smartphone from Airtel Sierra Leone
>
> -----Original Message-----
> From: Jason Pickering <jason.p.pickering@xxxxxxxxx>
> Date: Thu, 3 Oct 2013 08:54:07
> To: <gerald.81@xxxxxxxxxxx>
> Cc: <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
> Subject: Re: [Dhis2-devs] dhis2 admin password is lockout or was changed
>
>
> 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@xxxxxxxxxxx<mailto:
> gerald.81@xxxxxxxxxxx> > 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@xxxxxxxxxxxxxxxxxxx <mailto:
> dhis2-devs@xxxxxxxxxxxxxxxxxxx>
>  Unsubscribe : https://launchpad.net/~dhis2-devs
>  More help   : https://help.launchpad.net/ListHelp
>