dhis2-users team mailing list archive

Thread
Date

Re: Problems setting up demo database

To: Matthew Gordon <mgordon@xxxxxxxxxxxx>, "dhis2-users@xxxxxxxxxxxxxxxxxxx" <dhis2-users@xxxxxxxxxxxxxxxxxxx>
From: Matthew Gordon <mgordon@xxxxxxxxxxxx>
Date: Fri, 12 Sep 2014 17:07:49 +0000
Accept-language: en-US
Thread-index: AQHPzqwUDCF1cQPhz0i2A+5ZVyJe2g==
Thread-topic: [Dhis2-users] Problems setting up demo database
User-agent: Microsoft-MacOutlook/14.4.4.140807

Thanks Lars, that fixed it!

----
Matthew P. Gordon, Ph.D.
Forward Deployed Engineer, Palantir Technologies
http://www.palantir.com
Email: mgordon@xxxxxxxxxxxx
Mobile: +1-217-721-7600

From: Matt Gordon <mgordon@xxxxxxxxxxxx<mailto:mgordon@xxxxxxxxxxxx>>
Date: Friday, September 12, 2014 at 9:45 AM
To: "dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>" <dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>>
Subject: [Dhis2-users] Problems setting up demo database

Hey all, new DHIS2 user/administrator here, trying to install DHIS2 so I can learn how to interoperate with the API.  I have set up DHIS2 with Postgres using enterprise Tomcat 7 on CentOS 6.5 (CentOS is our default VM distro.)  I created a dhis2 DB using the instructions on the installation page, and downloaded the sample data from here:
https://www.dhis2.org/download/resources/dhis2-demo.zip<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.dhis2.org_download_resources_dhis2-2Ddemo.zip&d=AAMF-g&c=izlc9mHr637UR4lpLEZLFFS3Vn2UXBrZ4tFb6oOnmz8&r=v7nrKOXpTeI4XmMkkj8SJBbn-HgoUNrBuqAlNALoWmw&m=SEgsX4IdIcahNT90OQwuk5BSjtE8hiouVnRwa4npSdk&s=QFq-6UNLe6AJ3XRkYiegMh-jupZL78dNt9GWjDWK6D0&e=>

I hydrated it into the DB using the psql command on the installation page.  DHIS2 loads fine when it’s using H2 (albeit with no data), and I can click around and login etc.  But when it’s pointed at Postgres, I see the following in localhost.2014-09-12.log:
Sep 12, 2014 9:11:26 AM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Exception sending context initialized event to listener instance of class org.hisp.dhis.system.startup.StartupListener
java.lang.RuntimeException: Failed to run startup routines: null
        at org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:74)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4939)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5434)

Etc etc etc

Caused by: org.jasypt.exceptions.EncryptionOperationNotPossibleException
        at org.jasypt.encryption.pbe.StandardPBEByteEncryptor.decrypt(StandardPBEByteEncryptor.java:1055)
        at org.jasypt.encryption.pbe.StandardPBEStringEncryptor.decrypt(StandardPBEStringEncryptor.java:725)
        at org.jasypt.encryption.pbe.PooledPBEStringEncryptor.decrypt(PooledPBEStringEncryptor.java:498)

My suspicion is that the default.sql that comes in dhis2-demo.zip has a decryption password that is required to be supplied in hibernate.properties, but it’s not documented anywhere as far as I can tell.  Suggestions appreciated.
Sincerely,
----
Matthew P. Gordon, Ph.D.
Forward Deployed Engineer, Palantir Technologies
http://www.palantir.com
Email: mgordon@xxxxxxxxxxxx<mailto:mgordon@xxxxxxxxxxxx>
Mobile: +1-217-721-7600