DHIS2.24 linking to a wrong database

Dear All,

I am setting up DHIS2 to run on Ubuntu 16.04 server and PostgreSQL database but after setting up all the configuration settings in the dhis.conf and exporting the environmental variables in the tomcat-dhis instance, it still points to a different H2 database (dhis2;DB_CLOSE_DELAY=-1;MVCC=TRUE;ALIAS_COLUMN_NAME=TRUE;DB_CLOSE_ON_EXIT=FALSE) and a mysterious user (sa) database type DhisH2. This causes the system to loose all the data up on restart. This issue was raised by some one early this year but unfortunately i cannot find a solution. If anyone knows the solution, please support me.

Thank you.

Absolom

Absolom,
Kindly check the hibernate.properties or dhis.conf file again. It is
responsible to point DHIS2 to the right database.

···

On 10/27/16, Absolom MURAMIRA <absolom_m@yahoo.com> wrote:

Dear All,
I am setting up DHIS2 to run on Ubuntu 16.04 server and PostgreSQL database
but after setting up all the configuration settings in the dhis.conf and
exporting the environmental variables in the tomcat-dhis instance, it still
points to a different H2 database
(dhis2;DB_CLOSE_DELAY=-1;MVCC=TRUE;ALIAS_COLUMN_NAME=TRUE;DB_CLOSE_ON_EXIT=FALSE)
and a mysterious user (sa) database type DhisH2. This causes the system to
loose all the data up on restart. This issue was raised by some one early
this year but unfortunately i cannot find a solution. If anyone knows the
solution, please support me.
Thank you.
Absolom

--
Regards,

Gerald

Which version of Dhis2? As Gerald says, you could share your dhis.conf content (remove your password).

···

On Oct 29, 2016 4:13 PM, “gerald thomas” gerald17006@gmail.com wrote:

Absolom,

Kindly check the hibernate.properties or dhis.conf file again. It is

responsible to point DHIS2 to the right database.

On 10/27/16, Absolom MURAMIRA absolom_m@yahoo.com wrote:

Dear All,

I am setting up DHIS2 to run on Ubuntu 16.04 server and PostgreSQL database

but after setting up all the configuration settings in the dhis.conf and

exporting the environmental variables in the tomcat-dhis instance, it still

points to a different H2 database

(dhis2;DB_CLOSE_DELAY=-1;MVCC=TRUE;ALIAS_COLUMN_NAME=TRUE;DB_CLOSE_ON_EXIT=FALSE)

and a mysterious user (sa) database type DhisH2. This causes the system to

loose all the data up on restart. This issue was raised by some one early

this year but unfortunately i cannot find a solution. If anyone knows the

solution, please support me.

Thank you.

Absolom

Regards,

Gerald


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