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