dhis2-users team mailing list archive
-
dhis2-users team
-
Mailing list archive
-
Message #09745
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