You can verify your version by going to About DHIS2 On Tue, Sep 15, 2015 at 12:28 PM, Jason Pickering < jason.p.picker...@gmail.com> wrote:
> 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 > > -- 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
