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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 >>> <[email protected]> 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 <[email protected]> >>> > 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 <[email protected]> >>> >> 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" <[email protected]> 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 <[email protected]> >>> >> >> 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" <[email protected]> >>> >> >> > 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 : [email protected] >>> >> >> >> Unsubscribe : https://launchpad.net/~dhis2-devs >>> >> >> >> More help : https://help.launchpad.net/ListHelp >>> >> >> >> >>> >> >> > >>> >> >>> >> _______________________________________________ >>> >> Mailing list: https://launchpad.net/~dhis2-devs >>> >> Post to : [email protected] >>> >> Unsubscribe : https://launchpad.net/~dhis2-devs >>> >> More help : https://help.launchpad.net/ListHelp >>> > >>> > >>> > >>> > >>> > -- >>> > Jason P. Pickering >>> > email: [email protected] >>> > 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 : [email protected] >> 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 > [email protected] > http://www.dhis2.org > _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
