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!
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!
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!
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:
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!
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!
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!
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!