dhis2-users team mailing list archive

["Mugeni Harold" <hmugeni@xxxxxxxxx>]

Dear All,

 

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@xxxxxxxxx] 
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@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 <tel:%2B46764147049> 


_______________________________________________
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