Hi there. The problem is here * ERROR 2015-09-15 09:11:38,423 ERROR: column organisati1_.active does not exist Position: 608 (SqlExceptionHelper.java [http-nio-8080-exec-2])
which looks like you are using an older version of DHIS2, where this column was present. So, you have a mismatch between the database and the server. I would agree with Morten, that you should update your version of DHIS2. If you are using DHIS2 Live, you may be running an older version. Regards, Jason On Tue, Sep 15, 2015 at 12: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 > > -- Jason P. Pickering email: jason.p.picker...@gmail.com tel:+46764147049
_______________________________________________ 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
