Problem with resetting password on 2.15

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

Hisp logo

Project Manager

Health Information Systems Programme

Tel: 041-367 1027

Cell: 082 374 2209

E-mail: elmarie@hisp.org

Skype: elmarie.claasen52

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

image

···

On Wed, Aug 6, 2014 at 10:28 AM, Elmarie Claasen elmarie@hisp.org 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

Project Manager

Health Information Systems Programme

Tel: 041-367 1027

Cell: 082 374 2209

E-mail: elmarie@hisp.org

Skype: elmarie.claasen52


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


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

Thanks Knut we will try this.

Regards,

Elmarie Claasen

Hisp logo

Project Manager

Health Information Systems Programme

Tel: 041-367 1027

Cell: 082 374 2209

E-mail: elmarie@hisp.org

Skype: elmarie.claasen52

···

From: Knut Staring [mailto:knutst@gmail.com]
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@hisp.org 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

Hisp logo

Project Manager

Health Information Systems Programme

Tel: 041-367 1027

Cell: 082 374 2209

E-mail: elmarie@hisp.org

Skype: elmarie.claasen52


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

Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

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).

image

···


Morten

On Wed, Aug 6, 2014 at 4:16 PM, Elmarie Claasen elmarie@hisp.org wrote:

Thanks Knut we will try this.

Regards,

Elmarie Claasen

Project Manager

Health Information Systems Programme

Tel: 041-367 1027

Cell: 082 374 2209

E-mail: elmarie@hisp.org

Skype: elmarie.claasen52

From: Knut Staring [mailto:knutst@gmail.com]

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@hisp.org 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

Project Manager

Health Information Systems Programme

Tel: 041-367 1027

Cell: 082 374 2209

E-mail: elmarie@hisp.org

Skype: elmarie.claasen52


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

Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org


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

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@gmail.com> 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@hisp.org> 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@hisp.org

Skype: elmarie.claasen52

*From:* Knut Staring [mailto:knutst@gmail.com]
*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@hisp.org> >> 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@hisp.org

Skype: elmarie.claasen52

_______________________________________________
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

--

Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

_______________________________________________
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

--
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org

Hi Morten,

Thanks will send this to our system admin to run and get back to you if it works.

Renier,

Please run and give feedback

Elmarie Claasen
HISP

Cell 0823742209

Tel 0413640757

···


Morten

On Wed, Aug 6, 2014 at 4:16 PM, Elmarie Claasen elmarie@hisp.org wrote:

Thanks Knut we will try this.

Regards,

Elmarie Claasen

<image001.png>

Project Manager

Health Information Systems Programme

Tel: 041-367 1027

Cell: 082 374 2209

E-mail: elmarie@hisp.org

Skype: elmarie.claasen52

From: Knut Staring [mailto:knutst@gmail.com]

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@hisp.org 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

<image001.png>

Project Manager

Health Information Systems Programme

Tel: 041-367 1027

Cell: 082 374 2209

E-mail: elmarie@hisp.org

Skype: elmarie.claasen52


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

Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org


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

Renier,

See below

Elmarie Claasen
HISP
Cell 0823742209
Tel 0413640757

···

On 08 Aug 2014, at 11:39 AM, Knut Staring <knutst@gmail.com> 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@gmail.com> 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@hisp.org> 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@hisp.org

Skype: elmarie.claasen52

*From:* Knut Staring [mailto:knutst@gmail.com]
*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@hisp.org> >>> 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@hisp.org

Skype: elmarie.claasen52

_______________________________________________
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

--

Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

_______________________________________________
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

--
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org