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…

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. ▶ ···

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 …

Mugeni, Please can you send a screenshot of the error you are having and also the log files? ▶ ···

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. [image] ▶ ···

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 e…

Gerald, Please find attached the tomcat8 log file, sorry I was looking for a dhis log file, which only exists for dhis-live. Meanwhile I am going through the outlined steps. tomcat8-stdout.2015-09-15.log (103 KB) ▶ ···

Gerald, I have followed the steps in the workaround, but still get the same exception. Cheers ▶ ···

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 n…

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 ▶ ···

Hi Morten, I am already using the latest of both the dhis2 and the sample database. ▶ ···

DHIS2.org
Documentation
Developers
Demo
Apps
Academy

DHIS2 Community

Can't Login after restoring sample database

Support - Assistance technique

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled