← Back to team overview

dhis2-users team mailing list archive

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

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
Mobile: +1-217-721-7600

Follow ups