I overlooked that you posted the content of dhis.conf. It seems fine, probably the issue was just the naming of the file.
And as Jason says, you now should immediately change all your passwords, since you have shared them with everyone on the list:
···
On Wed, Mar 23, 2016 at 8:31 AM, Jason Pickering jason.p.pickering@gmail.com wrote:
And change all of the passwords while you are at it, since this is a public mailing list!
–
On Wed, Mar 23, 2016 at 8:29 AM, Knut Staring knutst@gmail.com wrote:
Before changing to 2.22, just rename dhis.conf to hibernate.properties and restart tomcat.
You don’t need ROOT.war. Just stop tomcat, delete the webapps/dhis folder and place the 2.22 war file in webapps.
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
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049
–
On Wed, Mar 23, 2016 at 8:25 AM, Adam Dawoodjee adam.daveed@gmail.com wrote:
I dont have the /home/dhis/config/hibernate.properties file. And don’t know what should go in there. I’m running 2.21 as thats what was in the install docs, I thought because its the current stable release.
Do you recommend that I switch to 2.22? If so is it just a matter of replacing the ROOT.war file and dhis directory under webapps?
–
Adam
–
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
On Wed, Mar 23, 2016 at 9:20 AM, Adam Dawoodjee adam.daveed@gmail.com wrote:
My /home/dhis/tomcat-dhis/bin/setenv.sh contains:
#!/bin/sh
CATALINA_HOME=/usr/share/tomcat7
export JAVA_HOME=‘/usr/lib/jvm/java-8-oracle/’
export JAVA_OPTS=‘-Xmx7500m -Xms4000m’
export DHIS2_HOME=‘/home/dhis/config’
The first existing directory is used for JAVA_HOME (if JAVA_HOM
E is not
defined in $DEFAULT)
JDK_DIRS="/usr/lib/jvm/java-6-openjdk /usr/lib/jvm/java-6-sun /us
r/lib/jvm/java-1.5.0-sun /usr/lib/j2sdk1.5-sun /usr/lib/j2sdk1.5-
ibm"
Look for the right JVM to use
for jdir in $JDK_DIRS; do
if [ -r "$jdir/bin/java" -a -z "${JAVA_HOME}" ]; then
JAVA_HOME_TMP="$jdir"
# checks for a real JDK like environment, needed to check
if
# really the java-gcj-compat-dev package is installed
if [ -r "$jdir/bin/jdb" ]; then
JAVA_HOME="$JAVA_HOME_TMP"
fi
fi
done
Default Java options
if [ -z “$JAVA_OPTS” ]; then
JAVA_OPTS="-Djava.awt.headless=true -Xmx128M"
fi
And just in case my /home/dhis/config/dhis.conf contains:
Hibernate SQL dialect
connection.dialect = org.hibernate.dialect.PostgreSQLDialect
JDBC driver class
connection.driver_class = org.postgresql.Driver
JDBC driver connection URL
connection.url = jdbc:postgresql:dhis2
Database username
connection.username = dhis
Database password
connection.password = mal@Gov16
Database schema behavior, can be validate, update, create, crea
te-drop
connection.schema = update
Encryption password (sensitive)
encryption.password = m!N!stryOfAgr!c16@MAL
File store provider. Currently ‘filesystem’ and ‘aws-s3’ are su
pported.
filestore.provider = filesystem
Directory / bucket name. Refers to subdirectory in external dir
ectory on file system and bucket on AWS S3.
filestore.container = files
Thank you,
Adam
On Wed, Mar 23, 2016 at 9:10 AM, Knut Staring knutst@gmail.com wrote:
Hi Adam,
What is inside your setenv.sh file?
On Wed, Mar 23, 2016 at 7:57 AM, Adam Dawoodjee adam.daveed@gmail.com wrote:
Hello,
@Gerald I’m running my installation DHIS2 installation on Ubuntu Server 14.04.
@Knut The contents of my /home/dhis/tomcat-dhis are as below:
dhis@websever:~$ ls tomcat-dhis
bin conf logs temp webapps work
Below is my complete environment:
Web API:
Browse it here
Current user:
admin
Version:
2.21
Build revision:
21057
Build date:
2016-03-22 11:55
User agent:
Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.87 Safari/537.36
Server date:
2016-03-22 23:11
Last analytics table generation:
Time since last analytics table generation:
Last analytics table runtime:
Environment variable:
DHIS2_HOME
External configuration directory:
/home/dhis/configDatabase type:DhisH2Database name:dhis2;DB_CLOSE_DELAY=-1;MVCC=TRUE;ALIAS_COLUMN_NAME=TRUE;DB_CLOSE_ON_EXIT=FALSE
Database user:
sa
Java opts:
-Xmx7500m -Xms4000m
Java home:
/usr/lib/jvm/java-8-oracle/jre
Java temporary directory:
/home/dhis/tomcat-dhis/temp
Java version:
1.8.0_74
Java vendor:
Oracle Corporation
OS name:
Linux
OS architecture:
amd64
OS version:
4.2.0-34-generic
Server memory:
Mem Total in JVM: 4924 Free in JVM: 2984 Max Limit: 6667
CPU cores:
8
–
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
On Tue, Mar 22, 2016 at 11:23 PM, Adam Dawoodjee adam.daveed@gmail.com wrote:
Following Knut Staring’s guidance here https://lists.launchpad.net/dhis2-users/msg03086.html. I have:
- copied the setenv.sh file from tomcat-dhis/bin/setenv.sh to /usr/share/tomcat
7/bin/setenv.sh
- Completed steps 8.3.5 and 8.3.6 of the implementation guide and placed the dhis.conf file in the /home/dhis/config directory.
But my database still says H2.
Kind regards,
Adam
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org