Can't Login after restoring sample database


(Mugeni Harold) #1

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


(Gerald Thomas) #2

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@gmail.com> 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


(Mugeni Harold) #3

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@gmail.com]
Sent: Monday, September 14, 2015 4:25 PM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com> 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


(Gerald Thomas) #4

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@gmail.com> 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@gmail.com]
Sent: Monday, September 14, 2015 4:25 PM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com> 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


(Mugeni Harold) #5

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@gmail.com]
Sent: Tuesday, September 15, 2015 8:49 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com> 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@gmail.com]
Sent: Monday, September 14, 2015 4:25 PM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com> 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


(Gerald Thomas) #6

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@gmail.com> 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@gmail.com]
Sent: Tuesday, September 15, 2015 8:49 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com> 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@gmail.com]
Sent: Monday, September 14, 2015 4:25 PM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com> 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


(Mugeni Harold) #7

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.

tomcat8-stdout.2015-09-15.log (103 KB)

···

-----Original Message-----
From: gerald thomas [mailto:gerald17006@gmail.com]
Sent: Tuesday, September 15, 2015 10:53 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com> 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@gmail.com]
Sent: Tuesday, September 15, 2015 8:49 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com> 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@gmail.com]
Sent: Monday, September 14, 2015 4:25 PM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com> 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


(Mugeni Harold) #8

Gerald,

I have followed the steps in the workaround, but still get the same exception.

Cheers

···

-----Original Message-----
From: gerald thomas [mailto:gerald17006@gmail.com]
Sent: Tuesday, September 15, 2015 10:53 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com> 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@gmail.com]
Sent: Tuesday, September 15, 2015 8:49 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com> 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@gmail.com]
Sent: Monday, September 14, 2015 4:25 PM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com> 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


(Gerald Thomas) #9

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@gmail.com> wrote:

Gerald,

I have followed the steps in the workaround, but still get the same
exception.

Cheers

-----Original Message-----
From: gerald thomas [mailto:gerald17006@gmail.com]
Sent: Tuesday, September 15, 2015 10:53 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com> 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@gmail.com]
Sent: Tuesday, September 15, 2015 8:49 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com> 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@gmail.com]
Sent: Monday, September 14, 2015 4:25 PM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com> 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


(Morten Hansen) #10

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

···

On Tue, Sep 15, 2015 at 5:10 PM, gerald thomas gerald17006@gmail.com 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@gmail.com wrote:

Gerald,

I have followed the steps in the workaround, but still get the same

exception.

Cheers

-----Original Message-----

From: gerald thomas [mailto:gerald17006@gmail.com]

Sent: Tuesday, September 15, 2015 10:53 AM

To: Mugeni Harold

Cc: dhis2-users@lists.launchpad.net

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@gmail.com 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@gmail.com]

Sent: Tuesday, September 15, 2015 8:49 AM

To: Mugeni Harold

Cc: dhis2-users@lists.launchpad.net

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@gmail.com 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@gmail.com]

Sent: Monday, September 14, 2015 4:25 PM

To: Mugeni Harold

Cc: dhis2-users@lists.launchpad.net

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@gmail.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Morten


(Mugeni Harold) #11

Hi Morten,

I am already using the latest of both the dhis2 and the sample database.

···

From: Morten Olav Hansen [mailto:mortenoh@gmail.com]
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@gmail.com 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@gmail.com wrote:

Gerald,

I have followed the steps in the workaround, but still get the same
exception.

Cheers

-----Original Message-----
From: gerald thomas [mailto:gerald17006@gmail.com]
Sent: Tuesday, September 15, 2015 10:53 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com 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@gmail.com]
Sent: Tuesday, September 15, 2015 8:49 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com 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@gmail.com]
Sent: Monday, September 14, 2015 4:25 PM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp


(Morten Hansen) #12

Are you sure? because its complaining about something we removed a long time ago (ou.active)

···

On Tue, Sep 15, 2015 at 5:23 PM, Mugeni Harold hmugeni@gmail.com wrote:

Hi Morten,

I am already using the latest of both the dhis2 and the sample database.

From: Morten Olav Hansen [mailto:mortenoh@gmail.com]
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@gmail.com 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@gmail.com wrote:

Gerald,

I have followed the steps in the workaround, but still get the same
exception.

Cheers

-----Original Message-----
From: gerald thomas [mailto:gerald17006@gmail.com]
Sent: Tuesday, September 15, 2015 10:53 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com 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@gmail.com]
Sent: Tuesday, September 15, 2015 8:49 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com 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@gmail.com]
Sent: Monday, September 14, 2015 4:25 PM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp


Morten


(Jason Pickering) #13

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@gmail.com wrote:

Hi Morten,

I am already using the latest of both the dhis2 and the sample database.

From: Morten Olav Hansen [mailto:mortenoh@gmail.com]
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@gmail.com 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@gmail.com wrote:

Gerald,

I have followed the steps in the workaround, but still get the same
exception.

Cheers

-----Original Message-----
From: gerald thomas [mailto:gerald17006@gmail.com]
Sent: Tuesday, September 15, 2015 10:53 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com 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@gmail.com]
Sent: Tuesday, September 15, 2015 8:49 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com 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@gmail.com]
Sent: Monday, September 14, 2015 4:25 PM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049


(Knut Staring) #14

You can verify your version by going to About DHIS2

···

On Tue, Sep 15, 2015 at 12:28 PM, Jason Pickering jason.p.pickering@gmail.com 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


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Tue, Sep 15, 2015 at 12:23 PM, Mugeni Harold hmugeni@gmail.com wrote:

Hi Morten,

I am already using the latest of both the dhis2 and the sample database.

From: Morten Olav Hansen [mailto:mortenoh@gmail.com]
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@gmail.com 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@gmail.com wrote:

Gerald,

I have followed the steps in the workaround, but still get the same
exception.

Cheers

-----Original Message-----
From: gerald thomas [mailto:gerald17006@gmail.com]
Sent: Tuesday, September 15, 2015 10:53 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com 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@gmail.com]
Sent: Tuesday, September 15, 2015 8:49 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com 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@gmail.com]
Sent: Monday, September 14, 2015 4:25 PM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org


(Mugeni Harold) #15

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@gmail.com]
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@gmail.com 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@gmail.com wrote:

Hi Morten,

I am already using the latest of both the dhis2 and the sample database.

From: Morten Olav Hansen [mailto:mortenoh@gmail.com]
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@gmail.com 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@gmail.com wrote:

Gerald,

I have followed the steps in the workaround, but still get the same
exception.

Cheers

-----Original Message-----
From: gerald thomas [mailto:gerald17006@gmail.com]
Sent: Tuesday, September 15, 2015 10:53 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com 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@gmail.com]
Sent: Tuesday, September 15, 2015 8:49 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com 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@gmail.com]
Sent: Monday, September 14, 2015 4:25 PM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net
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@gmail.com 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049


Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
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


(James Omutsani) split this topic #16

A post was split to a new topic: Can’t Login after restoring sample database