← Back to team overview

dhis2-users team mailing list archive

Re: How do I change databases in dhis2?

 

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
>

Follow ups

References