dhis2-users team mailing list archive

["Mugeni Harold" <hmugeni@xxxxxxxxx>]

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