dhis2-devs team mailing list archive

[Yaw Anokwa <yanokwa@xxxxxxxxxxx>]

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@xxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxxxx>
>>> > 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@xxxxxxxxx>
>>> >> 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@xxxxxxxxxxx> 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@xxxxxxxxx>
>>> >> >> 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@xxxxxxxxxxx>
>>> >> >> > 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@xxxxxxxxxxxxxxxxxxx
>>> >> >> >> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> >> >> >> More help   : https://help.launchpad.net/ListHelp
>>> >> >> >>
>>> >> >> >
>>> >>
>>> >> _______________________________________________
>>> >> Mailing list: https://launchpad.net/~dhis2-devs
>>> >> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> >> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> >> More help   : https://help.launchpad.net/ListHelp
>>> >
>>> >
>>> >
>>> >
>>> > --
>>> > Jason P. Pickering
>>> > email: jason.p.pickering@xxxxxxxxx
>>> > 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@xxxxxxxxxxxxxxxxxxx
>> 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@xxxxxxxxx
> http://www.dhis2.org
>