← Back to team overview

dhis2-devs team mailing list archive

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