← Back to team overview

dhis2-users team mailing list archive

Re: Can't Login after restoring sample database

 

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.

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

Attachment: tomcat8-stdout.2015-09-15.log
Description: Binary data


References