dhis2-users team mailing list archive

[Adam Dawoodjee <adam.daveed@xxxxxxxxx>]

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

On Wed, Mar 23, 2016 at 9:20 AM, Adam Dawoodjee <adam.daveed@xxxxxxxxx>
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@xxxxxxxxx> wrote:
>
>> Hi Adam,
>>
>> What is inside your setenv.sh file?
>>
>> On Wed, Mar 23, 2016 at 7:57 AM, Adam Dawoodjee <adam.daveed@xxxxxxxxx>
>> 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 <http://www.agriculture.gov.zm:8080/api>Current
>>> user:adminVersion:2.21Build revision:21057Build date:2016-03-22 11:55User
>>> agent:Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML,
>>> like Gecko) Chrome/49.0.2623.87 Safari/537.36Server date:2016-03-22
>>> 23:11Last analytics table generation:Time since last analytics table
>>> generation:Last analytics table runtime:Environment variable:DHIS2_HOMEExternal
>>> configuration directory:/home/dhis/configDatabase type:DhisH2Database
>>> name:
>>> dhis2;DB_CLOSE_DELAY=-1;MVCC=TRUE;ALIAS_COLUMN_NAME=TRUE;DB_CLOSE_ON_EXIT=FALSEDatabase
>>> user:saJava opts:-Xmx7500m -Xms4000mJava home:
>>> /usr/lib/jvm/java-8-oracle/jreJava temporary directory:
>>> /home/dhis/tomcat-dhis/tempJava version:1.8.0_74Java vendor:Oracle
>>> CorporationOS name:LinuxOS architecture:amd64OS version:4.2.0-34-genericServer
>>> memory:Mem Total in JVM: 4924 Free in JVM: 2984 Max Limit: 6667CPU
>>> cores:8
>>>
>>> ________________________
>>>
>>> On Tue, Mar 22, 2016 at 11:23 PM, Adam Dawoodjee <adam.daveed@xxxxxxxxx>
>>> wrote:
>>>
>>>> Following Knut Staring's guidance here
>>>> https://lists.launchpad.net/dhis2-users/msg03086.html. I have:
>>>>
>>>> 1. copied the setenv.sh file from tomcat-dhis/bin/setenv.sh to
>>>> /usr/share/tomcat
>>>> 7/bin/setenv.sh
>>>> 2. 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
>>
>
>