Are you sure? because its complaining about something we removed a long time ago (ou.active)
-- Morten On Tue, Sep 15, 2015 at 5:23 PM, Mugeni Harold <hmug...@gmail.com> wrote: > Hi Morten, > > > > I am already using the latest of both the dhis2 and the sample database. > > > > *From:* Morten Olav Hansen [mailto:morte...@gmail.com] > *Sent:* Tuesday, September 15, 2015 12:16 PM > *To:* gerald thomas > *Cc:* Mugeni Harold; dhis2-users > > *Subject:* Re: [Dhis2-users] Can't Login after restoring sample database > > > > Hi > > > > I think you should upgrade to a more recent version of DHIS 2. What > version are you using? > > > > I would recommend that you re-download DHIS 2 and maybe also the database > (if you haven't downloaded it recently) > > > > Latest 2.20 release: > > https://www.dhis2.org/download/releases/2.20/dhis.war > > > > Latest demo db: > > https://www.dhis2.org/download/resources/2.20/dhis2-demo.zip > > > > > -- > Morten > > > > On Tue, Sep 15, 2015 at 5:10 PM, gerald thomas <gerald17...@gmail.com> > wrote: > > Mugeni, > > I didn't want to jump into conclusion so soon but i think the database > backup you have maybe having some issues. Do you have any other > database or can you download it again and try it. > > This time you are only: > * stop tomcat > * go to pgadmin and delete database (eg dhis): I am assuming you are > using postgresql? > * create database (eg dhis2) > Please don't forget to change the database name to dhis2 on the > hibernate.properties file > * The you import the new file you had downloaded. > > > On 9/15/15, Mugeni Harold <hmug...@gmail.com> wrote: > > Gerald, > > > > I have followed the steps in the workaround, but still get the same > > exception. > > > > Cheers > > > > -----Original Message----- > > From: gerald thomas [mailto:gerald17...@gmail.com] > > Sent: Tuesday, September 15, 2015 10:53 AM > > To: Mugeni Harold > > Cc: dhis2-users@lists.launchpad.net > > Subject: Re: [Dhis2-users] Can't Login after restoring sample database > > > > Mugeni, > > > > This seem strange but if you are using win7 then you should find logs in > > C:\Program Files\apache tomcat\log (if it is 64bit you are using) > > > > or C:\Program Files(x86)\apache tomcat\log (if it is 32bit you are > using). > > > > Workaround: > > > > * Shutdown tomcat > > * delete the database > > * create a new database > > * Make sure the database information is on the 'hibernate.properties' > file > > * Check that the environmental variables are configured properly > > * import the database you wish to use using psql \i > /C:/Desktop/dhis2g.sql > > (Note: it is desktop because i am assuming the location of the database > is > > on the desktop and also change dhis2g.sql to the name of your file.sql) > > > > > > * Finally, run the command to change the admin profile to admin/district > > > > and reboot your win7 system. > > > > Good luck > > > > On 9/15/15, Mugeni Harold <hmug...@gmail.com> wrote: > >> Gerald, > >> > >> Please find attached the screenshot upon trying to login. For some > >> reason, I can't find any log files for the dhis application. I am > >> using win7 and the WAR file under tomcat. > >> > >> > >> -----Original Message----- > >> From: gerald thomas [mailto:gerald17...@gmail.com] > >> Sent: Tuesday, September 15, 2015 8:49 AM > >> To: Mugeni Harold > >> Cc: dhis2-users@lists.launchpad.net > >> Subject: Re: [Dhis2-users] Can't Login after restoring sample database > >> > >> Mugeni, > >> > >> Please can you send a screenshot of the error you are having and also > >> the log files? > >> > >> On 9/15/15, Mugeni Harold <hmug...@gmail.com> wrote: > >>> Dear Gerald, > >>> > >>> Thank you so much for your response. I think it works, but what is > >>> happening now is that when I try to login, an exception occurs. I > >>> don't know whether this had to do with the data imported from the > >>> sample databse because though it completed, it did give off some > >>> errors during the restore. Should I retry the restore and if so, are > >>> there some things I need to look out for before I do it? > >>> > >>> Thanks, > >>> Harold > >>> > >>> -----Original Message----- > >>> From: gerald thomas [mailto:gerald17...@gmail.com] > >>> Sent: Monday, September 14, 2015 4:25 PM > >>> To: Mugeni Harold > >>> Cc: dhis2-users@lists.launchpad.net > >>> Subject: Re: [Dhis2-users] Can't Login after restoring sample > >>> database > >>> > >>> Dear Mugeni, > >>> What database are you using? If it is postgresql > >>> > >>> You can connect to the database using psql admin or psql (database > >>> name) > >>> > >>> Then run this query: > >>> UPDATE users set password = '48e8f1207baef1ef7fe478a57d19f2e5' where > >>> username = 'admin'; > >>> > >>> Restart the system and try admin/district > >>> > >>> Wishing you all the best. > >>> > >>> On 9/14/15, Mugeni Harold <hmug...@gmail.com> wrote: > >>>> Hallo Everyone, > >>>> > >>>> > >>>> > >>>> Hope you are all well. I have installed DHIS2 locally on my machine. > >>>> I ran it for a while with my own data and everything was ok. Later I > >>>> decided to run the application using the sample database. I created > >>>> another database called 'dhis2_sierra' and restored in it the sample > >>>> database from dhis2.org . After the restore was finished, I tried to > >>>> run it, but unfortunately I can't login anymore with the > >>>> admin/district combination. Is there something I have missed? All > >>>> your feedback will be appreciated. > >>>> > >>>> > >>>> > >>>> Thank you, > >>>> > >>>> Harold > >>>> > >>>> > >>>> > >>>> > >>> > >>> > >>> -- > >>> Regards, > >>> > >>> Gerald > >>> > >>> > >> > >> > >> -- > >> Regards, > >> > >> Gerald > >> > > > > > > -- > > Regards, > > > > Gerald > > > > > > > -- > Regards, > > Gerald > > _______________________________________________ > 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 > > >
_______________________________________________ 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
