Thank you so much for the feedback and responses. It is true I was using dhis 2.16 application. I have upgraded to 2.20 and everything seems fine.
···
From: Knut Staring [mailto:knutst@gmail.com]
Sent: Tuesday, September 15, 2015 12:33 PM
To: Jason Pickering
Cc: Mugeni Harold; dhis2-users
Subject: Re: [Dhis2-users] Can’t Login after restoring sample database
You can verify your version by going to About DHIS2
On Tue, Sep 15, 2015 at 12:28 PM, Jason Pickering jason.p.pickering@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 hmugeni@gmail.com wrote:
Hi Morten,
I am already using the latest of both the dhis2 and the sample database.
From: Morten Olav Hansen [mailto:mortenoh@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 gerald17006@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 hmugeni@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:gerald17006@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 hmugeni@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:gerald17006@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 hmugeni@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:gerald17006@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 hmugeni@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.pickering@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