Adding demo data to new server

Hi all,

I've setup DHIS 2.25 on my server and I've successfully imported the
demo data from https://www.dhis2.org/download/resources/2.25/dhis2-demo.zip
into the DB (see my-db.png).

But, when I log into my server, it doesn't look like the demo server
at https://play.dhis2.org/demo/\. I've attached screenshots. Am I
missing something?

Thanks,

Yaw

image

image

image

Hi Yaw,

Please click on the gray circle in the upper right corner and select About DHIS2,

https://play.dhis2.org/demo/dhis-web-commons-about/about.action.

There you can see what db you are connected to. This is set in the conf/dhis.conf file for DHIS Live.

Knut

···

On Jan 18, 2017 3:42 AM, “Yaw Anokwa” yanokwa@nafundi.com wrote:

Hi all,

I’ve setup DHIS 2.25 on my server and I’ve successfully imported the

demo data from https://www.dhis2.org/download/resources/2.25/dhis2-demo.zip

into the DB (see my-db.png).

But, when I log into my server, it doesn’t look like the demo server

at https://play.dhis2.org/demo/. I’ve attached screenshots. Am I

missing something?

Thanks,

Yaw


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

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

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

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

Hi Knut,

Thanks for the speedy response. I know what DB I'm connected to, so
that's not the problem. I think maybe my email was not clear, so let
me try again!

I'm on a new server (not a Live install) with DHIS installed. I have
imported the demo data from the DHIS 2 Demo zip file into the DB on
that new server.

But when I go look at the web interface of said server, it doesn't
look like what I expect. That is, there is nothing that suggests that
the demo data has been imported. The UI doesn't look like the Sierra
Leone demo server at https://play.dhis2.org/demo\.

Yaw

···

On Wed, Jan 18, 2017 at 10:47 AM, Knut Staring <knutst@gmail.com> wrote:

Hi Yaw,
Please click on the gray circle in the upper right corner and select About
DHIS2,
https://play.dhis2.org/demo/dhis-web-commons-about/about.action\.

There you can see what db you are connected to. This is set in the
conf/dhis.conf file for DHIS Live.

Knut

On Jan 18, 2017 3:42 AM, "Yaw Anokwa" <yanokwa@nafundi.com> wrote:

Hi all,

I've setup DHIS 2.25 on my server and I've successfully imported the
demo data from
https://www.dhis2.org/download/resources/2.25/dhis2-demo.zip
into the DB (see my-db.png).

But, when I log into my server, it doesn't look like the demo server
at https://play.dhis2.org/demo/\. I've attached screenshots. Am I
missing something?

Thanks,

Yaw

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

I would really double check that db connection. You would see what you see if you were currently connected to the internal in-memory H2 db rather than Postgres. What does your tomcat log say? Did you create DHIS_HOME?

···

On Jan 18, 2017 5:36 AM, “Yaw Anokwa” yanokwa@nafundi.com wrote:

Hi Knut,

Thanks for the speedy response. I know what DB I’m connected to, so

that’s not the problem. I think maybe my email was not clear, so let

me try again!

I’m on a new server (not a Live install) with DHIS installed. I have

imported the demo data from the DHIS 2 Demo zip file into the DB on

that new server.

But when I go look at the web interface of said server, it doesn’t

look like what I expect. That is, there is nothing that suggests that

the demo data has been imported. The UI doesn’t look like the Sierra

Leone demo server at https://play.dhis2.org/demo.

Yaw

On Wed, Jan 18, 2017 at 10:47 AM, Knut Staring knutst@gmail.com wrote:

Hi Yaw,

Please click on the gray circle in the upper right corner and select About

DHIS2,

https://play.dhis2.org/demo/dhis-web-commons-about/about.action.

There you can see what db you are connected to. This is set in the

conf/dhis.conf file for DHIS Live.

Knut

On Jan 18, 2017 3:42 AM, “Yaw Anokwa” yanokwa@nafundi.com wrote:

Hi all,

I’ve setup DHIS 2.25 on my server and I’ve successfully imported the

demo data from

https://www.dhis2.org/download/resources/2.25/dhis2-demo.zip

into the DB (see my-db.png).

But, when I log into my server, it doesn’t look like the demo server

at https://play.dhis2.org/demo/. I’ve attached screenshots. Am I

missing something?

Thanks,

Yaw


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

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

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

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

Thanks for your patience, and my apologies! You were correct.

I've now confirmed that I'm now connected to the PostgreSQL DB and the
login page reads Sierra Leone.

How now do I get the various dashboards that are present in the public demo?

Yaw

···

On Wed, Jan 18, 2017 at 11:54 AM, Knut Staring <knutst@gmail.com> wrote:

I would really double check that db connection. You would see what you see
if you were currently connected to the internal in-memory H2 db rather than
Postgres. What does your tomcat log say? Did you create DHIS_HOME?

On Jan 18, 2017 5:36 AM, "Yaw Anokwa" <yanokwa@nafundi.com> wrote:

Hi Knut,

Thanks for the speedy response. I know what DB I'm connected to, so
that's not the problem. I think maybe my email was not clear, so let
me try again!

I'm on a new server (not a Live install) with DHIS installed. I have
imported the demo data from the DHIS 2 Demo zip file into the DB on
that new server.

But when I go look at the web interface of said server, it doesn't
look like what I expect. That is, there is nothing that suggests that
the demo data has been imported. The UI doesn't look like the Sierra
Leone demo server at https://play.dhis2.org/demo\.

Yaw

On Wed, Jan 18, 2017 at 10:47 AM, Knut Staring <knutst@gmail.com> wrote:
> Hi Yaw,
> Please click on the gray circle in the upper right corner and select
> About
> DHIS2,
> https://play.dhis2.org/demo/dhis-web-commons-about/about.action\.
>
> There you can see what db you are connected to. This is set in the
> conf/dhis.conf file for DHIS Live.
>
> Knut
>
>
> On Jan 18, 2017 3:42 AM, "Yaw Anokwa" <yanokwa@nafundi.com> wrote:
>>
>> Hi all,
>>
>> I've setup DHIS 2.25 on my server and I've successfully imported the
>> demo data from
>> https://www.dhis2.org/download/resources/2.25/dhis2-demo.zip
>> into the DB (see my-db.png).
>>
>> But, when I log into my server, it doesn't look like the demo server
>> at https://play.dhis2.org/demo/\. I've attached screenshots. Am I
>> missing something?
>>
>> Thanks,
>>
>> Yaw
>>
>> _______________________________________________
>> Mailing list: DHIS 2 developers in Launchpad
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : DHIS 2 developers in Launchpad
>> More help : ListHelp - Launchpad Help
>>
>

You will need to run analytics

https://docs.dhis2.org/master/en/user/html/ch30.html

Regards,

Jason

···

On Wed, Jan 18, 2017 at 9:14 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Thanks for your patience, and my apologies! You were correct.

I’ve now confirmed that I’m now connected to the PostgreSQL DB and the

login page reads Sierra Leone.

How now do I get the various dashboards that are present in the public demo?

Yaw

On Wed, Jan 18, 2017 at 11:54 AM, Knut Staring knutst@gmail.com wrote:

I would really double check that db connection. You would see what you see

if you were currently connected to the internal in-memory H2 db rather than

Postgres. What does your tomcat log say? Did you create DHIS_HOME?

On Jan 18, 2017 5:36 AM, “Yaw Anokwa” yanokwa@nafundi.com wrote:

Hi Knut,

Thanks for the speedy response. I know what DB I’m connected to, so

that’s not the problem. I think maybe my email was not clear, so let

me try again!

I’m on a new server (not a Live install) with DHIS installed. I have

imported the demo data from the DHIS 2 Demo zip file into the DB on

that new server.

But when I go look at the web interface of said server, it doesn’t

look like what I expect. That is, there is nothing that suggests that

the demo data has been imported. The UI doesn’t look like the Sierra

Leone demo server at https://play.dhis2.org/demo.

Yaw

On Wed, Jan 18, 2017 at 10:47 AM, Knut Staring knutst@gmail.com wrote:

Hi Yaw,

Please click on the gray circle in the upper right corner and select

About

DHIS2,

https://play.dhis2.org/demo/dhis-web-commons-about/about.action.

There you can see what db you are connected to. This is set in the

conf/dhis.conf file for DHIS Live.

Knut

On Jan 18, 2017 3:42 AM, “Yaw Anokwa” yanokwa@nafundi.com wrote:

Hi all,

I’ve setup DHIS 2.25 on my server and I’ve successfully imported the

demo data from

https://www.dhis2.org/download/resources/2.25/dhis2-demo.zip

into the DB (see my-db.png).

But, when I log into my server, it doesn’t look like the demo server

at https://play.dhis2.org/demo/. I’ve attached screenshots. Am I

missing something?

Thanks,

Yaw


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

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

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

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


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

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

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

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

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

Thanks Jason for that tip. Seems like the DB isn't very happy.

The export fails with this:
2017-01-18 08:53:54Process failed: StatementCallback; bad SQL grammar
[alter table _orgunitstructure_temp rename to _orgunitstructure;];
nested exception is org.postgresql.util.PSQLException: ERROR: relation
"_orgunitstructure" already exists
2017-01-18 08:53:54Updating resource tables
2017-01-18 08:53:54Analytics table update process started

http://dpaste.com/0MCMKSA is the full trace from Tomcat.

···

On Wed, Jan 18, 2017 at 3:23 PM, Jason Pickering <jason.p.pickering@gmail.com> wrote:

You will need to run analytics

Home - DHIS2 Documentation

Regards,
Jason

On Wed, Jan 18, 2017 at 9:14 AM, Yaw Anokwa <yanokwa@nafundi.com> wrote:

Thanks for your patience, and my apologies! You were correct.

I've now confirmed that I'm now connected to the PostgreSQL DB and the
login page reads Sierra Leone.

How now do I get the various dashboards that are present in the public
demo?

Yaw

On Wed, Jan 18, 2017 at 11:54 AM, Knut Staring <knutst@gmail.com> wrote:
> I would really double check that db connection. You would see what you
> see
> if you were currently connected to the internal in-memory H2 db rather
> than
> Postgres. What does your tomcat log say? Did you create DHIS_HOME?
>
>
> On Jan 18, 2017 5:36 AM, "Yaw Anokwa" <yanokwa@nafundi.com> wrote:
>>
>> Hi Knut,
>>
>> Thanks for the speedy response. I know what DB I'm connected to, so
>> that's not the problem. I think maybe my email was not clear, so let
>> me try again!
>>
>> I'm on a new server (not a Live install) with DHIS installed. I have
>> imported the demo data from the DHIS 2 Demo zip file into the DB on
>> that new server.
>>
>> But when I go look at the web interface of said server, it doesn't
>> look like what I expect. That is, there is nothing that suggests that
>> the demo data has been imported. The UI doesn't look like the Sierra
>> Leone demo server at https://play.dhis2.org/demo\.
>>
>> Yaw
>>
>> On Wed, Jan 18, 2017 at 10:47 AM, Knut Staring <knutst@gmail.com> >> >> wrote:
>> > Hi Yaw,
>> > Please click on the gray circle in the upper right corner and select
>> > About
>> > DHIS2,
>> > https://play.dhis2.org/demo/dhis-web-commons-about/about.action\.
>> >
>> > There you can see what db you are connected to. This is set in the
>> > conf/dhis.conf file for DHIS Live.
>> >
>> > Knut
>> >
>> >
>> > On Jan 18, 2017 3:42 AM, "Yaw Anokwa" <yanokwa@nafundi.com> wrote:
>> >>
>> >> Hi all,
>> >>
>> >> I've setup DHIS 2.25 on my server and I've successfully imported the
>> >> demo data from
>> >> https://www.dhis2.org/download/resources/2.25/dhis2-demo.zip
>> >> into the DB (see my-db.png).
>> >>
>> >> But, when I log into my server, it doesn't look like the demo server
>> >> at https://play.dhis2.org/demo/\. I've attached screenshots. Am I
>> >> missing something?
>> >>
>> >> Thanks,
>> >>
>> >> Yaw
>> >>
>> >> _______________________________________________
>> >> Mailing list: DHIS 2 developers in Launchpad
>> >> Post to : dhis2-devs@lists.launchpad.net
>> >> Unsubscribe : DHIS 2 developers in Launchpad
>> >> More help : ListHelp - Launchpad Help
>> >>
>> >

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

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

Hi Yaw,

Not sure what causes this, just wanted to check with you which version of Postgres you are using since I remember there were some issues with the latest version (9.6)

···

On Wed, Jan 18, 2017 at 9:55 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

On Wed, Jan 18, 2017 at 3:23 PM, Jason Pickering

jason.p.pickering@gmail.com wrote:

You will need to run analytics

https://docs.dhis2.org/master/en/user/html/ch30.html

Regards,

Jason

On Wed, Jan 18, 2017 at 9:14 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Thanks for your patience, and my apologies! You were correct.

I’ve now confirmed that I’m now connected to the PostgreSQL DB and the

login page reads Sierra Leone.

How now do I get the various dashboards that are present in the public

demo?

Yaw

On Wed, Jan 18, 2017 at 11:54 AM, Knut Staring knutst@gmail.com wrote:

I would really double check that db connection. You would see what you

see

if you were currently connected to the internal in-memory H2 db rather

than

Postgres. What does your tomcat log say? Did you create DHIS_HOME?

On Jan 18, 2017 5:36 AM, “Yaw Anokwa” yanokwa@nafundi.com wrote:

Hi Knut,

Thanks for the speedy response. I know what DB I’m connected to, so

that’s not the problem. I think maybe my email was not clear, so let

me try again!

I’m on a new server (not a Live install) with DHIS installed. I have

imported the demo data from the DHIS 2 Demo zip file into the DB on

that new server.

But when I go look at the web interface of said server, it doesn’t

look like what I expect. That is, there is nothing that suggests that

the demo data has been imported. The UI doesn’t look like the Sierra

Leone demo server at https://play.dhis2.org/demo.

Yaw

On Wed, Jan 18, 2017 at 10:47 AM, Knut Staring knutst@gmail.com

wrote:

Hi Yaw,

Please click on the gray circle in the upper right corner and select

About

DHIS2,

https://play.dhis2.org/demo/dhis-web-commons-about/about.action.

There you can see what db you are connected to. This is set in the

conf/dhis.conf file for DHIS Live.

Knut

On Jan 18, 2017 3:42 AM, “Yaw Anokwa” yanokwa@nafundi.com wrote:

Hi all,

I’ve setup DHIS 2.25 on my server and I’ve successfully imported the

demo data from

https://www.dhis2.org/download/resources/2.25/dhis2-demo.zip

into the DB (see my-db.png).

But, when I log into my server, it doesn’t look like the demo server

at https://play.dhis2.org/demo/. I’ve attached screenshots. Am I

missing something?

Thanks,

Yaw


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

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

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

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


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

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

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

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

Jason P. Pickering

email: jason.p.pickering@gmail.com

tel:+46764147049

Thanks Jason for that tip. Seems like the DB isn’t very happy.

The export fails with this:

2017-01-18 08:53:54Process failed: StatementCallback; bad SQL grammar

[alter table _orgunitstructure_temp rename to _orgunitstructure;];

nested exception is org.postgresql.util.PSQLException: ERROR: relation

“_orgunitstructure” already exists

2017-01-18 08:53:54Updating resource tables

2017-01-18 08:53:54Analytics table update process started

http://dpaste.com/0MCMKSA is the full trace from Tomcat.

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Hi Yaw,

that error is not something I’ve seen previously.

Try going to apps > data administration > resource tables and generate them manually.

Alternatively try to drop all tables starting wit _ (underscore) manually from the database, then try again.

https://play.dhis2.org/demo/dhis-web-maintenance-dataadmin/displayResourceTableForm.action

You can also check out the very latest demo databases from Github:

https://github.com/dhis2/dhis2-demo-db

regards,

Lars

···

On Wed, Jan 18, 2017 at 11:50 AM, Knut Staring knutst@gmail.com wrote:

Hi Yaw,

Not sure what causes this, just wanted to check with you which version of Postgres you are using since I remember there were some issues with the latest version (9.6)


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

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

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

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

On Wed, Jan 18, 2017 at 9:55 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

On Wed, Jan 18, 2017 at 3:23 PM, Jason Pickering

jason.p.pickering@gmail.com wrote:

You will need to run analytics

https://docs.dhis2.org/master/en/user/html/ch30.html

Regards,

Jason

On Wed, Jan 18, 2017 at 9:14 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Thanks for your patience, and my apologies! You were correct.

I’ve now confirmed that I’m now connected to the PostgreSQL DB and the

login page reads Sierra Leone.

How now do I get the various dashboards that are present in the public

demo?

Yaw

On Wed, Jan 18, 2017 at 11:54 AM, Knut Staring knutst@gmail.com wrote:

I would really double check that db connection. You would see what you

see

if you were currently connected to the internal in-memory H2 db rather

than

Postgres. What does your tomcat log say? Did you create DHIS_HOME?

On Jan 18, 2017 5:36 AM, “Yaw Anokwa” yanokwa@nafundi.com wrote:

Hi Knut,

Thanks for the speedy response. I know what DB I’m connected to, so

that’s not the problem. I think maybe my email was not clear, so let

me try again!

I’m on a new server (not a Live install) with DHIS installed. I have

imported the demo data from the DHIS 2 Demo zip file into the DB on

that new server.

But when I go look at the web interface of said server, it doesn’t

look like what I expect. That is, there is nothing that suggests that

the demo data has been imported. The UI doesn’t look like the Sierra

Leone demo server at https://play.dhis2.org/demo.

Yaw

On Wed, Jan 18, 2017 at 10:47 AM, Knut Staring knutst@gmail.com

wrote:

Hi Yaw,

Please click on the gray circle in the upper right corner and select

About

DHIS2,

https://play.dhis2.org/demo/dhis-web-commons-about/about.action.

There you can see what db you are connected to. This is set in the

conf/dhis.conf file for DHIS Live.

Knut

On Jan 18, 2017 3:42 AM, “Yaw Anokwa” yanokwa@nafundi.com wrote:

Hi all,

I’ve setup DHIS 2.25 on my server and I’ve successfully imported the

demo data from

https://www.dhis2.org/download/resources/2.25/dhis2-demo.zip

into the DB (see my-db.png).

But, when I log into my server, it doesn’t look like the demo server

at https://play.dhis2.org/demo/. I’ve attached screenshots. Am I

missing something?

Thanks,

Yaw


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

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

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

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


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

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

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

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

Jason P. Pickering

email: jason.p.pickering@gmail.com

tel:+46764147049

Thanks Jason for that tip. Seems like the DB isn’t very happy.

The export fails with this:

2017-01-18 08:53:54Process failed: StatementCallback; bad SQL grammar

[alter table _orgunitstructure_temp rename to _orgunitstructure;];

nested exception is org.postgresql.util.PSQLException: ERROR: relation

“_orgunitstructure” already exists

2017-01-18 08:53:54Updating resource tables

2017-01-18 08:53:54Analytics table update process started

http://dpaste.com/0MCMKSA is the full trace from Tomcat.

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Hi all,

I finally got a chance to try this out again and it's now working with
Ubuntu 16, OpenJDK 1.8, Tomcat 8, PostgreSQL 9.5, and PostGIS 2.2.
What worked best was using a separate DB for the demo data.

I've posted my config (Vagrant, Ansible) to
https://github.com/nafundi/dhis2-vagrant\. Hope it helps someone!

Thanks,

Yaw

···

On Wed, Jan 18, 2017 at 5:58 PM, Lars Helge Øverland <lars@dhis2.org> wrote:

Hi Yaw,

that error is not something I've seen previously.

Try going to apps > data administration > resource tables and generate them
manually.

Alternatively try to drop all tables starting wit _ (underscore) manually
from the database, then try again.

https://play.dhis2.org/demo/dhis-web-maintenance-dataadmin/displayResourceTableForm.action

You can also check out the very latest demo databases from Github:

GitHub - d2-ci/dhis2-demo-db: DHIS 2 demo databases

regards,

Lars

On Wed, Jan 18, 2017 at 11:50 AM, Knut Staring <knutst@gmail.com> wrote:

Hi Yaw,

Not sure what causes this, just wanted to check with you which version of
Postgres you are using since I remember there were some issues with the
latest version (9.6)

On Wed, Jan 18, 2017 at 9:55 AM, Yaw Anokwa <yanokwa@nafundi.com> wrote:

Thanks Jason for that tip. Seems like the DB isn't very happy.

The export fails with this:
2017-01-18 08:53:54Process failed: StatementCallback; bad SQL grammar
[alter table _orgunitstructure_temp rename to _orgunitstructure;];
nested exception is org.postgresql.util.PSQLException: ERROR: relation
"_orgunitstructure" already exists
2017-01-18 08:53:54Updating resource tables
2017-01-18 08:53:54Analytics table update process started

http://dpaste.com/0MCMKSA is the full trace from Tomcat.

On Wed, Jan 18, 2017 at 3:23 PM, Jason Pickering >>> <jason.p.pickering@gmail.com> wrote:
> You will need to run analytics
>
> Home - DHIS2 Documentation
>
> Regards,
> Jason
>
>
> On Wed, Jan 18, 2017 at 9:14 AM, Yaw Anokwa <yanokwa@nafundi.com> >>> > wrote:
>>
>> Thanks for your patience, and my apologies! You were correct.
>>
>> I've now confirmed that I'm now connected to the PostgreSQL DB and the
>> login page reads Sierra Leone.
>>
>> How now do I get the various dashboards that are present in the public
>> demo?
>>
>> Yaw
>>
>> On Wed, Jan 18, 2017 at 11:54 AM, Knut Staring <knutst@gmail.com> >>> >> wrote:
>> > I would really double check that db connection. You would see what
>> > you
>> > see
>> > if you were currently connected to the internal in-memory H2 db
>> > rather
>> > than
>> > Postgres. What does your tomcat log say? Did you create DHIS_HOME?
>> >
>> >
>> > On Jan 18, 2017 5:36 AM, "Yaw Anokwa" <yanokwa@nafundi.com> wrote:
>> >>
>> >> Hi Knut,
>> >>
>> >> Thanks for the speedy response. I know what DB I'm connected to, so
>> >> that's not the problem. I think maybe my email was not clear, so
>> >> let
>> >> me try again!
>> >>
>> >> I'm on a new server (not a Live install) with DHIS installed. I
>> >> have
>> >> imported the demo data from the DHIS 2 Demo zip file into the DB on
>> >> that new server.
>> >>
>> >> But when I go look at the web interface of said server, it doesn't
>> >> look like what I expect. That is, there is nothing that suggests
>> >> that
>> >> the demo data has been imported. The UI doesn't look like the
>> >> Sierra
>> >> Leone demo server at https://play.dhis2.org/demo\.
>> >>
>> >> Yaw
>> >>
>> >> On Wed, Jan 18, 2017 at 10:47 AM, Knut Staring <knutst@gmail.com> >>> >> >> wrote:
>> >> > Hi Yaw,
>> >> > Please click on the gray circle in the upper right corner and
>> >> > select
>> >> > About
>> >> > DHIS2,
>> >> > https://play.dhis2.org/demo/dhis-web-commons-about/about.action\.
>> >> >
>> >> > There you can see what db you are connected to. This is set in
>> >> > the
>> >> > conf/dhis.conf file for DHIS Live.
>> >> >
>> >> > Knut
>> >> >
>> >> >
>> >> > On Jan 18, 2017 3:42 AM, "Yaw Anokwa" <yanokwa@nafundi.com> >>> >> >> > wrote:
>> >> >>
>> >> >> Hi all,
>> >> >>
>> >> >> I've setup DHIS 2.25 on my server and I've successfully imported
>> >> >> the
>> >> >> demo data from
>> >> >> https://www.dhis2.org/download/resources/2.25/dhis2-demo.zip
>> >> >> into the DB (see my-db.png).
>> >> >>
>> >> >> But, when I log into my server, it doesn't look like the demo
>> >> >> server
>> >> >> at https://play.dhis2.org/demo/\. I've attached screenshots. Am I
>> >> >> missing something?
>> >> >>
>> >> >> Thanks,
>> >> >>
>> >> >> Yaw
>> >> >>
>> >> >> _______________________________________________
>> >> >> Mailing list: DHIS 2 developers in Launchpad
>> >> >> Post to : dhis2-devs@lists.launchpad.net
>> >> >> Unsubscribe : DHIS 2 developers in Launchpad
>> >> >> More help : ListHelp - Launchpad Help
>> >> >>
>> >> >
>>
>> _______________________________________________
>> Mailing list: DHIS 2 developers in Launchpad
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : DHIS 2 developers in Launchpad
>> More help : ListHelp - Launchpad Help
>
>
>
>
> --
> 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

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

--
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
lars@dhis2.org
http://www.dhis2.org

Great to see you got it working, Yaw!

Cheers,

Knut

···

On Fri, Jan 27, 2017 at 9:18 PM, Yaw Anokwa yanokwa@nafundi.com wrote:

Hi all,

I finally got a chance to try this out again and it’s now working with

Ubuntu 16, OpenJDK 1.8, Tomcat 8, PostgreSQL 9.5, and PostGIS 2.2.

What worked best was using a separate DB for the demo data.

I’ve posted my config (Vagrant, Ansible) to

https://github.com/nafundi/dhis2-vagrant. Hope it helps someone!

Thanks,

Yaw

On Wed, Jan 18, 2017 at 5:58 PM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Yaw,

that error is not something I’ve seen previously.

Try going to apps > data administration > resource tables and generate them

manually.

Alternatively try to drop all tables starting wit _ (underscore) manually

from the database, then try again.

https://play.dhis2.org/demo/dhis-web-maintenance-dataadmin/displayResourceTableForm.action

You can also check out the very latest demo databases from Github:

https://github.com/dhis2/dhis2-demo-db

regards,

Lars

On Wed, Jan 18, 2017 at 11:50 AM, Knut Staring knutst@gmail.com wrote:

Hi Yaw,

Not sure what causes this, just wanted to check with you which version of

Postgres you are using since I remember there were some issues with the

latest version (9.6)

On Wed, Jan 18, 2017 at 9:55 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Thanks Jason for that tip. Seems like the DB isn’t very happy.

The export fails with this:

2017-01-18 08:53:54Process failed: StatementCallback; bad SQL grammar

[alter table _orgunitstructure_temp rename to _orgunitstructure;];

nested exception is org.postgresql.util.PSQLException: ERROR: relation

“_orgunitstructure” already exists

2017-01-18 08:53:54Updating resource tables

2017-01-18 08:53:54Analytics table update process started

http://dpaste.com/0MCMKSA is the full trace from Tomcat.

On Wed, Jan 18, 2017 at 3:23 PM, Jason Pickering

jason.p.pickering@gmail.com wrote:

You will need to run analytics

https://docs.dhis2.org/master/en/user/html/ch30.html

Regards,

Jason

On Wed, Jan 18, 2017 at 9:14 AM, Yaw Anokwa yanokwa@nafundi.com

wrote:

Thanks for your patience, and my apologies! You were correct.

I’ve now confirmed that I’m now connected to the PostgreSQL DB and the

login page reads Sierra Leone.

How now do I get the various dashboards that are present in the public

demo?

Yaw

On Wed, Jan 18, 2017 at 11:54 AM, Knut Staring knutst@gmail.com

wrote:

I would really double check that db connection. You would see what

you

see

if you were currently connected to the internal in-memory H2 db

rather

than

Postgres. What does your tomcat log say? Did you create DHIS_HOME?

On Jan 18, 2017 5:36 AM, “Yaw Anokwa” yanokwa@nafundi.com wrote:

Hi Knut,

Thanks for the speedy response. I know what DB I’m connected to, so

that’s not the problem. I think maybe my email was not clear, so

let

me try again!

I’m on a new server (not a Live install) with DHIS installed. I

have

imported the demo data from the DHIS 2 Demo zip file into the DB on

that new server.

But when I go look at the web interface of said server, it doesn’t

look like what I expect. That is, there is nothing that suggests

that

the demo data has been imported. The UI doesn’t look like the

Sierra

Leone demo server at https://play.dhis2.org/demo.

Yaw

On Wed, Jan 18, 2017 at 10:47 AM, Knut Staring knutst@gmail.com

wrote:

Hi Yaw,

Please click on the gray circle in the upper right corner and

select

About

DHIS2,

https://play.dhis2.org/demo/dhis-web-commons-about/about.action.

There you can see what db you are connected to. This is set in

the

conf/dhis.conf file for DHIS Live.

Knut

On Jan 18, 2017 3:42 AM, “Yaw Anokwa” yanokwa@nafundi.com

wrote:

Hi all,

I’ve setup DHIS 2.25 on my server and I’ve successfully imported

the

demo data from

https://www.dhis2.org/download/resources/2.25/dhis2-demo.zip

into the DB (see my-db.png).

But, when I log into my server, it doesn’t look like the demo

server

at https://play.dhis2.org/demo/. I’ve attached screenshots. Am I

missing something?

Thanks,

Yaw


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

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

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

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


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

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

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

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


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

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

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

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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org