dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

You can verify your version by going to About DHIS2

On Tue, Sep 15, 2015 at 12:28 PM, Jason Pickering <
jason.p.pickering@xxxxxxxxx> 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@xxxxxxxxx> wrote:
>
>> Hi Morten,
>>
>>
>>
>> I am already using the latest of both the dhis2 and the sample database.
>>
>>
>>
>> *From:* Morten Olav Hansen [mailto:mortenoh@xxxxxxxxx]
>> *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@xxxxxxxxx>
>> 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@xxxxxxxxx> wrote:
>> > Gerald,
>> >
>> > I have followed the steps in the workaround, but still get the same
>> > exception.
>> >
>> > Cheers
>> >
>> > -----Original Message-----
>> > From: gerald thomas [mailto:gerald17006@xxxxxxxxx]
>> > Sent: Tuesday, September 15, 2015 10:53 AM
>> > To: Mugeni Harold
>> > Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx
>> > 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@xxxxxxxxx> 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@xxxxxxxxx]
>> >> Sent: Tuesday, September 15, 2015 8:49 AM
>> >> To: Mugeni Harold
>> >> Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx
>> >> 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@xxxxxxxxx> 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@xxxxxxxxx]
>> >>> Sent: Monday, September 14, 2015 4:25 PM
>> >>> To: Mugeni Harold
>> >>> Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx
>> >>> 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@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+46764147049
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> 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