dhis2-users team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

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:

sql> 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@xxxxxxxxx> wrote:
> I am using dhis-live with H2 version 2.2
>
> On Mon, Nov 16, 2015 at 7:40 PM, Bob Jolliffe <bobjolliffe@xxxxxxxxx> wrote:
>>
>> Also which dhis version are you using?
>>
>> On 16 November 2015 at 15:38, Bob Jolliffe <bobjolliffe@xxxxxxxxx> 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@xxxxxxxxx> wrote:
>> >> Hi Majed,
>> >>
>> >> Redirecting to dhis2-users.
>> >>
>> >> There was a thread on this topic in August:
>> >>
>> >> https://www.mail-archive.com/dhis2-users@xxxxxxxxxxxxxxxxxxx/msg07385.html
>> >>
>> >> Regards,
>> >> Knut
>> >>
>> >> ---------- Forwarded message ----------
>> >> From: Dir Malaria <malaria.om.dir@xxxxxxxxx>
>> >> Date: Mon, Nov 16, 2015 at 9:27 AM
>> >> Subject: dhis2-live password
>> >> To: experts@xxxxxxxxx
>> >>
>> >>
>> >> 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@xxxxxxxxxxxxxxxxxxx
>> >> Unsubscribe : https://launchpad.net/~dhis2-users
>> >> More help   : https://help.launchpad.net/ListHelp
>> >>
>
>