This topic needs a title

" <dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>=

Hey all, new DHIS2 user/administrator here, trying to install DHIS2 so I ca=
n learn how to interoperate with the API. I have set up DHIS2 with Postgre=
s 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, an=
d downloaded the sample data from here:
https://www.dhis2.org/download/resources/dhis2-demo.zip<https://urldefense.=
proofpoint.com/v2/url?u=3Dhttps-3A__www.dhis2.org_download_resources_dhis2-=
2Ddemo.zip&d=3DAAMF-g&c=3Dizlc9mHr637UR4lpLEZLFFS3Vn2UXBrZ4tFb6oOnmz8&r=3Dv=
7nrKOXpTeI4XmMkkj8SJBbn-HgoUNrBuqAlNALoWmw&m=3DSEgsX4IdIcahNT90OQwuk5BSjtE8=
hiouVnRwa4npSdk&s=3DQFq-6UNLe6AJ3XRkYiegMh-jupZL78dNt9GWjDWK6D0&e=3D>

I hydrated it into the DB using the psql command on the installation page. =
DHIS2 loads fine when it=92s using H2 (albeit with no data), and I can cli=
ck around and login etc. But when it=92s pointed at Postgres, I see the fo=
llowing in localhost.2014-09-12.log:
Sep 12, 2014 9:11:26 AM org.apache.catalina.core.StandardContext listenerSt=
art
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(StandardC=
ontext.java:4939)
        at org.apache.catalina.core.StandardContext.startInternal(StandardC=
ontext.java:5434)

Etc etc etc

Caused by: org.jasypt.exceptions.EncryptionOperationNotPossibleException
        at org.jasypt.encryption.pbe.StandardPBEByteEncryptor.decrypt(Stand=
ardPBEByteEncryptor.java:1055)
        at org.jasypt.encryption.pbe.StandardPBEStringEncryptor.decrypt(Sta=
ndardPBEStringEncryptor.java:725)
        at org.jasypt.encryption.pbe.PooledPBEStringEncryptor.decrypt(Poole=
dPBEStringEncryptor.java:498)

My suspicion is that the default.sql that comes in dhis2-demo.zip has a dec=
ryption password that is required to be supplied in hibernate.properties, b=
ut it=92s not documented anywhere as far as I can tell. Suggestions apprec=
iated.
Sincerely,

ยทยทยท

Subject: [Dhis2-users] Problems setting up demo database
----
Matthew P. Gordon, Ph.D.
Forward Deployed Engineer, Palantir Technologies


Email: mgordon@palantir.com<mailto:mgordon@palantir.com>
Mobile: +1-217-721-7600

--_000_D0387652F2B1mgordonpalantircom_
Content-Type: text/html; charset="Windows-1252"
Content-ID: <81EE7FFE8DE28241B653567A12AEA681@palantir.com>
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DWindows-1=
252">
</head>
<body style=3D"word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-lin=
e-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-fami=
ly: Calibri, sans-serif;">
<div>
<div>
<div>Thanks Lars, that fixed it!</div>
<div><br>
</div>
<div>
<div>
<div>----</div>
<div>Matthew P. Gordon, Ph.D.</div>
</div>
<div>Forward Deployed Engineer, Palantir Technologies</div>
<div>http://www.palantir.com</div>
<div>Email: mgordon@palantir.com</div>
<div>Mobile: &#43;1-217-721-7600</div>
</div>
</div>
</div>
<div><br>
</div>
<span id=3D"OLK_SRC_BODY_SECTION">
<div style=3D"font-family:Calibri; font-size:11pt; text-align:left; color:b=
lack; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM:=
0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid;=
BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<span style=3D"font-weight:bold">From: </span>Matt Gordon &lt;<a href=3D"ma=
ilto:mgordon@palantir.com">mgordon@palantir.com</a>&gt;<br>
<span style=3D"font-weight:bold">Date: </span>Friday, September 12, 2014 at=
9:45 AM<br>
<span style=3D"font-weight:bold">To: </span>&quot;<a href=3D"mailto:dhis2-u=
sers@lists.launchpad.net">dhis2-users@lists.launchpad.net</a>&quot; &lt;<a =
href=3D"mailto:dhis2-users@lists.launchpad.net">dhis2-users@lists.launchpad=
.net</a>&gt;<br>
<span style=3D"font-weight:bold">Subject: </span>[Dhis2-users] Problems set=
ting up demo database<br>
</div>
<div><br>
</div>
<div>
<div style=3D"word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line=
-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-famil=
y: Calibri, sans-serif;">
<div>Hey all, new DHIS2 user/administrator here, trying to install DHIS2 so=
I can learn how to interoperate with the API. &nbsp;I have set up DHIS2 wi=
th Postgres using enterprise Tomcat 7 on CentOS 6.5 (CentOS is our default =
VM distro.) &nbsp;I created a dhis2 DB using
the instructions on the installation page, and downloaded the sample data =
from here:</div>
<div><a href=3D"https://urldefense.proofpoint.com/v2/url?u=3Dhttps-3A__www.=
dhis2.org_download_resources_dhis2-2Ddemo.zip&amp;d=3DAAMF-g&amp;c=3Dizlc9m=
Hr637UR4lpLEZLFFS3Vn2UXBrZ4tFb6oOnmz8&amp;r=3Dv7nrKOXpTeI4XmMkkj8SJBbn-HgoU=
NrBuqAlNALoWmw&amp;m=3DSEgsX4IdIcahNT90OQwuk5BSjtE8hiouVnRwa4npSdk&amp;s=3D=
QFq-6UNLe6AJ3XRkYiegMh-jupZL78dNt9GWjDWK6D0&amp;e=3D">https://www.dhis2.org=
/download/resources/dhis2-demo.zip</a></div>
<div><br>
</div>
<div>I hydrated it into the DB using the psql command on the installation p=
age. &nbsp;DHIS2 loads fine when it=92s using H2 (albeit with no data), and=
I can click around and login etc. &nbsp;But when it=92s pointed at Postgre=
s, I see the following in&nbsp;localhost.2014-09-12.log:</div>
<div>
<div>Sep 12, 2014 9:11:26 AM org.apache.catalina.core.StandardContext liste=
nerStart</div>
<div>SEVERE: Exception sending context initialized event to listener instan=
ce of class org.hisp.dhis.system.startup.StartupListener</div>
<div>java.lang.RuntimeException: Failed to run startup routines: null</div>
<div>&nbsp; &nbsp; &nbsp; &nbsp; at org.hisp.dhis.system.startup.StartupLis=
tener.contextInitialized(StartupListener.java:74)</div>
<div>&nbsp; &nbsp; &nbsp; &nbsp; at org.apache.catalina.core.StandardContex=
t.listenerStart(StandardContext.java:4939)</div>
<div>&nbsp; &nbsp; &nbsp; &nbsp; at org.apache.catalina.core.StandardContex=
t.startInternal(StandardContext.java:5434)</div>
</div>
<div><br>
</div>
<div>Etc etc etc</div>
<div><br>
</div>
<div>
<div>Caused by: org.jasypt.exceptions.EncryptionOperationNotPossibleExcepti=
on</div>
<div>&nbsp; &nbsp; &nbsp; &nbsp; at org.jasypt.encryption.pbe.StandardPBEBy=
teEncryptor.decrypt(StandardPBEByteEncryptor.java:1055)</div>
<div>&nbsp; &nbsp; &nbsp; &nbsp; at org.jasypt.encryption.pbe.StandardPBESt=
ringEncryptor.decrypt(StandardPBEStringEncryptor.java:725)</div>
<div>&nbsp; &nbsp; &nbsp; &nbsp; at org.jasypt.encryption.pbe.PooledPBEStri=
ngEncryptor.decrypt(PooledPBEStringEncryptor.java:498)</div>
</div>
<div><br>
</div>
<div>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.properti=
es, but it=92s not documented anywhere as far as I can tell. &nbsp;Suggesti=
ons appreciated.</div>
<div>Sincerely,</div>
<div>
<div>
<div>----</div>
<div>Matthew P. Gordon, Ph.D.</div>
</div>
<div>Forward Deployed Engineer, Palantir Technologies</div>
<div><a href=3D"http://www.palantir.com">http://www.palantir.com</a></div>
<div>Email: <a href=3D"mailto:mgordon@palantir.com">mgordon@palantir.com</a=

</div>

<div>Mobile: &#43;1-217-721-7600</div>
</div>
</div>
</div>
</span>
</body>
</html>

--_000_D0387652F2B1mgordonpalantircom_--