dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

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