dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #32021
Re: Problem with resetting password on 2.15
Renier,
See below
Elmarie Claasen
HISP
Cell 0823742209
Tel 0413640757
> On 08 Aug 2014, at 11:39 AM, Knut Staring <knutst@xxxxxxxxx> wrote:
>
> To be even more explicit, you could try also running the following SQL query:
>
> update users set passwordlastupdated = '2014-08-08'
>
>> On 8/8/14, Morten Olav Hansen <mortenoh@xxxxxxxxx> wrote:
>> Hi Elmarie,
>>
>> Did you try this again? did you manage to get it working? We have had
>> reports of this happening one time before, but I could never reproduce it
>> here locally.. Could you tell me more about your setup? exact dhis version,
>> browser, did you clear the cache etc.
>>
>> Did the column users.passwordlastupdated get updated?
>>
>> If this happens, and locks people out, probably the simplest solution is to
>> simple set passwordlastupdated to todays date (but please try on test
>> server).
>>
>> --
>> Morten
>>
>>
>>> On Wed, Aug 6, 2014 at 4:16 PM, Elmarie Claasen <elmarie@xxxxxxxx> wrote:
>>>
>>> Thanks Knut we will try this.
>>>
>>>
>>>
>>> Regards,
>>>
>>>
>>>
>>> *Elmarie Claasen*
>>>
>>> [image: Hisp logo]
>>>
>>> Project Manager
>>>
>>> Health Information Systems Programme
>>>
>>> Tel: 041-367 1027
>>>
>>> Cell: 082 374 2209
>>>
>>> E-mail: elmarie@xxxxxxxx
>>>
>>> Skype: elmarie.claasen52
>>>
>>>
>>>
>>> *From:* Knut Staring [mailto:knutst@xxxxxxxxx]
>>> *Sent:* 06 August 2014 10:41 AM
>>> *To:* Elmarie Claasen
>>> *Cc:* DHIS 2 developers
>>> *Subject:* Re: [Dhis2-devs] Problem with resetting password on 2.15
>>>
>>>
>>>
>>> Hi Elmarie,
>>>
>>> This is just a partial solution, but hopefully will restore your access
>>> to
>>> the system. Assuming you have direct access to the database (on the
>>> command
>>> line or through PgAdmin), you can run the following:
>>>
>>>
>>>
>>> update users set password = '48e8f1207baef1ef7fe478a57d19f2e5' where
>>> username = 'admin'
>>>
>>>
>>>
>>> This should enable you to log in with the default admin/district. But of
>>> course you should then proceed to change this password.
>>>
>>>
>>>
>>> Knut
>>>
>>>
>>>
>>> On Wed, Aug 6, 2014 at 10:28 AM, Elmarie Claasen <elmarie@xxxxxxxx>
>>> wrote:
>>>
>>> Hi all,
>>>
>>>
>>>
>>> We have a problem with a database in which we activated the option that
>>> passwords must be reset every x months.
>>>
>>>
>>>
>>> Suddenly all of the Superusers are getting a message to reset the
>>> password
>>> which you follow and ‘save’ but saving does not log you into the
>>> database.
>>> When you go back to the login screen try to log in with the new password
>>> it
>>> says incorrect password because it evidently did not save the password.
>>> When you use the old password you simply get the same message to change
>>> your password.
>>>
>>>
>>>
>>> The database is on 2.15.
>>>
>>>
>>>
>>> We are now effectively logged out of the database – please help!
>>>
>>>
>>>
>>>
>>>
>>> Regards,
>>>
>>>
>>>
>>> *Elmarie Claasen*
>>>
>>> [image: Hisp logo]
>>>
>>> Project Manager
>>>
>>> Health Information Systems Programme
>>>
>>> Tel: 041-367 1027
>>>
>>> Cell: 082 374 2209
>>>
>>> E-mail: elmarie@xxxxxxxx
>>>
>>> Skype: elmarie.claasen52
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help : https://help.launchpad.net/ListHelp
>>>
>>>
>>>
>>>
>>>
>>> --
>>>
>>> Knut Staring
>>>
>>> Dept. of Informatics, University of Oslo
>>>
>>> +4791880522
>>>
>>> http://dhis2.org
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help : https://help.launchpad.net/ListHelp
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> +4791880522
> http://dhis2.org
References