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

Email: mgordon@palantir.com

Mobile: +1-217-721-7600

Hi Matt,

that’s an oops. I will update the demo database in a moment.

As a quick fix you can run these SQL statements locally and restart:

update configuration set remoteserverpassword=null;

update configuration set smptpassword=null;

best regards,

Lars

···

On Fri, Sep 12, 2014 at 12:45 PM, Matthew Gordon mgordon@palantir.com wrote:

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@palantir.com

Mobile: +1-217-721-7600


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp