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
