Great to see you got it working, Yaw! Cheers, Knut
On Fri, Jan 27, 2017 at 9:18 PM, Yaw Anokwa <yano...@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 <l...@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 <knu...@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 <yano...@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.picker...@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 <yano...@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 <knu...@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" <yano...@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 <knu...@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" <yano...@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.picker...@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 > > l...@dhis2.org > > http://www.dhis2.org > > > -- 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
