dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

Great to see you got it working, Yaw!

Cheers,
Knut

On Fri, Jan 27, 2017 at 9:18 PM, Yaw Anokwa <yanokwa@xxxxxxxxxxx> 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@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
> >
>



-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org