← Back to team overview

dhis2-users team mailing list archive

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

Follow ups

References