dhis2-live password

Support - Assistance technique
1

Hi Majed,

Redirecting to dhis2-users.

There was a thread on this topic in August:

https://www.mail-archive.com/dhis2-users@lists.launchpad.net/msg07385.html

Regards,

Knut

···

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

2

Are you using dhis live with the built in h2 database or did you
configure a postgres connection? You are going to have to "poke" in
the password hash directly into the database.

···

On 16 November 2015 at 14:47, Knut Staring <knutst@gmail.com> wrote:

Hi Majed,

Redirecting to dhis2-users.

There was a thread on this topic in August:
https://www.mail-archive.com/dhis2-users@lists.launchpad.net/msg07385.html

Regards,
Knut

---------- Forwarded message ----------
From: Dir Malaria <malaria.om.dir@gmail.com>
Date: Mon, Nov 16, 2015 at 9:27 AM
Subject: dhis2-live password
To: experts@dhis2.org

Dear Experts,

I am using dhis2-live on my MacBook and worked on data elements and
managed to install dhis2 on my desktop with Ubuntu 15.10. Now I would like
to export my data elements from my MacBook to my desktop, but I have forgot
the password of the admin account which I have changed from "district".
Is there a way to retrieve my password?

Best regards,

Majed

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

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

3

Also which dhis version are you using?

···

On 16 November 2015 at 15:38, Bob Jolliffe <bobjolliffe@gmail.com> wrote:

Are you using dhis live with the built in h2 database or did you
configure a postgres connection? You are going to have to "poke" in
the password hash directly into the database.

On 16 November 2015 at 14:47, Knut Staring <knutst@gmail.com> wrote:

Hi Majed,

Redirecting to dhis2-users.

There was a thread on this topic in August:
https://www.mail-archive.com/dhis2-users@lists.launchpad.net/msg07385.html

Regards,
Knut

---------- Forwarded message ----------
From: Dir Malaria <malaria.om.dir@gmail.com>
Date: Mon, Nov 16, 2015 at 9:27 AM
Subject: dhis2-live password
To: experts@dhis2.org

Dear Experts,

I am using dhis2-live on my MacBook and worked on data elements and
managed to install dhis2 on my desktop with Ubuntu 15.10. Now I would like
to export my data elements from my MacBook to my desktop, but I have forgot
the password of the admin account which I have changed from "district".
Is there a way to retrieve my password?

Best regards,

Majed

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

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

4

OK so you will have to get access to the h2 database. Best to close
down the dhis-live server first. Then from the commandline you can
do:

java -cp webapps/dhis/WEB-INF/lib/h2-*.jar org.h2.tools.Shell -url
jdbc:h2:./database/dhis2 -user sa

that will get you connected. Note this assumes that the current
working directory is in your dhis-live folder. From there you can
update the password hash. On the latest dhis-live (which I just
downloaded) it is:

update users set

password='$2a$10$ZnK2hycBfMOL9WNtzpp18.jKuWXRW4ubdWew6ckQNw7NBESjtXdFe'
where username='admin';

If you have an older dhis version then it will be using the older MD5
based hash, in which case you need:

UPDATE users set password = '48e8f1207baef1ef7fe478a57d19f2e5'
where username = 'admin';

Exit the console and restart dhis-live.

Good luck
Bob

···

On 17 November 2015 at 05:10, Dir Malaria <malaria.om.dir@gmail.com> wrote:

I am using dhis-live with H2 version 2.2

On Mon, Nov 16, 2015 at 7:40 PM, Bob Jolliffe <bobjolliffe@gmail.com> wrote:

Also which dhis version are you using?

On 16 November 2015 at 15:38, Bob Jolliffe <bobjolliffe@gmail.com> wrote:
> Are you using dhis live with the built in h2 database or did you
> configure a postgres connection? You are going to have to "poke" in
> the password hash directly into the database.
>
> On 16 November 2015 at 14:47, Knut Staring <knutst@gmail.com> wrote:
>> Hi Majed,
>>
>> Redirecting to dhis2-users.
>>
>> There was a thread on this topic in August:
>>
>> https://www.mail-archive.com/dhis2-users@lists.launchpad.net/msg07385.html
>>
>> Regards,
>> Knut
>>
>> ---------- Forwarded message ----------
>> From: Dir Malaria <malaria.om.dir@gmail.com>
>> Date: Mon, Nov 16, 2015 at 9:27 AM
>> Subject: dhis2-live password
>> To: experts@dhis2.org
>>
>>
>> Dear Experts,
>>
>> I am using dhis2-live on my MacBook and worked on data elements and
>> managed to install dhis2 on my desktop with Ubuntu 15.10. Now I would
>> like
>> to export my data elements from my MacBook to my desktop, but I have
>> forgot
>> the password of the admin account which I have changed from "district".
>> Is there a way to retrieve my password?
>>
>> Best regards,
>>
>> Majed
>>
>>
>>
>>
>>
>>
>> --
>> Knut Staring
>> Dept. of Informatics, University of Oslo
>> Norway: +4791880522
>> Skype: knutstar
>> http://dhis2.org
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help : https://help.launchpad.net/ListHelp
>>